src/pl_funcs.o src/pl_range_funcs.o src/pl_hash_funcs.o src/pathman_workers.o\

src/hooks.o src/nodes_common.o src/xact_handling.o src/utility_stmt_hooking.o\

src/planner_tree_modification.o src/debug_print.o src/partition_creation.o\

src/compat/pg_compat.o$(WIN32RES)

src/compat/pg_compat.o src/compat/relation_tags.o src/compat/expand_rte_hook.o\

src/compat/rowmarks_fix.o$(WIN32RES)

PG_CPPFLAGS = -I$(CURDIR)/src/include

PGFILEDESC = "pg_pathman - partitioning tool"

REGRESS = pathman_basic\

pathman_only\

pathman_cte\

pathman_bgw\

pathman_inserts\

pathman_permissions\

pathman_rowmarks\

pathman_runtime_nodes\

pathman_calamity

EXTRA_REGRESS_OPTS=--temp-config=$(top_srcdir)/$(subdir)/conf.add

DROP TABLE test.insert_date_test CASCADE;

NOTICE: drop cascades to 8 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);

SELECT pathman.create_range_partitions('test.from_only_test', 'val', 1, 2);

NOTICE: sequence "from_only_test_seq" does not exist, skipping

create_range_partitions

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

10

(1 row)

/* should be OK */

EXPLAIN (COSTS OFF)

SELECT * FROM ONLY test.from_only_test

UNION SELECT * FROM test.from_only_test;

QUERY PLAN

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

HashAggregate

Group Key: from_only_test.val

-> Append

-> Seq Scan on from_only_test

-> Append

-> Seq Scan on from_only_test_1

-> Seq Scan on from_only_test_2

-> Seq Scan on from_only_test_3

-> Seq Scan on from_only_test_4

-> Seq Scan on from_only_test_5

-> Seq Scan on from_only_test_6

-> Seq Scan on from_only_test_7

-> Seq Scan on from_only_test_8

-> Seq Scan on from_only_test_9

-> Seq Scan on from_only_test_10

(15 rows)

/* should be OK */

EXPLAIN (COSTS OFF)

SELECT * FROM test.from_only_test

UNION SELECT * FROM ONLY test.from_only_test;

QUERY PLAN

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

HashAggregate

Group Key: from_only_test_1.val

-> Append

-> Append

-> Seq Scan on from_only_test_1

-> Seq Scan on from_only_test_2

-> Seq Scan on from_only_test_3

-> Seq Scan on from_only_test_4

-> Seq Scan on from_only_test_5

-> Seq Scan on from_only_test_6

-> Seq Scan on from_only_test_7

-> Seq Scan on from_only_test_8

-> Seq Scan on from_only_test_9

-> Seq Scan on from_only_test_10

-> Seq Scan on from_only_test

(15 rows)

/* should be OK */

EXPLAIN (COSTS OFF)

SELECT * FROM test.from_only_test

UNION SELECT * FROM test.from_only_test

UNION SELECT * FROM ONLY test.from_only_test;

QUERY PLAN

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

HashAggregate

Group Key: from_only_test_1.val

-> Append

-> Append

-> Seq Scan on from_only_test_1

-> Seq Scan on from_only_test_2

-> Seq Scan on from_only_test_3

-> Seq Scan on from_only_test_4

-> Seq Scan on from_only_test_5

-> Seq Scan on from_only_test_6

-> Seq Scan on from_only_test_7

-> Seq Scan on from_only_test_8

-> Seq Scan on from_only_test_9

-> Seq Scan on from_only_test_10

-> Append

-> Seq Scan on from_only_test_1 from_only_test_1_1

-> Seq Scan on from_only_test_2 from_only_test_2_1

-> Seq Scan on from_only_test_3 from_only_test_3_1

-> Seq Scan on from_only_test_4 from_only_test_4_1

-> Seq Scan on from_only_test_5 from_only_test_5_1

-> Seq Scan on from_only_test_6 from_only_test_6_1

-> Seq Scan on from_only_test_7 from_only_test_7_1

-> Seq Scan on from_only_test_8 from_only_test_8_1

-> Seq Scan on from_only_test_9 from_only_test_9_1

-> Seq Scan on from_only_test_10 from_only_test_10_1

-> Seq Scan on from_only_test

(26 rows)

/* should be OK */

EXPLAIN (COSTS OFF)

SELECT * FROM ONLY test.from_only_test

UNION SELECT * FROM test.from_only_test

UNION SELECT * FROM test.from_only_test;

QUERY PLAN

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

HashAggregate

Group Key: from_only_test.val

-> Append

-> Seq Scan on from_only_test

-> Append

-> Seq Scan on from_only_test_1

-> Seq Scan on from_only_test_2

-> Seq Scan on from_only_test_3

-> Seq Scan on from_only_test_4

-> Seq Scan on from_only_test_5

