src/test/regress/expected/select_into_optimizer.out - cloudberry - Git at Google

 --
 -- SELECT_INTO
 --
 SELECT *
    INTO TABLE sitmp1
    FROM onek
    WHERE onek.unique1 < 2;
 DROP TABLE sitmp1;
 SELECT *
    INTO TABLE sitmp1
    FROM onek2
    WHERE onek2.unique1 < 2;
 DROP TABLE sitmp1;
 --
 -- SELECT INTO and INSERT permission, if owner is not allowed to insert.
 --
 CREATE SCHEMA selinto_schema;
 CREATE USER regress_selinto_user;
 ALTER DEFAULT PRIVILEGES FOR ROLE regress_selinto_user
 	  REVOKE INSERT ON TABLES FROM regress_selinto_user;
 GRANT ALL ON SCHEMA selinto_schema TO public;
 SET SESSION AUTHORIZATION regress_selinto_user;
 -- To pass ORCA tests, we need to ignore actual rows diffs.
 -- Because ORCA default distribution policy is random, so that the actual row
 -- number is uncertain.
 -- start_matchsubs
 --
 -- m/actual rows=\d+/
 -- s/\d+/XXX/g
 --
 -- end_matchsubs
 -- WITH DATA, passes.
 CREATE TABLE selinto_schema.tbl_withdata1 (a)
   AS SELECT generate_series(1,3) WITH DATA;
 INSERT INTO selinto_schema.tbl_withdata1 VALUES (4);
 ERROR:  permission denied for table tbl_withdata1
 EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
   CREATE TABLE selinto_schema.tbl_withdata2 (a) AS
   SELECT generate_series(1,3) WITH DATA;
                                   QUERY PLAN
 ------------------------------------------------------------------------------
  Result (actual rows=2 loops=1)
    ->  Redistribute Motion 3:3  (slice1; segments: 3) (actual rows=2 loops=1)
          ->  Result (actual rows=3 loops=1)
                One-Time Filter: (gp_execution_segment() = 0)
                ->  ProjectSet (actual rows=3 loops=1)
                      ->  Result (actual rows=1 loops=1)
  Optimizer: Pivotal Optimizer (GPORCA)
 (7 rows)

 -- WITH NO DATA, passes.
 CREATE TABLE selinto_schema.tbl_nodata1 (a) AS
   SELECT generate_series(1,3) WITH NO DATA;
 EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
   CREATE TABLE selinto_schema.tbl_nodata2 (a) AS
   SELECT generate_series(1,3) WITH NO DATA;
                               QUERY PLAN
 -----------------------------------------------------------------------
  Result (never executed)
    ->  Redistribute Motion 3:3  (slice1; segments: 3) (never executed)
          ->  Result (never executed)
                One-Time Filter: (gp_execution_segment() = 0)
                ->  ProjectSet (never executed)
                      ->  Result (never executed)
  Optimizer: Pivotal Optimizer (GPORCA)
 (7 rows)

 -- EXECUTE and WITH DATA, passes.
 PREPARE data_sel AS SELECT generate_series(1,3);
 CREATE TABLE selinto_schema.tbl_withdata3 (a) AS
   EXECUTE data_sel WITH DATA;
 EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
   CREATE TABLE selinto_schema.tbl_withdata4 (a) AS
   EXECUTE data_sel WITH DATA;
                                   QUERY PLAN
 ------------------------------------------------------------------------------
  Result (actual rows=1 loops=1)
    ->  Redistribute Motion 3:3  (slice1; segments: 3) (actual rows=1 loops=1)
          ->  Result (actual rows=3 loops=1)
                One-Time Filter: (gp_execution_segment() = 0)
                ->  ProjectSet (actual rows=3 loops=1)
                      ->  Result (actual rows=1 loops=1)
  Optimizer: Pivotal Optimizer (GPORCA)
 (7 rows)

 -- EXECUTE and WITH NO DATA, passes.
 CREATE TABLE selinto_schema.tbl_nodata3 (a) AS
   EXECUTE data_sel WITH NO DATA;
 EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
   CREATE TABLE selinto_schema.tbl_nodata4 (a) AS
   EXECUTE data_sel WITH NO DATA;
                               QUERY PLAN
 -----------------------------------------------------------------------
  Result (never executed)
    ->  Redistribute Motion 3:3  (slice1; segments: 3) (never executed)
          ->  Result (never executed)
                One-Time Filter: (gp_execution_segment() = 1)
                ->  ProjectSet (never executed)
                      ->  Result (never executed)
  Optimizer: Pivotal Optimizer (GPORCA)
 (7 rows)

 RESET SESSION AUTHORIZATION;
 ALTER DEFAULT PRIVILEGES FOR ROLE regress_selinto_user
 	  GRANT INSERT ON TABLES TO regress_selinto_user;
 SET SESSION AUTHORIZATION regress_selinto_user;
 RESET SESSION AUTHORIZATION;
 DEALLOCATE data_sel;
 DROP SCHEMA selinto_schema CASCADE;
 NOTICE:  drop cascades to 8 other objects
 DETAIL:  drop cascades to table selinto_schema.tbl_withdata1
 drop cascades to table selinto_schema.tbl_withdata2
 drop cascades to table selinto_schema.tbl_nodata1
 drop cascades to table selinto_schema.tbl_nodata2
 drop cascades to table selinto_schema.tbl_withdata3
 drop cascades to table selinto_schema.tbl_withdata4
 drop cascades to table selinto_schema.tbl_nodata3
 drop cascades to table selinto_schema.tbl_nodata4
 DROP USER regress_selinto_user;
 -- Tests for WITH NO DATA and column name consistency
 CREATE TABLE ctas_base (i int, j int);
 INSERT INTO ctas_base VALUES (1, 2);
 CREATE TABLE ctas_nodata (ii, jj, kk) AS SELECT i, j FROM ctas_base; -- Error
 ERROR:  too many column names were specified
 CREATE TABLE ctas_nodata (ii, jj, kk) AS SELECT i, j FROM ctas_base WITH NO DATA; -- Error
 ERROR:  too many column names were specified
 CREATE TABLE ctas_nodata (ii, jj) AS SELECT i, j FROM ctas_base; -- OK
 CREATE TABLE ctas_nodata_2 (ii, jj) AS SELECT i, j FROM ctas_base WITH NO DATA; -- OK
 CREATE TABLE ctas_nodata_3 (ii) AS SELECT i, j FROM ctas_base; -- OK
 CREATE TABLE ctas_nodata_4 (ii) AS SELECT i, j FROM ctas_base WITH NO DATA; -- OK
 SELECT * FROM ctas_nodata;
  ii | jj
 ----+----
   1 |  2
 (1 row)

 SELECT * FROM ctas_nodata_2;
  ii | jj
 ----+----
 (0 rows)

 SELECT * FROM ctas_nodata_3;
  ii | j
 ----+---
   1 | 2
 (1 row)

 SELECT * FROM ctas_nodata_4;
  ii | j
 ----+---
 (0 rows)

 DROP TABLE ctas_base;
 DROP TABLE ctas_nodata;
 DROP TABLE ctas_nodata_2;
 DROP TABLE ctas_nodata_3;
 DROP TABLE ctas_nodata_4;
 -- Test for WITH NO DATA on toast column
 CREATE TABLE ctas_base (i text);
 INSERT INTO ctas_base VALUES ('a');
 CREATE TABLE ctas_nodata AS SELECT i FROM ctas_base  WITH NO DATA; -- OK
 SELECT * FROM ctas_nodata;
  i
 ---
 (0 rows)

 DROP TABLE ctas_base;
 DROP TABLE ctas_nodata;
 --
 -- CREATE TABLE AS/SELECT INTO as last command in a SQL function
 -- have been known to cause problems
 --
 CREATE FUNCTION make_table() RETURNS VOID
 AS $$
   CREATE TABLE created_table AS SELECT * FROM int8_tbl;
 $$ LANGUAGE SQL;
 SELECT make_table();
  make_table
 ------------

 (1 row)

 SELECT * FROM created_table;
         q1        |        q2
 ------------------+-------------------
               123 |               456
               123 |  4567890123456789
  4567890123456789 |               123
  4567890123456789 |  4567890123456789
  4567890123456789 | -4567890123456789
 (5 rows)

 -- Try EXPLAIN ANALYZE SELECT INTO and EXPLAIN ANALYZE CREATE TABLE AS
 -- WITH NO DATA, but hide the outputs since they won't be stable.
 DO $$
 BEGIN
 	EXECUTE 'EXPLAIN ANALYZE SELECT * INTO TABLE easi FROM int8_tbl';
 	EXECUTE 'EXPLAIN ANALYZE CREATE TABLE easi2 AS SELECT * FROM int8_tbl WITH NO DATA';
 END$$;
 DROP TABLE created_table;
 DROP TABLE easi, easi2;
 --
 -- Disallowed uses of SELECT ... INTO.  All should fail
 --
 DECLARE foo CURSOR FOR SELECT 1 INTO b;
 ERROR:  SELECT ... INTO is not allowed here
 LINE 1: DECLARE foo CURSOR FOR SELECT 1 INTO b;
                                              ^
 COPY (SELECT 1 INTO frak UNION SELECT 2) TO 'blob';
 ERROR:  COPY (SELECT INTO) is not supported
 SELECT * FROM (SELECT 1 INTO f) bar;
 ERROR:  SELECT ... INTO is not allowed here
 LINE 1: SELECT * FROM (SELECT 1 INTO f) bar;
                                      ^
 CREATE VIEW foo AS SELECT 1 INTO b;
 ERROR:  views must not contain SELECT INTO
 INSERT INTO b SELECT 1 INTO f;
 ERROR:  SELECT ... INTO is not allowed here
 LINE 1: INSERT INTO b SELECT 1 INTO f;
                                     ^
 --
 -- Empty target list
 --
 explain (costs off) select into empty_tl from generate_series(0, 10);
 NOTICE:  Table doesn't have 'DISTRIBUTED BY' clause. Creating a NULL policy entry.
                          QUERY PLAN
 -------------------------------------------------------------
  Result
    ->  Redistribute Motion 3:3  (slice1; segments: 3)
          ->  Result
                One-Time Filter: (gp_execution_segment() = 2)
                ->  Function Scan on generate_series
  Optimizer: GPORCA
 (6 rows)

 select into empty_tl from generate_series(0, 10);
 NOTICE:  Table doesn't have 'DISTRIBUTED BY' clause. Creating a NULL policy entry.
 select * from empty_tl;
 --
 (11 rows)

 drop table empty_tl;
 -- Test CREATE TABLE AS ... IF NOT EXISTS
 CREATE TABLE ctas_ine_tbl AS SELECT 1;
 CREATE TABLE ctas_ine_tbl AS SELECT 1 / 0; -- error
 ERROR:  relation "ctas_ine_tbl" already exists
 CREATE TABLE IF NOT EXISTS ctas_ine_tbl AS SELECT 1 / 0; -- ok
 NOTICE:  relation "ctas_ine_tbl" already exists, skipping
 CREATE TABLE ctas_ine_tbl AS SELECT 1 / 0 WITH NO DATA; -- error
 ERROR:  relation "ctas_ine_tbl" already exists
 CREATE TABLE IF NOT EXISTS ctas_ine_tbl AS SELECT 1 / 0 WITH NO DATA; -- ok
 NOTICE:  relation "ctas_ine_tbl" already exists, skipping
 EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
   CREATE TABLE ctas_ine_tbl AS SELECT 1 / 0; -- error
 ERROR:  relation "ctas_ine_tbl" already exists
 EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
   CREATE TABLE IF NOT EXISTS ctas_ine_tbl AS SELECT 1 / 0; -- ok
 NOTICE:  relation "ctas_ine_tbl" already exists, skipping
  QUERY PLAN
 ------------
 (0 rows)

 EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
   CREATE TABLE ctas_ine_tbl AS SELECT 1 / 0 WITH NO DATA; -- error
 ERROR:  relation "ctas_ine_tbl" already exists
 EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
   CREATE TABLE IF NOT EXISTS ctas_ine_tbl AS SELECT 1 / 0 WITH NO DATA; -- ok
 NOTICE:  relation "ctas_ine_tbl" already exists, skipping
  QUERY PLAN
 ------------
 (0 rows)

 PREPARE ctas_ine_query AS SELECT 1 / 0;
 EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
   CREATE TABLE ctas_ine_tbl AS EXECUTE ctas_ine_query; -- error
 ERROR:  relation "ctas_ine_tbl" already exists
 EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
   CREATE TABLE IF NOT EXISTS ctas_ine_tbl AS EXECUTE ctas_ine_query; -- ok
 NOTICE:  relation "ctas_ine_tbl" already exists, skipping
  QUERY PLAN
 ------------
 (0 rows)

 DROP TABLE ctas_ine_tbl;
	--
	-- SELECT_INTO
	--
	SELECT *
	INTO TABLE sitmp1
	FROM onek
	WHERE onek.unique1 < 2;
	DROP TABLE sitmp1;
	SELECT *
	INTO TABLE sitmp1
	FROM onek2
	WHERE onek2.unique1 < 2;
	DROP TABLE sitmp1;
	--
	-- SELECT INTO and INSERT permission, if owner is not allowed to insert.
	--
	CREATE SCHEMA selinto_schema;
	CREATE USER regress_selinto_user;
	ALTER DEFAULT PRIVILEGES FOR ROLE regress_selinto_user
	REVOKE INSERT ON TABLES FROM regress_selinto_user;
	GRANT ALL ON SCHEMA selinto_schema TO public;
	SET SESSION AUTHORIZATION regress_selinto_user;
	-- To pass ORCA tests, we need to ignore actual rows diffs.
	-- Because ORCA default distribution policy is random, so that the actual row
	-- number is uncertain.
	-- start_matchsubs
	--
	-- m/actual rows=\d+/
	-- s/\d+/XXX/g
	--
	-- end_matchsubs
	-- WITH DATA, passes.
	CREATE TABLE selinto_schema.tbl_withdata1 (a)
	AS SELECT generate_series(1,3) WITH DATA;
	INSERT INTO selinto_schema.tbl_withdata1 VALUES (4);
	ERROR: permission denied for table tbl_withdata1
	EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
	CREATE TABLE selinto_schema.tbl_withdata2 (a) AS
	SELECT generate_series(1,3) WITH DATA;
	QUERY PLAN
	------------------------------------------------------------------------------
	Result (actual rows=2 loops=1)
	-> Redistribute Motion 3:3 (slice1; segments: 3) (actual rows=2 loops=1)
	-> Result (actual rows=3 loops=1)
	One-Time Filter: (gp_execution_segment() = 0)
	-> ProjectSet (actual rows=3 loops=1)
	-> Result (actual rows=1 loops=1)
	Optimizer: Pivotal Optimizer (GPORCA)
	(7 rows)

	-- WITH NO DATA, passes.
	CREATE TABLE selinto_schema.tbl_nodata1 (a) AS
	SELECT generate_series(1,3) WITH NO DATA;
	EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
	CREATE TABLE selinto_schema.tbl_nodata2 (a) AS
	SELECT generate_series(1,3) WITH NO DATA;
	QUERY PLAN
	-----------------------------------------------------------------------
	Result (never executed)
	-> Redistribute Motion 3:3 (slice1; segments: 3) (never executed)
	-> Result (never executed)
	One-Time Filter: (gp_execution_segment() = 0)
	-> ProjectSet (never executed)
	-> Result (never executed)
	Optimizer: Pivotal Optimizer (GPORCA)
	(7 rows)

	-- EXECUTE and WITH DATA, passes.
	PREPARE data_sel AS SELECT generate_series(1,3);
	CREATE TABLE selinto_schema.tbl_withdata3 (a) AS
	EXECUTE data_sel WITH DATA;
	EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
	CREATE TABLE selinto_schema.tbl_withdata4 (a) AS
	EXECUTE data_sel WITH DATA;
	QUERY PLAN
	------------------------------------------------------------------------------
	Result (actual rows=1 loops=1)
	-> Redistribute Motion 3:3 (slice1; segments: 3) (actual rows=1 loops=1)
	-> Result (actual rows=3 loops=1)
	One-Time Filter: (gp_execution_segment() = 0)
	-> ProjectSet (actual rows=3 loops=1)
	-> Result (actual rows=1 loops=1)
	Optimizer: Pivotal Optimizer (GPORCA)
	(7 rows)

	-- EXECUTE and WITH NO DATA, passes.
	CREATE TABLE selinto_schema.tbl_nodata3 (a) AS
	EXECUTE data_sel WITH NO DATA;
	EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
	CREATE TABLE selinto_schema.tbl_nodata4 (a) AS
	EXECUTE data_sel WITH NO DATA;
	QUERY PLAN
	-----------------------------------------------------------------------
	Result (never executed)
	-> Redistribute Motion 3:3 (slice1; segments: 3) (never executed)
	-> Result (never executed)
	One-Time Filter: (gp_execution_segment() = 1)
	-> ProjectSet (never executed)
	-> Result (never executed)
	Optimizer: Pivotal Optimizer (GPORCA)
	(7 rows)

	RESET SESSION AUTHORIZATION;
	ALTER DEFAULT PRIVILEGES FOR ROLE regress_selinto_user
	GRANT INSERT ON TABLES TO regress_selinto_user;
	SET SESSION AUTHORIZATION regress_selinto_user;
	RESET SESSION AUTHORIZATION;
	DEALLOCATE data_sel;
	DROP SCHEMA selinto_schema CASCADE;
	NOTICE: drop cascades to 8 other objects
	DETAIL: drop cascades to table selinto_schema.tbl_withdata1
	drop cascades to table selinto_schema.tbl_withdata2
	drop cascades to table selinto_schema.tbl_nodata1
	drop cascades to table selinto_schema.tbl_nodata2
	drop cascades to table selinto_schema.tbl_withdata3
	drop cascades to table selinto_schema.tbl_withdata4
	drop cascades to table selinto_schema.tbl_nodata3
	drop cascades to table selinto_schema.tbl_nodata4
	DROP USER regress_selinto_user;
	-- Tests for WITH NO DATA and column name consistency
	CREATE TABLE ctas_base (i int, j int);
	INSERT INTO ctas_base VALUES (1, 2);
	CREATE TABLE ctas_nodata (ii, jj, kk) AS SELECT i, j FROM ctas_base; -- Error
	ERROR: too many column names were specified
	CREATE TABLE ctas_nodata (ii, jj, kk) AS SELECT i, j FROM ctas_base WITH NO DATA; -- Error
	ERROR: too many column names were specified
	CREATE TABLE ctas_nodata (ii, jj) AS SELECT i, j FROM ctas_base; -- OK
	CREATE TABLE ctas_nodata_2 (ii, jj) AS SELECT i, j FROM ctas_base WITH NO DATA; -- OK
	CREATE TABLE ctas_nodata_3 (ii) AS SELECT i, j FROM ctas_base; -- OK
	CREATE TABLE ctas_nodata_4 (ii) AS SELECT i, j FROM ctas_base WITH NO DATA; -- OK
	SELECT * FROM ctas_nodata;
	ii \| jj
	----+----
	1 \| 2
	(1 row)

	SELECT * FROM ctas_nodata_2;
	ii \| jj
	----+----
	(0 rows)

	SELECT * FROM ctas_nodata_3;
	ii \| j
	----+---
	1 \| 2
	(1 row)

	SELECT * FROM ctas_nodata_4;
	ii \| j
	----+---
	(0 rows)

	DROP TABLE ctas_base;
	DROP TABLE ctas_nodata;
	DROP TABLE ctas_nodata_2;
	DROP TABLE ctas_nodata_3;
	DROP TABLE ctas_nodata_4;
	-- Test for WITH NO DATA on toast column
	CREATE TABLE ctas_base (i text);
	INSERT INTO ctas_base VALUES ('a');
	CREATE TABLE ctas_nodata AS SELECT i FROM ctas_base WITH NO DATA; -- OK
	SELECT * FROM ctas_nodata;
	i
	---
	(0 rows)

	DROP TABLE ctas_base;
	DROP TABLE ctas_nodata;
	--
	-- CREATE TABLE AS/SELECT INTO as last command in a SQL function
	-- have been known to cause problems
	--
	CREATE FUNCTION make_table() RETURNS VOID
	AS $$
	CREATE TABLE created_table AS SELECT * FROM int8_tbl;
	$$ LANGUAGE SQL;
	SELECT make_table();
	make_table
	------------

	(1 row)

	SELECT * FROM created_table;
	q1 \| q2
	------------------+-------------------
	123 \| 456
	123 \| 4567890123456789
	4567890123456789 \| 123
	4567890123456789 \| 4567890123456789
	4567890123456789 \| -4567890123456789
	(5 rows)

	-- Try EXPLAIN ANALYZE SELECT INTO and EXPLAIN ANALYZE CREATE TABLE AS
	-- WITH NO DATA, but hide the outputs since they won't be stable.
	DO $$
	BEGIN
	EXECUTE 'EXPLAIN ANALYZE SELECT * INTO TABLE easi FROM int8_tbl';
	EXECUTE 'EXPLAIN ANALYZE CREATE TABLE easi2 AS SELECT * FROM int8_tbl WITH NO DATA';
	END$$;
	DROP TABLE created_table;
	DROP TABLE easi, easi2;
	--
	-- Disallowed uses of SELECT ... INTO. All should fail
	--
	DECLARE foo CURSOR FOR SELECT 1 INTO b;
	ERROR: SELECT ... INTO is not allowed here
	LINE 1: DECLARE foo CURSOR FOR SELECT 1 INTO b;
	^
	COPY (SELECT 1 INTO frak UNION SELECT 2) TO 'blob';
	ERROR: COPY (SELECT INTO) is not supported
	SELECT * FROM (SELECT 1 INTO f) bar;
	ERROR: SELECT ... INTO is not allowed here
	LINE 1: SELECT * FROM (SELECT 1 INTO f) bar;
	^
	CREATE VIEW foo AS SELECT 1 INTO b;
	ERROR: views must not contain SELECT INTO
	INSERT INTO b SELECT 1 INTO f;
	ERROR: SELECT ... INTO is not allowed here
	LINE 1: INSERT INTO b SELECT 1 INTO f;
	^
	--
	-- Empty target list
	--
	explain (costs off) select into empty_tl from generate_series(0, 10);
	NOTICE: Table doesn't have 'DISTRIBUTED BY' clause. Creating a NULL policy entry.
	QUERY PLAN
	-------------------------------------------------------------
	Result
	-> Redistribute Motion 3:3 (slice1; segments: 3)
	-> Result
	One-Time Filter: (gp_execution_segment() = 2)
	-> Function Scan on generate_series
	Optimizer: GPORCA
	(6 rows)

	select into empty_tl from generate_series(0, 10);
	NOTICE: Table doesn't have 'DISTRIBUTED BY' clause. Creating a NULL policy entry.
	select * from empty_tl;
	--
	(11 rows)

	drop table empty_tl;
	-- Test CREATE TABLE AS ... IF NOT EXISTS
	CREATE TABLE ctas_ine_tbl AS SELECT 1;
	CREATE TABLE ctas_ine_tbl AS SELECT 1 / 0; -- error
	ERROR: relation "ctas_ine_tbl" already exists
	CREATE TABLE IF NOT EXISTS ctas_ine_tbl AS SELECT 1 / 0; -- ok
	NOTICE: relation "ctas_ine_tbl" already exists, skipping
	CREATE TABLE ctas_ine_tbl AS SELECT 1 / 0 WITH NO DATA; -- error
	ERROR: relation "ctas_ine_tbl" already exists
	CREATE TABLE IF NOT EXISTS ctas_ine_tbl AS SELECT 1 / 0 WITH NO DATA; -- ok
	NOTICE: relation "ctas_ine_tbl" already exists, skipping
	EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
	CREATE TABLE ctas_ine_tbl AS SELECT 1 / 0; -- error
	ERROR: relation "ctas_ine_tbl" already exists
	EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
	CREATE TABLE IF NOT EXISTS ctas_ine_tbl AS SELECT 1 / 0; -- ok
	NOTICE: relation "ctas_ine_tbl" already exists, skipping
	QUERY PLAN
	------------
	(0 rows)

	EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
	CREATE TABLE ctas_ine_tbl AS SELECT 1 / 0 WITH NO DATA; -- error
	ERROR: relation "ctas_ine_tbl" already exists
	EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
	CREATE TABLE IF NOT EXISTS ctas_ine_tbl AS SELECT 1 / 0 WITH NO DATA; -- ok
	NOTICE: relation "ctas_ine_tbl" already exists, skipping
	QUERY PLAN
	------------
	(0 rows)

	PREPARE ctas_ine_query AS SELECT 1 / 0;
	EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
	CREATE TABLE ctas_ine_tbl AS EXECUTE ctas_ine_query; -- error
	ERROR: relation "ctas_ine_tbl" already exists
	EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
	CREATE TABLE IF NOT EXISTS ctas_ine_tbl AS EXECUTE ctas_ine_query; -- ok
	NOTICE: relation "ctas_ine_tbl" already exists, skipping
	QUERY PLAN
	------------
	(0 rows)

	DROP TABLE ctas_ine_tbl;