Skip to content

sql: SHOW RANGES does not properly compute object intersections #103665

Closed
#103667
Closed
sql: SHOW RANGES does not properly compute object intersections#103665
#103667
Assignees
knz
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.v23.1.2
@knz

Description

@knz
knz
opened on May 19, 2023

(Discovered while reviewing #103128)

The internal query used by SHOW RANGES computes span_start_key / span_end_key using the outermost object boundaries. This is incorrect - we want object boundaries on each row of output (with WITH INDEXES/TABLES) to be the local boundaries within the range for that row.

Epic: CRDB-24928

Jira issue: CRDB-28120

Metadata

Metadata

Assignees

Labels

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.v23.1.2

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions