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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
# name: test/sql/join/external/external_join_many_duplicates.test_slow
# description: Test external join with many duplicates in build side
# group: [external]
# runs out of memory occassionally on 32-bit machines
require 64bit
statement ok
pragma verify_external
statement ok
pragma verify_parallelism
statement ok
create table test1 as select concat(range::VARCHAR, 'x', repeat('7', 1)) i from range(100, 132)
statement ok
create table test2 as select concat(range::VARCHAR, 'x', repeat('7', 1)) i from range(100, 132)
statement ok
insert into test2 select range::VARCHAR i from range(1000000000000, 1000000100000)
query T
select count(*) from test1 join test2 using (i)
----
32
# 10M build side with many useless duplicates (stress tests the compare-and-swap pointer table construction)
statement ok
create sequence seq1 start 1000;
statement ok
create table t1 as select case
when range % 10000 = 0 then nextval('seq1')
else range % 1000 end as i
from range(10000000)
# 100M probe side
statement ok
create sequence seq2 start 1000;
statement ok
create table t2 as select case
when range % 100000 = 0 then nextval('seq2')
else range end as i
from range(100000000, 200000000)
query T
select count(*) from t1 join t2 using (i)
----
1000
|
