-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: improved partial index implication with virtual columns #61565
Copy link
Copy link
Open
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-sql-queriesSQL Queries TeamSQL Queries Team
Description
The issue tracks figuring out how to prove implication (and thus enable the use of the partial index) for cases like:
CREATE TABLE t (
k INT PRIMARY KEY,
a INT,
b INT,
c INT AS (b + 10) VIRTUAL,
INDEX (a) WHERE c IN (10, 20, 30)
)
SELECT k FROM t WHERE c = 20
Jira issue: CRDB-2993
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.T-sql-queriesSQL Queries TeamSQL Queries Team
Type
Projects
Status
Backlog