search

cockroachdb / cockroach

CockroachDB - the open source, cloud-native distributed SQL database.
https://www.cockroachlabs.com
Other
29.5k stars 3.7k forks source link

sql: support MACADDR type #45813

Open randmark opened 4 years ago

randmark commented 4 years ago

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, https://github.com/cockroachdb/cockroach/issues/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

jordanlewis commented 3 years ago

I've renamed this to talk specifically about MACADDR, since as you note, #18846 discusses CIDR.

github-actions[bot] commented 9 months ago

We have marked this issue as stale because it has been inactive for 18 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB!

KempWatson commented 9 months ago

Still very relevant for us.... per the original post, "the MACADDR data type which is needed by large organizations which want to use CockroachDB to track data center info". INET was finally added, but there remains no support for CIDR, MACADDR, or MACADDR8. This cuts out a whole range of network applications, gives them straight to the guys with the "Y" in their name.