pgsql: Fix core dump in transformValuesClause when there are no columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix core dump in transformValuesClause when there are no columns
Date: 2022-05-09 18:15:59
Message-ID: E1no7vK-000mer-8c@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix core dump in transformValuesClause when there are no columns.

The parser code that transformed VALUES from row-oriented to
column-oriented lists failed if there were zero columns.
You can't write that straightforwardly (though probably you
should be able to), but the case can be reached by expanding
a "tab.*" reference to a zero-column table.

Per bug #17477 from Wang Ke. Back-patch to all supported branches.

Discussion: https://postgr.es/m/17477-0af3c6ac6b0a6ae0@postgresql.org

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/91a3a74c65f4094420b28c393ac1d38af8ae4c4a

Modified Files
--------------
src/backend/parser/analyze.c | 21 +++++++--------------
src/test/regress/expected/select.out | 7 +++++++
src/test/regress/sql/select.sql | 5 +++++
3 files changed, 19 insertions(+), 14 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2022-05-09 18:30:50 pgsql: Last-minute updates for release notes.
Previous Message Tom Lane 2022-05-09 15:41:31 pgsql: Revert "Disallow infinite endpoints in generate_series() for tim