Skip to content

sql: allow ARRAYs in forward indexes #17154

Closed
#91762
#48045
Closed
sql: allow ARRAYs in forward indexes#17154
#91762
#48045
Labels
A-sql-encodingRelating to the SQL/KV encoding.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)O-communityOriginated from the communityX-anchored-telemetryThe issue number is anchored by telemetry references.
@justinj

Description

@justinj
justinj
opened on Jul 20, 2017

Arrays support inverted indexes, but not forward indexes. If you want to index arrays, starting in CockroachDB 20.1 consider using an inverted index on your column.

This issue tracks adding forward indexes to array types.

Jira issue: CRDB-6049

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-encodingRelating to the SQL/KV encoding.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)O-communityOriginated from the communityX-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