1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
# name: test/sql/setops/union_shared_scan.test
# description: Test shared scan over a union
# group: [setops]
statement ok
PRAGMA threads=4
statement ok
PRAGMA verify_parallelism
statement ok
CREATE TABLE tbl AS SELECT * FROM range(10000) tbl(i) UNION ALL SELECT NULL
query I
SELECT SUM(i) FROM tbl
UNION ALL
SELECT COUNT(i) FROM tbl
UNION ALL
SELECT AVG(i) FROM tbl
UNION ALL
SELECT AVG(i) + SUM(i) FROM tbl
ORDER BY 1
----
4999.5
10000.0
49995000.0
49999999.5
|
