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
|