Mark Sirek

release-21.2: xform: hoist projection from join only for canonical scans/selects

2

Backport 1/1 commits from #80212. /cc @cockroachdb/release --- Fixes #79943 Previously, HoistProjectFromInnerJoin would explore joins with the right input projection pulled up to the parent of the join, no matter...

release-22.1: xform: hoist projection from join only for canonical scans/selects

3

Backport 1/1 commits from #80212. /cc @cockroachdb/release --- Fixes #79943 Previously, HoistProjectFromInnerJoin would explore joins with the right input projection pulled up to the parent of the join, no matter...

sql:Hoist project session flag and support session settings in opt tests

1

**This commit adds the disable_hoist_projection_in_join_limitation session flag.** Release note: none opttester: support session settings in opt tests **This commit adds the `set` opttest flag which can be used to set...

xform: make FoldDivOne an essential normalization

1

Fixes #86790 This fixes sqlsmith errors caused by differences in the number of displayed digits right of the decimal place for `expression / 1` by making the folding of this...

[DNM] xform: sort-avoiding unconstrained non-covering index scan

8

Fixes https://github.com/cockroachlabs/support/issues/1453 and #77243 Previously, the optimizer did not explore plans which scan a non-covering index with no constraints, even if the index can provide a required ordering. This can...

Avoid sorts for descending ORDER BY on lookup join index columns

5

**Is your feature request related to a problem? Please describe.** #84689 improves the number of cases a sort is avoided for lookup join queries with ORDER BY on the lookup...