DROP TABLE test.improved_dummy CASCADE;

NOTICE: drop cascades to 11 other objects

/* Test pathman_rel_pathlist_hook() with INSERT query */

CREATE TABLE test.insert_into_select(val int NOT NULL);

INSERT INTO test.insert_into_select SELECT generate_series(1, 100);

SELECT pathman.create_range_partitions('test.insert_into_select', 'val', 1, 20);

NOTICE: sequence "insert_into_select_seq" does not exist, skipping

create_range_partitions

-------------------------

5

(1 row)

CREATE TABLE test.insert_into_select_copy (LIKE test.insert_into_select); /* INSERT INTO ... SELECT ... */

EXPLAIN (COSTS OFF)

INSERT INTO test.insert_into_select_copy

SELECT * FROM test.insert_into_select

WHERE val <= 80;

QUERY PLAN

----------------------------------------------

Insert on insert_into_select_copy

-> Append

-> Seq Scan on insert_into_select_1

-> Seq Scan on insert_into_select_2

-> Seq Scan on insert_into_select_3

-> Seq Scan on insert_into_select_4

Filter: (val <= 80)

(7 rows)

SELECT pathman.set_enable_parent('test.insert_into_select', true);

set_enable_parent

-------------------

(1 row)

EXPLAIN (COSTS OFF)

INSERT INTO test.insert_into_select_copy

SELECT * FROM test.insert_into_select

WHERE val <= 80;

QUERY PLAN

----------------------------------------------

Insert on insert_into_select_copy

-> Append

-> Seq Scan on insert_into_select

Filter: (val <= 80)

-> Seq Scan on insert_into_select_1

-> Seq Scan on insert_into_select_2

-> Seq Scan on insert_into_select_3

-> Seq Scan on insert_into_select_4

Filter: (val <= 80)

(9 rows)

INSERT INTO test.insert_into_select_copy SELECT * FROM test.insert_into_select;

SELECT count(*) FROM test.insert_into_select_copy;

count

-------

100

(1 row)

DROP TABLE test.insert_into_select_copy, test.insert_into_select CASCADE;

NOTICE: drop cascades to 5 other objects

/* test special case: ONLY statement with not-ONLY for partitioned table */

CREATE TABLE test.from_only_test(val INT NOT NULL);

INSERT INTO test.from_only_test SELECT generate_series(1, 20);

(12 rows)

DROP SCHEMA test CASCADE;

NOTICE: drop cascades to47 other objects

NOTICE: drop cascades to48 other objects

DROP EXTENSION pg_pathman CASCADE;

DROP SCHEMA pathman CASCADE;

DROPTABLEtest.improved_dummy CASCADE;

CREATETABLEtest.insert_into_select(valintNOT NULL);

INSERT INTOtest.insert_into_selectSELECT generate_series(1,100);

SELECTpathman.create_range_partitions('test.insert_into_select','val',1,20);

CREATETABLEtest.insert_into_select_copy (LIKEtest.insert_into_select);/* INSERT INTO ... SELECT ...*/

EXPLAIN (COSTS OFF)

INSERT INTOtest.insert_into_select_copy

SELECT*FROMtest.insert_into_select

WHERE val<=80;

SELECTpathman.set_enable_parent('test.insert_into_select', true);

EXPLAIN (COSTS OFF)

INSERT INTOtest.insert_into_select_copy

SELECT*FROMtest.insert_into_select

WHERE val<=80;

INSERT INTOtest.insert_into_select_copySELECT*FROMtest.insert_into_select;

SELECTcount(*)FROMtest.insert_into_select_copy;

DROPTABLEtest.insert_into_select_copy,test.insert_into_select CASCADE;

CREATETABLEtest.from_only_test(valINTNOT NULL);

INSERT INTOtest.from_only_testSELECT generate_series(1,20);

if (!IsPathmanReady())

return;

if (root->parse->commandType!=CMD_SELECT||

rte->relkind!=RELKIND_RELATION)

if (rte->rtekind!=RTE_RELATION||

(root->parse->commandType!=CMD_SELECT&&

root->parse->commandType!=CMD_INSERT))/* INSERT INTO ... SELECT ... */

return;