-> Seq Scan on from_only_test_6

-> Seq Scan on from_only_test_7

-> Seq Scan on from_only_test_8

-> Seq Scan on from_only_test_9

-> Seq Scan on from_only_test_10

-> Append

-> Seq Scan on from_only_test_1 from_only_test_1_1

-> Seq Scan on from_only_test_2 from_only_test_2_1

-> Seq Scan on from_only_test_3 from_only_test_3_1

-> Seq Scan on from_only_test_4 from_only_test_4_1

-> Seq Scan on from_only_test_5 from_only_test_5_1

-> Seq Scan on from_only_test_6 from_only_test_6_1

-> Seq Scan on from_only_test_7 from_only_test_7_1

-> Seq Scan on from_only_test_8 from_only_test_8_1

-> Seq Scan on from_only_test_9 from_only_test_9_1

-> Seq Scan on from_only_test_10 from_only_test_10_1

(26 rows)

/* not ok, ONLY|non-ONLY in one query */

EXPLAIN (COSTS OFF)

SELECT * FROM test.from_only_test a JOIN ONLY test.from_only_test b USING(val);

ERROR: it is prohibited to apply ONLY modifier to partitioned tables which have already been mentioned without ONLY

EXPLAIN (COSTS OFF)

WITH q1 AS (SELECT * FROM test.from_only_test),

q2 AS (SELECT * FROM ONLY test.from_only_test)

SELECT * FROM q1 JOIN q2 USING(val);

QUERY PLAN

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

Hash Join

Hash Cond: (q1.val = q2.val)

CTE q1

-> Append

-> Seq Scan on from_only_test_1

-> Seq Scan on from_only_test_2

-> Seq Scan on from_only_test_3

-> Seq Scan on from_only_test_4

-> Seq Scan on from_only_test_5

-> Seq Scan on from_only_test_6

-> Seq Scan on from_only_test_7

-> Seq Scan on from_only_test_8

-> Seq Scan on from_only_test_9

-> Seq Scan on from_only_test_10

CTE q2

-> Seq Scan on from_only_test

-> CTE Scan on q1

-> Hash

-> CTE Scan on q2

(19 rows)

EXPLAIN (COSTS OFF)

WITH q1 AS (SELECT * FROM ONLY test.from_only_test)

SELECT * FROM test.from_only_test JOIN q1 USING(val);

QUERY PLAN

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

Hash Join

Hash Cond: (from_only_test_1.val = q1.val)

CTE q1

-> Seq Scan on from_only_test

-> Append

-> Seq Scan on from_only_test_1

-> Seq Scan on from_only_test_2

-> Seq Scan on from_only_test_3

-> Seq Scan on from_only_test_4

-> Seq Scan on from_only_test_5

-> Seq Scan on from_only_test_6

-> Seq Scan on from_only_test_7

-> Seq Scan on from_only_test_8

-> Seq Scan on from_only_test_9

-> Seq Scan on from_only_test_10

-> Hash

-> CTE Scan on q1

(17 rows)

EXPLAIN (COSTS OFF)

SELECT * FROM test.range_rel WHERE id = (SELECT id FROM ONLY test.range_rel LIMIT 1);

QUERY PLAN

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

Append

InitPlan 1 (returns $0)

-> Limit

-> Seq Scan on range_rel

-> Index Scan using range_rel_1_pkey on range_rel_1

Index Cond: (id = $0)

-> Index Scan using range_rel_2_pkey on range_rel_2

Index Cond: (id = $0)

-> Index Scan using range_rel_3_pkey on range_rel_3

Index Cond: (id = $0)

-> Index Scan using range_rel_4_pkey on range_rel_4

Index Cond: (id = $0)

(12 rows)

DROP TABLE test.from_only_test CASCADE;

NOTICE: drop cascades to 10 other objects

SET pg_pathman.enable_runtimeappend = OFF;

SET pg_pathman.enable_runtimemergeappend = OFF;

VACUUM;

256 | 128 | test_inserts.storage_14

(27 rows)

/* test gap case (missing partition in between) */

CREATE TABLE test_inserts.test_gap(val INT NOT NULL);

INSERT INTO test_inserts.test_gap SELECT generate_series(1, 30);

SELECT create_range_partitions('test_inserts.test_gap', 'val', 1, 10);

NOTICE: sequence "test_gap_seq" does not exist, skipping

create_range_partitions

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

3

(1 row)

DROP TABLE test_inserts.test_gap_2; /* make a gap */

INSERT INTO test_inserts.test_gap VALUES(15); /* not ok */

ERROR: cannot spawn a partition

DROP TABLE test_inserts.test_gap CASCADE;

NOTICE: drop cascades to 2 other objects

DROP SCHEMA test_inserts CASCADE;

NOTICE: drop cascades to19 other objects

NOTICE: drop cascades to20 other objects

DROP EXTENSION pg_pathman CASCADE;