diff options
Diffstat (limited to 'src/test')
-rw-r--r-- | src/test/regress/expected/select.out | 7 | ||||
-rw-r--r-- | src/test/regress/sql/select.sql | 5 |
2 files changed, 12 insertions, 0 deletions
diff --git a/src/test/regress/expected/select.out b/src/test/regress/expected/select.out index 7ad1f0bc773..53fda82f77d 100644 --- a/src/test/regress/expected/select.out +++ b/src/test/regress/expected/select.out @@ -517,6 +517,13 @@ TABLE int8_tbl; 4567890123456789 | -4567890123456789 (9 rows) +-- corner case: VALUES with no columns +CREATE TEMP TABLE nocols(); +INSERT INTO nocols DEFAULT VALUES; +SELECT * FROM nocols n, LATERAL (VALUES(n.*)) v; +-- +(1 row) + -- -- Test ORDER BY options -- diff --git a/src/test/regress/sql/select.sql b/src/test/regress/sql/select.sql index fdab06d5bc1..0b040abba9e 100644 --- a/src/test/regress/sql/select.sql +++ b/src/test/regress/sql/select.sql @@ -148,6 +148,11 @@ SELECT 2+2, 57 UNION ALL TABLE int8_tbl; +-- corner case: VALUES with no columns +CREATE TEMP TABLE nocols(); +INSERT INTO nocols DEFAULT VALUES; +SELECT * FROM nocols n, LATERAL (VALUES(n.*)) v; + -- -- Test ORDER BY options -- |