-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: support MACADDR type #45813
Copy link
Copy link
Open
Labels
A-sql-pgcompatSemantic compatibility with PostgreSQLSemantic compatibility with PostgreSQLC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)E-starterMight be suitable for a starter project for new employees or team members.Might be suitable for a starter project for new employees or team members.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Description
Metadata
Metadata
Assignees
Labels
A-sql-pgcompatSemantic compatibility with PostgreSQLSemantic compatibility with PostgreSQLC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)E-starterMight be suitable for a starter project for new employees or team members.Might be suitable for a starter project for new employees or team members.T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)SQL Foundations Team (formerly SQL Schema + SQL Sessions)
Postgres has a set of data types to handle network addresses such as MACADDR, CIDR, and INET. http://etutorials.org/SQL/Postgresql/Part+I+General+PostgreSQL+Use/Chapter+2.+Working+with+Data+in+PostgreSQL/Network+Address+Data+Types/
CockroachDB talks about some of these here, #18846 but doesn't talk about the MACADDR data type which is needed by large organizations which want to use CockroachDB to track data center info.
Describe the solution you'd like
Support the network data types as per Postgres.
Describe alternatives you've considered
This can be done using text data types, but it doesn't have the same verification.
Jira issue: CRDB-5128
Epic CRDB-60812