Skip to content

Commit 1dc536f

Browse files
CurtizJCurtizJ
committed
add with for subcolumns
1 parent facbd89 commit 1dc536f

2 files changed

Lines changed: 31 additions & 0 deletions

File tree

‎tests/queries/0_stateless/02969_functions_to_subcolumns_if_null.reference‎

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
10000
2+
0
3+
0
4+
0

‎tests/queries/0_stateless/02969_functions_to_subcolumns_if_null.sql‎

Lines changed: 27 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,27 @@
1+
DROP TABLE IF EXISTS t_subcolumns_if;
2+
3+
CREATE TABLE t_subcolumns_if (id Nullable(Int64)) ENGINE=MergeTree ORDER BY tuple();
4+
5+
INSERT INTO t_subcolumns_if SELECT number::Nullable(Int64) as number FROM numbers(10000);
6+
7+
SELECT
8+
sum(multiIf(id IS NOT NULL, 1, 0))
9+
FROM t_subcolumns_if
10+
SETTINGS allow_experimental_analyzer = 1, optimize_functions_to_subcolumns = 1;
11+
12+
SELECT
13+
sum(multiIf(id IS NULL, 1, 0))
14+
FROM t_subcolumns_if
15+
SETTINGS allow_experimental_analyzer = 0, optimize_functions_to_subcolumns = 1;
16+
17+
SELECT
18+
sum(multiIf(id IS NULL, 1, 0))
19+
FROM t_subcolumns_if
20+
SETTINGS allow_experimental_analyzer = 1, optimize_functions_to_subcolumns = 0;
21+
22+
SELECT
23+
sum(multiIf(id IS NULL, 1, 0))
24+
FROM t_subcolumns_if
25+
SETTINGS allow_experimental_analyzer = 1, optimize_functions_to_subcolumns = 1;
26+
27+
DROP TABLE IF EXISTS t_subcolumns_if;

0 commit comments

Comments
 (0)