Cockroach: sql: support sql arrays of JSONB

Created on 6 Mar 2018  路  1Comment  路  Source: cockroachdb/cockroach

Some discussion of this feature here.

We skipped over this for the time being since it caused some headaches with escaping.

knz edit (2019-03-13): the bigger problem is that arrays of jsonb do not have a proper lexicographic encoding. This can't be addressed properly until the sql/kv mapping is extended to support non-lexicographic orderings and lookups.

A-sql-datatypes A-sql-json C-enhancement X-anchored-telemetry
Source
picture justinj

Most helpful comment

Until this is complete, I think it'd be worth updating the documentation to show that JSON arrays are not yet supported:

https://www.cockroachlabs.com/docs/stable/data-types.html

"ARRAY: A 1-dimensional, 1-indexed, homogeneous array of any non-array data type."

picture dpkirchner on 26 Nov 2019
👍3

>All comments

Until this is complete, I think it'd be worth updating the documentation to show that JSON arrays are not yet supported:

https://www.cockroachlabs.com/docs/stable/data-types.html

"ARRAY: A 1-dimensional, 1-indexed, homogeneous array of any non-array data type."

dpkirchner picture dpkirchner on 26 Nov 2019
👍3
Was this page helpful?
0 / 5 - 0 ratings

Related issues

ajwerner picture ajwerner  路  4Comments
mjibson picture mjibson  路  3Comments
intech picture intech  路  3Comments
magaldima picture magaldima  路  3Comments
HeikoOnnebrink picture HeikoOnnebrink  路  4Comments