Expand virtual generated columns in constraint expressions Virtual generated columns in constraint expressions need to be expanded because the optimizer matches these expressions to qual clauses. Failing to do so can cause us to miss opportunities for constraint exclusion.
Author: Richard Guo <[email protected]> Discussion: https://www.postgresql.org/message-id/flat/204804c0-798f-4c72-bd1f-36116024fda3%40eisentraut.org Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/ce71993ae46930ddb1ff790807114384898b86a7 Modified Files -------------- src/backend/optimizer/util/plancat.c | 9 +++++++++ src/test/regress/expected/generated_virtual.out | 23 +++++++++++++++++++++++ src/test/regress/sql/generated_virtual.sql | 15 +++++++++++++++ 3 files changed, 47 insertions(+)
