Skip to content

sql: support sql arrays of JSONB #23468

Open
Open
sql: support sql arrays of JSONB#23468
Labels
A-sql-datatypesSQL column types usable in table descriptors.A-sql-jsonJSON handling in SQL.A-tools-postgrestA-tools-prismaC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)X-anchored-telemetryThe issue number is anchored by telemetry references.
@justinj

Description

@justinj
justinj
opened on Mar 6, 2018

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.

Jira issue: CRDB-5816

Epic CRDB-60819

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-datatypesSQL column types usable in table descriptors.A-sql-jsonJSON handling in SQL.A-tools-postgrestA-tools-prismaC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)X-anchored-telemetryThe issue number is anchored by telemetry references.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions