]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix core dump in transformValuesClause when there are no columns.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 9 May 2022 18:15:37 +0000 (14:15 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 9 May 2022 18:15:37 +0000 (14:15 -0400)
commit539f8c563ce70cecb1d45f026015162ca52c7306
treec2a8756715db3c7b69e380708d121de3618f601a
parentc0406fa768edd6b9e4bb543b04c871cd80f03934
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
src/backend/parser/analyze.c
src/test/regress/expected/select.out
src/test/regress/sql/select.sql