blob: d61fe7688f45b688403014b9401c69243f306576 [file] [log] [blame]
# name: test/sql/join/test_cross_product_parallelism.test
# description: Test cross product with parallelism
# group: [join]
statement ok
CREATE TABLE integers AS SELECT * FROM system_range(0, 4999) tbl(i)
# test if order remains the same
query I
SELECT count(*) FROM integers i1, integers i2
----
25000000
query II
SELECT MIN(i1.i), MAX(i2.i) FROM integers i1, integers i2
----
0 4999
query II
SELECT MAX(i1.i), MIN(i2.i) FROM integers i1, integers i2
----
4999 0