Skip to content

Commit d59db55

Browse files
committed
add uts about array join
1 parent 32c5aee commit d59db55

2 files changed

Lines changed: 14 additions & 0 deletions

File tree

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
1
Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,13 @@
1+
SET max_block_size = 8192;
2+
3+
SELECT DISTINCT blockSize() <= 8192
4+
FROM
5+
(
6+
SELECT n
7+
FROM
8+
(
9+
SELECT range(0, rand() % 10) AS x
10+
FROM numbers(1000000)
11+
)
12+
LEFT ARRAY JOIN x AS n
13+
)

0 commit comments

Comments
 (0)