Skip to content

sql: support ordering by array columns #35707

Closed
#48045
Closed
sql: support ordering by array columns#35707
#48045
Labels
A-sql-optimizerSQL logical planning and optimizations.A-sql-pgcompatSemantic compatibility with PostgreSQLC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)X-anchored-telemetryThe issue number is anchored by telemetry references.
@knz

Description

@knz
knz
opened on Mar 13, 2019

Currently it's not possible to order a table by an array column.

This is because arrays do not have a valid lexicographic ordering.

for reference, PostgreSQL supports it.

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-optimizerSQL logical planning and optimizations.A-sql-pgcompatSemantic compatibility with PostgreSQLC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)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