0

(1 row)

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

SELECT * FROM ONLY test.range_rel UNION SELECT * FROM test.range_rel;

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

SELECT * FROM test.range_rel UNION SELECT * FROM ONLY test.range_rel;

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

SELECT * FROM test.range_rel UNION SELECT * FROM test.range_rel UNION SELECT * FROM ONLY test.range_rel;

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

SELECT * FROM ONLY test.range_rel UNION SELECT * FROM test.range_rel UNION SELECT * FROM test.range_rel;

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

/* FIXME: result of next command execution is not right just yet */

WITH q1 AS (SELECT * FROM test.range_rel), q2 AS (SELECT * FROM ONLY test.range_rel) SELECT * FROM q1 JOIN q2 USING(id);

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

WITH q1 AS (SELECT * FROM ONLY test.range_rel) SELECT * FROM test.range_rel JOIN q1 USING(id);

id | dt | txt | dt | txt

----+----+-----+----+-----

(0 rows)

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

id | dt | txt

----+----+-----

(0 rows)

SET pg_pathman.enable_runtimeappend = OFF;

SET pg_pathman.enable_runtimemergeappend = OFF;

VACUUM;

SELECTCOUNT(*)FROMtest.num_range_rel;

SELECTCOUNT(*)FROM ONLYtest.num_range_rel;

SELECT*FROM ONLYtest.range_relUNIONSELECT*FROMtest.range_rel;

SELECT*FROMtest.range_relUNIONSELECT*FROM ONLYtest.range_rel;

SELECT*FROMtest.range_relUNIONSELECT*FROMtest.range_relUNIONSELECT*FROM ONLYtest.range_rel;

SELECT*FROM ONLYtest.range_relUNIONSELECT*FROMtest.range_relUNIONSELECT*FROMtest.range_rel;

WITH q1AS (SELECT*FROMtest.range_rel), q2AS (SELECT*FROM ONLYtest.range_rel)SELECT*FROM q1JOIN q2 USING(id);

WITH q1AS (SELECT*FROM ONLYtest.range_rel)SELECT*FROMtest.range_relJOIN q1 USING(id);

SELECT*FROMtest.range_relWHERE id= (SELECT idFROM ONLYtest.range_relLIMIT1);

SETpg_pathman.enable_runtimeappend= OFF;

SETpg_pathman.enable_runtimemergeappend= OFF;