]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Deduce equality constraints that are implied by transitivity of
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 24 Jul 2000 03:11:01 +0000 (03:11 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 24 Jul 2000 03:11:01 +0000 (03:11 +0000)
commitcd9f0ca5456c0fc2c6190321a8156609ef9f573d
treea2a304b236a0fd12901e781adc587ab2cbcef826
parentc39c198bc333363c7a74e6e8c91b57466027ec3d
Deduce equality constraints that are implied by transitivity of
mergejoinable qual clauses, and add them to the query quals.  For
example, WHERE a = b AND b = c will cause us to add AND a = c.
This is necessary to ensure that it's safe to use these variables
as interchangeable sort keys, which is something 7.0 knows how to do.
Should provide a useful improvement in planning ability, too.
src/backend/optimizer/README
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