]> granicus.if.org Git - postgresql/commit
Add more tests for CREATE TABLE AS with WITH NO DATA
authorMichael Paquier <michael@paquier.xyz>
Thu, 7 Feb 2019 00:21:57 +0000 (09:21 +0900)
committerMichael Paquier <michael@paquier.xyz>
Thu, 7 Feb 2019 00:21:57 +0000 (09:21 +0900)
commit537898bd81bd8bd3650846e0abde4298ff1373da
tree36bf143e48b904394e829076386d909829cdb21a
parenteba775345d23d2c999bbb412ae658b6dab36e3e8
Add more tests for CREATE TABLE AS with WITH NO DATA

The relation creation is done at executor startup, however the main
regression test suite is lacking scenarios where no data is inserted
which is something that can happen when using EXECUTE or EXPLAIN with
CREATE TABLE AS and WITH NO DATA.

Some patches are worked on to reshape the way CTAS relations are
created, so this makes sure that we do not miss some query patterns
already supported.

Reported-by: Andreas Karlsson
Author: Michael Paquier
Reviewed-by: Andreas Karlsson
Discussion: https://postgr.es/m/20190206091817.GB14980@paquier.xyz
src/test/regress/expected/prepare.out
src/test/regress/expected/select_into.out
src/test/regress/sql/prepare.sql
src/test/regress/sql/select_into.sql