cockroachdb / cockroachdb/cockroach
sql: collation using pg_catalog.default does not work
Open
A-sql-pgcompat
C-enhancement
O-support
P-3
T-sql-foundations
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Currently CRDB does not support the builtin collation pg_catalog.default, which makes it incompatible with PostgresSQL. For example we support the following:
```
select 'a' < ('foo' COLLATE default);
```
but on Postgres the following is valid syntax as well.
```
select 'a' < ('foo' COLLATE pg_catalog.default);
```
Jira issue: CRDB-38613
Epic CRDB-60815
Contributor guide
Assessment
This issue has not been assessed yet.