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
|
# name: test/sql/pivot/pivot_errors.test
# description: Test pivot errors
# group: [pivot]
statement ok
PRAGMA enable_verification
statement ok
CREATE TABLE test(i INT, j VARCHAR);
statement error
PIVOT test ON j IN ('a', 'b') USING SUM(test.i);
----
PIVOT expression cannot contain qualified columns
statement ok
SET pivot_filter_threshold=0
statement error
PIVOT test ON j IN ('a', 'b') USING get_current_timestamp();
----
no aggregates were found
statement ok
SET pivot_filter_threshold=100
statement error
PIVOT test ON j IN ('a', 'b') USING get_current_timestamp();
----
no aggregates were found
statement error
PIVOT test ON j IN ('a', 'b') USING sum(41) over ();
----
cannot contain window functions
statement error
PIVOT test ON j IN ('a', 'b') USING sum(sum(41) over ());
----
cannot contain window functions
# empty pivot clause
statement error
FROM tbl PIVOT (c FOR IN enum_val);
----
Parser Error
|
