Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql: support '{abc}' syntax for uuid[] literal #54693

Closed
dt opened this issue Sep 23, 2020 · 1 comment
Closed

sql: support '{abc}' syntax for uuid[] literal #54693

dt opened this issue Sep 23, 2020 · 1 comment
Labels
A-sql-syntax Issues strictly related to the SQL grammar, with no semantic aspect C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

Comments

@dt
Copy link
Member

dt commented Sep 23, 2020

pg supports (and, importantly, emits) uuid[] literals in the form '{abc123-abc...}'

Cockroach currently does not, simply complaining that it is a string, since we do not implicitly convert the string to uuid[], though appending an explicit cast works (e.g. '{abc123-...}'::uuid[]).

Appending a cast or using the ARRAY[...] syntax provide alternatives for users writing queries by hand, but unfortunately some tools, like pg_dump emit the '{abc...}' form.

@dt dt added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) A-sql-syntax Issues strictly related to the SQL grammar, with no semantic aspect labels Sep 23, 2020
@jordanlewis
Copy link
Member

Duplicate of #54672

@jordanlewis jordanlewis marked this as a duplicate of #54672 Sep 23, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-sql-syntax Issues strictly related to the SQL grammar, with no semantic aspect C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Projects
None yet
Development

No branches or pull requests

2 participants