Horton

Fix core dump in transformValuesClause when there are no columns.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 4eabaffcada25206c3f8f89f7cb0b27ffb9372bc
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2022-05-09T18:15:37Z
Releases: 10.21 
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

Files

PathChange+/−
src/backend/parser/analyze.c modified +7 −14
src/test/regress/expected/select.out modified +7 −0
src/test/regress/sql/select.sql modified +5 −0

Discussion