Обсуждение: pgsql: Prefer actual constants to pseudo-constants in equivalence class

Поиск
Список
Период
Сортировка

pgsql: Prefer actual constants to pseudo-constants in equivalence class

От
Tom Lane
Дата:
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_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/ff8f7103b559d8f19731157aca38650a938fedef

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