pgsql: Prefer actual constants to pseudo-constants in equivalence class - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Prefer actual constants to pseudo-constants in equivalence class
Date
Msg-id E1TRoWc-0007Lj-C3@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Prefer actual constants to pseudo-constants in equivalence class machinery.

generate_base_implied_equalities_const() should prefer plain Consts over
other em_is_const eclass members when choosing the "pivot" value that
all the other members will be equated to.  This makes it more likely that
the generated equalities will be useful in constraint-exclusion proofs.
Per report from Rushabh Lathia.

Branch
------
REL9_2_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/7e951ba6e1de7bb77aef4ea2d0ef7d2be860f389

Modified Files
--------------
src/backend/optimizer/path/equivclass.c |   10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Prefer actual constants to pseudo-constants in equivalence class
Next
From: Tom Lane
Date:
Subject: pgsql: Prefer actual constants to pseudo-constants in equivalence class