File: test_operator_precedence.test

package info (click to toggle)
duckdb 1.5.1-2
  • links: PTS, VCS
  • area: main
  • in suites:
  • size: 299,196 kB
  • sloc: cpp: 865,414; ansic: 57,292; python: 18,871; sql: 12,663; lisp: 11,751; yacc: 7,412; lex: 1,682; sh: 747; makefile: 558
file content (73 lines) | stat: -rw-r--r-- 630 bytes parent folder | download | duplicates (3)
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
72
73
# name: test/sql/parser/test_operator_precedence.test
# description: Test operator precedence
# group: [parser]

statement ok
PRAGMA enable_verification

# basic arithmetic precedence
query I
SELECT 2*3+1
----
7

query I
SELECT 1+2*3
----
7

# ** precedence (issue 3561)
query I
SELECT 2^2 + 1;
----
5

query I
SELECT 2**2 + 1;
----
5

query I
SELECT 1+2**2;
----
5

query I
SELECT 1+2^2;
----
5

query I
SELECT 2**4 / 2;
----
8

query I
SELECT 2**(4 / 2);
----
4

query I
SELECT 16/2**4;
----
1

query I
SELECT (16/2)**4;
----
4096

query I
SELECT 2**3**2;
----
64

query I
SELECT 2^3**2;
----
64

query I
SELECT 2**3^2;
----
64