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
|
# name: test/optimizer/arithmetic_simplification.test
# description: Arithmetic simplification test
# group: [optimizer]
statement ok
CREATE TABLE test(X INTEGER);
statement ok
PRAGMA explain_output = OPTIMIZED_ONLY;
# verify that nop arithmetic is flattened
query I nosort xnorm
EXPLAIN SELECT X FROM test
----
query I nosort xnorm
EXPLAIN SELECT X+0 FROM test
----
query I nosort xnorm
EXPLAIN SELECT 0+X FROM test
----
query I nosort xnorm
EXPLAIN SELECT X-0 FROM test
----
query I nosort xnorm
EXPLAIN SELECT X*1 FROM test
----
query I nosort xnorm
EXPLAIN SELECT 1*X FROM test
----
query I nosort xnorm
EXPLAIN SELECT X//1 FROM test
----
# division by zero results in a NULL
query I nosort xnull
EXPLAIN SELECT NULL FROM test
----
query I nosort xnull
EXPLAIN SELECT X//0 FROM test
----
|
