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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
# name: test/sql/cte/warn_deprecated_union_in_using_key.test
# description: Test warnings are outputted correctly
# group: [cte]
# If logging level > warning (ie. debug or fatal) don't log
statement ok
CALL enable_logging(level='error');
query II
WITH RECURSIVE cte(x,y) USING KEY (x) AS (
SELECT 1, 0
UNION
SELECT x, y+1
FROM cte
WHERE y < 10
) TABLE cte;
----
1 10
query II
SELECT log_level, message[0:42] FROM duckdb_logs
----
statement ok
CALL truncate_duckdb_logs();
# Else log warning
statement ok
CALL enable_logging(level='warning');
query II
WITH RECURSIVE cte(x,y) USING KEY (x) AS (
SELECT 1, 0
UNION
SELECT x, y+1
FROM cte
WHERE y < 10
) TABLE cte;
----
1 10
query II
SELECT log_level, message[0:42] FROM duckdb_logs
----
WARNING Deprecated UNION in USING KEY CTE detected
statement ok
CALL truncate_duckdb_logs();
# Enable UNION as UNION ALL interpretation, should not log.
statement ok
SET deprecated_using_key_syntax='UNION_AS_UNION_ALL';
# UNION now doesn't throw a warning
query II
WITH RECURSIVE cte(x,y) USING KEY (x) AS (
SELECT 1, 0
UNION
SELECT x, y+1
FROM cte
WHERE y < 10
) TABLE cte;
----
1 10
query II
SELECT log_level, message[0:42] FROM duckdb_logs
----
|
