]> granicus.if.org Git - postgresql/commit
Back-patch code to deduce implied equalities from transitivity of
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 23 Sep 2000 23:50:47 +0000 (23:50 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 23 Sep 2000 23:50:47 +0000 (23:50 +0000)
commit730e2ffebc98977366ec717a0f89345425e02eb1
tree7ac97764d3e565d7e9a67969d1e742dde6c8856f
parent783af51cb1fc27218bec7137c7a138eefb1d76e4
Back-patch code to deduce implied equalities from transitivity of
mergejoin clauses, and add these equalities to the given WHERE clauses.
This is necessary to ensure that sort keys we think are equivalent
really are equivalent as soon as their rels have been joined.  Without
this, 7.0 may create an incorrect mergejoin plan.
src/backend/optimizer/path/pathkeys.c
src/backend/optimizer/plan/initsplan.c
src/backend/optimizer/plan/planmain.c
src/include/optimizer/paths.h
src/include/optimizer/planmain.h