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
|
# name: test/optimizer/comparison_simplification.test
# description: Comparison simplification test
# group: [optimizer]
statement ok
CREATE TABLE test(X INTEGER);
statement ok
PRAGMA explain_output = OPTIMIZED_ONLY;
# comparisons with NULL result in NULL
query I nosort compnorm1
EXPLAIN SELECT NULL FROM test
----
query I nosort compnorm1
EXPLAIN SELECT X=NULL FROM test
----
query I nosort compnorm1
EXPLAIN SELECT X>NULL FROM test
----
query I nosort compnorm1
EXPLAIN SELECT NULL>X FROM test
----
# in the WHERE clause this gets pruned entirely
query I nosort compnorm2
EXPLAIN SELECT * FROM test WHERE 1=0
----
query I nosort compnorm2
EXPLAIN SELECT * FROM test WHERE X=NULL
----
# we shift casts from columns to columns when possible
query I nosort constantshift
EXPLAIN SELECT X=1::BIGINT FROM test
----
query I nosort constantshift
EXPLAIN SELECT X::BIGINT=1::INTEGER FROM test
----
query I nosort constantshift
EXPLAIN SELECT X='1' FROM test
----
query I nosort constantshift
EXPLAIN SELECT X::BIGINT='1' FROM test
----
|
