opt: infinite recursion between EliminateGroupByProject and PruneGroupByCols #100478
Description
Some queries can cause the optimizer to recurse indefinitley between two normalization rules, EliminateGroupByProject and PruneGroupByCols. Below is an optimizer test that reproduces the infinite recursion:
exec-ddl
CREATE TABLE p (
region STRING NOT NULL,
id INT,
PRIMARY KEY (region, id),
UNIQUE INDEX p_id_idx (id)
)
----
exec-ddl
CREATE TABLE c (
region STRING NOT NULL,
id INT PRIMARY KEY,
p_id INT NOT NULL,
FOREIGN KEY (region, p_id) REFERENCES p (region, id)
)
----
norm
SELECT p.id FROM p JOIN c ON p_id = p.id GROUP BY p.id
----
Jira issue: CRDB-26457
Metadata
Metadata
Assignees
Labels
Type
Projects
Status