# 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 |