pgsql: Expand virtual generated columns in constraint expressions

Started by Peter Eisentraut9 months ago1 messagescomitters

peter_e@gmx.net

9 months ago

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 <guofenglinux@gmail.com>
Discussion: /messages/by-id/204804c0-798f-4c72-bd1f-36116024fda3@eisentraut.org

Branch
------
REL_18_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/e7a2bbdb522dd6fc7283550742b8b52605198783

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(+)