-
Notifications
You must be signed in to change notification settings - Fork 113
Closed
Labels
Description
Hi!
The following SQL crashes using the Parallel hint:
DROP TABLE IF EXISTS test1, test2;
CREATE TABLE test1(c1 INT, c2 INT, c3 INT);
CREATE TABLE test2(c1 INT, c2 INT);
INSERT INTO test1(c1, c2, c3) SELECT n, n, n FROM generate_series(1, 5) n;
INSERT INTO test2(c1, c2) SELECT n, n FROM generate_series(1, 5) n;
ANALYZE test1, test2;
/*+Parallel(test1 5 hard) */
EXPLAIN ANALYZE
SELECT * FROM
(
SELECT * FROM test1,test2
UNION ALL
SELECT * FROM test2,test1
) s
ORDER BY 1;