Thread: pgsql: Add more tests for CREATE TABLE AS with WITH NO DATA
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 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/537898bd81bd8bd3650846e0abde4298ff1373da Modified Files -------------- src/test/regress/expected/prepare.out | 7 +++++++ src/test/regress/expected/select_into.out | 7 ++++--- src/test/regress/sql/prepare.sql | 3 +++ src/test/regress/sql/select_into.sql | 7 ++++--- 4 files changed, 18 insertions(+), 6 deletions(-)