cockroachdb / cockroachdb/cockroach
sql: support jsonpath table columns
Open
A-sql-pgcompat
C-enhancement
O-qa
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
We currently disallow a table to be created with a `JSONPATH` column:
```
root@localhost:26257/defaultdb> CREATE TABLE t (j JSONPATH);
ERROR: value type jsonpath cannot be used for table columns
SQLSTATE: 42P16
```
This is a tracking issue, since Postgres does allow this. Also, we should consider adding this issue number to the error message.
Jira issue: CRDB-49602
Contributor guide
Assessment
This issue has not been assessed yet.