sqllogictest

Artifact 3d0690fa10323f3c3d36ed7b3a6098bb4f32620a:

• File test/random/aggregates/slt_good_129.test — part of check-in [9b5974b19a] at 2008-12-23 04:48:35 on branch trunk — Updated to skip tests for PostgreSQL where output column is (re)named without an AS term. (user: shaneh size: 151817)

hash-threshold 8

statement ok
CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER)

statement ok
CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER)

statement ok
CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER)

statement ok
INSERT INTO tab0 VALUES(97,1,99)

statement ok
INSERT INTO tab0 VALUES(15,81,47)

statement ok
INSERT INTO tab0 VALUES(87,21,10)

statement ok
INSERT INTO tab1 VALUES(51,14,96)

statement ok
INSERT INTO tab1 VALUES(85,5,59)

statement ok
INSERT INTO tab1 VALUES(91,47,68)

statement ok
INSERT INTO tab2 VALUES(64,77,40)

statement ok
INSERT INTO tab2 VALUES(75,67,58)

statement ok
INSERT INTO tab2 VALUES(46,51,23)

onlyif mysql # aggregate syntax: 
query I rowsort label-0
SELECT ALL - COUNT( * ) + + + 30 FROM tab0 AS cor0
----
27

skipif mysql # not compatible
query I rowsort label-0
SELECT ALL - COUNT ( * ) + + + 30 FROM tab0 AS cor0
----
27

query I rowsort
SELECT DISTINCT - col2 * - + col2 * + 14 - - col2 FROM tab1 AS cor0
----
129120
48793
64804

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-2
SELECT DISTINCT + - col2 + + CAST( - ( + - col1 ) AS SIGNED ) AS col0 FROM tab0 AS cor0
----
-98
11
34

skipif mysql # not compatible
query I rowsort label-2
SELECT DISTINCT + - col2 + + CAST ( - ( + - col1 ) AS INTEGER ) AS col0 FROM tab0 AS cor0
----
-98
11
34

onlyif mysql # aggregate syntax: 
query II rowsort label-3
SELECT ALL + ( MAX( col1 ) ) AS col1, - 20 FROM tab0 AS cor0
----
81
-20

skipif mysql # not compatible
query II rowsort label-3
SELECT ALL + ( MAX ( col1 ) ) AS col1, - 20 FROM tab0 AS cor0
----
81
-20

onlyif mysql # aggregate syntax: 
query I rowsort label-4
SELECT + - MAX( col0 ) FROM tab1 AS cor0
----
-91

skipif mysql # not compatible
query I rowsort label-4
SELECT + - MAX ( col0 ) FROM tab1 AS cor0
----
-91

query I rowsort
SELECT - 32 * + col1 * + col2 FROM tab0
----
-121824
-3168
-6720

onlyif mysql # aggregate syntax: 
query II rowsort label-6
SELECT ALL + - SUM( 47 ) AS col1, + 39 * - COUNT( * ) AS col1 FROM tab1 WHERE NULL IS NOT NULL
----
NULL
0

skipif mysql # not compatible
query II rowsort label-6
SELECT ALL + - SUM ( 47 ) AS col1, + 39 * - COUNT ( * ) AS col1 FROM tab1 WHERE NULL IS NOT NULL
----
NULL
0

query II rowsort
SELECT col1 AS col1, + col2 FROM tab2
----
51
23
67
58
77
40

query I rowsort
SELECT DISTINCT - ( - 18 ) + col0 AS col2 FROM tab1
----
103
109
69

query I rowsort
SELECT + col0 * ( - - col2 ) - - + col0 FROM tab1
----
4947
5100
6279

query I rowsort
SELECT ALL - col1 + + 94 FROM tab0
----
13
73
93

onlyif mysql # aggregate syntax: 
query I rowsort label-11
SELECT DISTINCT + ( 83 ) + + COUNT( * ) - + ( - - ( 98 ) ) AS col2 FROM tab0
----
-12

skipif mysql # not compatible
query I rowsort label-11
SELECT DISTINCT + ( 83 ) + + COUNT ( * ) - + ( - - ( 98 ) ) AS col2 FROM tab0
----
-12

query I rowsort
SELECT DISTINCT col2 + 69 * - + col1 FROM tab2
----
-3496
-4565
-5273

query II rowsort
SELECT - 46 + - col1 AS col1, - col1 FROM tab1 AS cor0
----
-51
-5
-60
-14
-93
-47

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-14
SELECT - CAST( + + 84 AS SIGNED ) + + 9 FROM tab2 AS cor0
----
-75
-75
-75

skipif mysql # not compatible
query I rowsort label-14
SELECT - CAST ( + + 84 AS INTEGER ) + + 9 FROM tab2 AS cor0
----
-75
-75
-75

onlyif mysql # aggregate syntax: 
query I rowsort label-15
SELECT + SUM( 46 ) AS col1 FROM tab0 AS cor0
----
138

skipif mysql # not compatible
query I rowsort label-15
SELECT + SUM ( 46 ) AS col1 FROM tab0 AS cor0
----
138

query I rowsort
SELECT DISTINCT 83 + + 7 - - + 67 + + + col2 + + - 37 FROM tab2
----
143
160
178

query I rowsort
SELECT ALL - col0 AS col0 FROM tab0 WHERE NOT NULL <> + col2
----

query I rowsort
SELECT DISTINCT - ( - 31 ) * - - col2 AS col0 FROM tab2 AS cor0
----
1240
1798
713

query III rowsort
SELECT * FROM tab2 AS cor0 WHERE NOT ( NULL ) NOT BETWEEN NULL AND - col0
----

query I rowsort
SELECT DISTINCT - col2 + col0 AS col2 FROM tab1 AS cor0 WHERE ( NULL ) IS NULL
----
-45
23
26

onlyif mysql # aggregate syntax: 
query II rowsort label-21
SELECT DISTINCT COUNT( * ) * + COUNT( * ) + - COUNT( col0 ) + - + 35 col2, + 99 FROM tab1 AS cor0
----
-29
99

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-21
SELECT DISTINCT COUNT ( * ) * + COUNT ( * ) + - COUNT ( col0 ) + - + 35 col2, + 99 FROM tab1 AS cor0
----
-29
99

query III rowsort
SELECT * FROM tab1 cor0 WHERE NOT col2 * + 64 BETWEEN NULL AND NULL
----

query I rowsort
SELECT DISTINCT - col1 * - 79 FROM tab0 AS cor0
----
1659
6399
79

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-24
SELECT - + 26 * - col1 * - 52 AS col0 FROM tab1 AS cor0 WHERE NOT CAST( NULL AS SIGNED ) IS NOT NULL
----
-18928
-63544
-6760

skipif mysql # not compatible
query I rowsort label-24
SELECT - + 26 * - col1 * - 52 AS col0 FROM tab1 AS cor0 WHERE NOT CAST ( NULL AS INTEGER ) IS NOT NULL
----
-18928
-63544
-6760

onlyif mysql # DIV for integer division: 
query I rowsort label-25
SELECT 50 DIV - col1 FROM tab1
----
-1
-10
-3

skipif mysql # not compatible
query I rowsort label-25
SELECT 50 / - col1 FROM tab1
----
-1
-10
-3

query I rowsort
SELECT - col2 * - ( col1 ) * - 9 - col1 AS col2 FROM tab1
----
-12110
-2660
-28811

onlyif mysql # aggregate syntax: 
query I rowsort label-27
SELECT + MAX( 5 ) AS col0 FROM tab2 AS cor0
----
5

skipif mysql # not compatible
query I rowsort label-27
SELECT + MAX ( 5 ) AS col0 FROM tab2 AS cor0
----
5

query I rowsort
SELECT DISTINCT col1 AS col0 FROM tab2 WHERE NULL NOT BETWEEN ( + - col2 ) AND NULL
----

query I rowsort
SELECT - 24 + + - 98 AS col1 FROM tab0 AS cor0
----
-122
-122
-122

query I rowsort
SELECT DISTINCT + 26 AS col2 FROM tab0 cor0
----
26

onlyif mysql # aggregate syntax: 
query I rowsort label-31
SELECT - + 27 + COUNT( + + 43 ) + + - COUNT( * ) FROM tab2 cor0
----
-27

skipif mysql # not compatible
query I rowsort label-31
SELECT - + 27 + COUNT ( + + 43 ) + + - COUNT ( * ) FROM tab2 cor0
----
-27

onlyif mysql # aggregate syntax: 
query I rowsort label-32
SELECT ALL - + SUM( 75 ) AS col0 FROM tab2 AS cor0
----
-225

skipif mysql # not compatible
query I rowsort label-32
SELECT ALL - + SUM ( 75 ) AS col0 FROM tab2 AS cor0
----
-225

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-33
SELECT col0 * + col1 * + + 83 + + ( - + CAST( NULL AS SIGNED ) ) + + col1 FROM tab2 AS cor0 WHERE + ( col1 ) * 15 / - col2 * - col0 IS NULL
----

skipif mysql # not compatible
query I rowsort label-33
SELECT col0 * + col1 * + + 83 + + ( - + CAST ( NULL AS INTEGER ) ) + + col1 FROM tab2 AS cor0 WHERE + ( col1 ) * 15 / - col2 * - col0 IS NULL
----

query I rowsort
SELECT + col2 AS col1 FROM tab0 cor0 WHERE + 70 IS NOT NULL
----
10
47
99

onlyif mysql # aggregate syntax: 
query I rowsort label-35
SELECT ALL - COUNT( DISTINCT - 32 ) AS col2 FROM tab0
----
-1

skipif mysql # not compatible
query I rowsort label-35
SELECT ALL - COUNT ( DISTINCT - 32 ) AS col2 FROM tab0
----
-1

onlyif mysql # aggregate syntax: DIV for integer division: 
query I rowsort label-36
SELECT + 25 DIV ( - COUNT( * ) ) + COUNT( * ) AS col1 FROM tab2
----
-5

skipif mysql # not compatible
query I rowsort label-36
SELECT + 25 / ( - COUNT ( * ) ) + COUNT ( * ) AS col1 FROM tab2
----
-5

query I rowsort
SELECT DISTINCT ( + col0 ) FROM tab1 WHERE - col2 IS NULL
----

query I rowsort
SELECT ALL + 73 * + + col0 - + - col2 FROM tab0
----
1142
6361
7180

query I rowsort
SELECT 90 * - col1 FROM tab2
----
-4590
-6030
-6930

query I rowsort
SELECT ALL - 2 - - col1 AS col0 FROM tab0
----
-1
19
79

onlyif mysql # aggregate syntax: 
query I rowsort label-41
SELECT ALL COUNT( ALL col2 ) - 6 * - 99 FROM tab0
----
597

skipif mysql # not compatible
query I rowsort label-41
SELECT ALL COUNT ( ALL col2 ) - 6 * - 99 FROM tab0
----
597

query III rowsort
SELECT ALL * FROM tab2 cor0 WHERE NOT NULL >= 45
----

onlyif mysql # aggregate syntax: 
query I rowsort label-43
SELECT ALL + - MIN( + col2 ) FROM tab2 AS cor0
----
-23

skipif mysql # not compatible
query I rowsort label-43
SELECT ALL + - MIN ( + col2 ) FROM tab2 AS cor0
----
-23

query II rowsort
SELECT col0, - col0 AS col1 FROM tab2
----
46
-46
64
-64
75
-75

query I rowsort
SELECT DISTINCT + + 5 AS col2 FROM tab1 AS cor0 CROSS JOIN tab0 AS cor1
----
5

onlyif mysql # aggregate syntax: 
query I rowsort label-46
SELECT DISTINCT + + 79 - COUNT( * ) * - 11 FROM tab0 AS cor0 CROSS JOIN tab0 AS cor1
----
178

skipif mysql # not compatible
query I rowsort label-46
SELECT DISTINCT + + 79 - COUNT ( * ) * - 11 FROM tab0 AS cor0 CROSS JOIN tab0 AS cor1
----
178

onlyif mysql # aggregate syntax: 
query I rowsort label-47
SELECT DISTINCT + + COUNT( * ) FROM tab0 WHERE + col2 IS NOT NULL
----
3

skipif mysql # not compatible
query I rowsort label-47
SELECT DISTINCT + + COUNT ( * ) FROM tab0 WHERE + col2 IS NOT NULL
----
3

onlyif mysql # aggregate syntax: 
query I rowsort label-48
SELECT DISTINCT MAX( + 75 ) * + 11 AS col0 FROM tab1 cor0
----
825

skipif mysql # not compatible
query I rowsort label-48
SELECT DISTINCT MAX ( + 75 ) * + 11 AS col0 FROM tab1 cor0
----
825

query I rowsort
SELECT + + ( - ( + - 55 ) ) FROM tab0 AS cor0
----
55
55
55

query I rowsort
SELECT + - ( + - 36 ) AS col1 FROM tab2 AS cor0
----
36
36
36

onlyif mysql # aggregate syntax: 
query I rowsort label-51
SELECT + MIN( - col0 ) * + COUNT( * ) AS col2 FROM tab0 cor0
----
-291

skipif mysql # not compatible
query I rowsort label-51
SELECT + MIN ( - col0 ) * + COUNT ( * ) AS col2 FROM tab0 cor0
----
-291

query II rowsort
SELECT col2 AS col0, - 26 + col1 FROM tab1 AS cor0
----
59
-21
68
21
96
-12

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query II rowsort label-53
SELECT - COUNT( * ) * CAST( NULL AS SIGNED ) AS col0, - COUNT( DISTINCT CAST( NULL AS SIGNED ) ) FROM tab1
----
NULL
0

skipif mysql # not compatible
query II rowsort label-53
SELECT - COUNT ( * ) * CAST ( NULL AS INTEGER ) AS col0, - COUNT ( DISTINCT CAST ( NULL AS INTEGER ) ) FROM tab1
----
NULL
0

query II rowsort
SELECT ALL - ( 15 ), col0 FROM tab2
----
-15
46
-15
64
-15
75

onlyif mysql # aggregate syntax: 
query I rowsort label-55
SELECT + MIN( ALL + 81 ) AS col0 FROM tab0
----
81

skipif mysql # not compatible
query I rowsort label-55
SELECT + MIN ( ALL + 81 ) AS col0 FROM tab0
----
81

onlyif mysql # aggregate syntax: 
query I rowsort label-56
SELECT ALL - - COUNT( DISTINCT col0 ) - - MAX( - 61 ) + - - 87 AS col0 FROM tab1 WHERE NOT NULL IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-56
SELECT ALL - - COUNT ( DISTINCT col0 ) - - MAX ( - 61 ) + - - 87 AS col0 FROM tab1 WHERE NOT NULL IS NULL
----
NULL

query I rowsort
SELECT ALL 52 * - ( + col0 ) * + col2 AS col0 FROM tab0
----
-36660
-45240
-499356

query III rowsort
SELECT DISTINCT * FROM tab0 WHERE NOT col2 + + col0 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-59
SELECT DISTINCT + COUNT( + + col1 ) FROM tab0
----
3

skipif mysql # not compatible
query I rowsort label-59
SELECT DISTINCT + COUNT ( + + col1 ) FROM tab0
----
3

query II rowsort
SELECT ALL + - col1 + - col0 AS col1, 5 * + col1 AS col0 FROM tab1 AS cor0
----
-138
235
-65
70
-90
25

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT - col2 + - 90 col0 FROM tab2 cor0
----
-113
-130
-148

onlyif mysql # CAST syntax: DECIMAL type: 
query II rowsort label-62
SELECT - AVG ( ALL - col0 ) + - + CAST( NULL AS DECIMAL ) AS col2, - 48 col1 FROM tab1
----
NULL
-48

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-62
SELECT - AVG ( ALL - col0 ) + - + CAST ( NULL AS REAL ) AS col2, - 48 col1 FROM tab1
----
NULL
-48

onlyif mysql # DIV for integer division: 
query I rowsort label-63
SELECT DISTINCT - 82 DIV col2 * col1 FROM tab0
----
-168
-81
0

skipif mysql # not compatible
query I rowsort label-63
SELECT DISTINCT - 82 / col2 * col1 FROM tab0
----
-168
-81
0

query I rowsort
SELECT DISTINCT - 71 + - col0 FROM tab1
----
-122
-156
-162

onlyif mysql # aggregate syntax: DIV for integer division: 
query I rowsort label-65
SELECT ALL - MAX( - col0 ) DIV - 81 AS col1 FROM tab1 AS cor0
----
0

skipif mysql # not compatible
query I rowsort label-65
SELECT ALL - MAX ( - col0 ) / - 81 AS col1 FROM tab1 AS cor0
----
0

query II rowsort
SELECT ALL col2, 38 FROM tab1 AS cor0
----
59
38
68
38
96
38

onlyif mysql # aggregate syntax: 
query I rowsort label-67
SELECT + COUNT( * ) * - + 88 AS col1 FROM tab0 AS cor0
----
-264

skipif mysql # not compatible
query I rowsort label-67
SELECT + COUNT ( * ) * - + 88 AS col1 FROM tab0 AS cor0
----
-264

onlyif mysql # DIV for integer division: 
query I rowsort label-68
SELECT + ( - col1 ) DIV + col2 FROM tab1 AS cor0
----
0
0
0

skipif mysql # not compatible
query I rowsort label-68
SELECT + ( - col1 ) / + col2 FROM tab1 AS cor0
----
0
0
0

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT col1 * col1 * - - col0 col0 FROM tab0 AS cor0
----
38367
97
98415

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-70
SELECT - - 96, + CAST( NULL AS SIGNED ) * - CAST( NULL AS SIGNED ) AS col0 FROM tab1 AS cor0
----
96
NULL
96
NULL
96
NULL

skipif mysql # not compatible
query II rowsort label-70
SELECT - - 96, + CAST ( NULL AS INTEGER ) * - CAST ( NULL AS INTEGER ) AS col0 FROM tab1 AS cor0
----
96
NULL
96
NULL
96
NULL

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-71
SELECT CAST( 24 AS SIGNED ) AS col2 FROM tab0 AS cor0 WHERE + 62 IS NULL
----

skipif mysql # not compatible
query I rowsort label-71
SELECT CAST ( 24 AS INTEGER ) AS col2 FROM tab0 AS cor0 WHERE + 62 IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-72
SELECT COUNT( * ) AS col2 FROM tab2 WHERE + col2 NOT BETWEEN - - col0 AND col2
----
3

skipif mysql # not compatible
query I rowsort label-72
SELECT COUNT ( * ) AS col2 FROM tab2 WHERE + col2 NOT BETWEEN - - col0 AND col2
----
3

query I rowsort
SELECT DISTINCT - col2 + - - col1 * - - col2 FROM tab2
----
1150
3040
3828

onlyif mysql # aggregate syntax: 
query I rowsort label-74
SELECT DISTINCT 71 + - SUM( + 84 ) col2 FROM tab2
----
-181

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-74
SELECT DISTINCT 71 + - SUM ( + 84 ) col2 FROM tab2
----
-181

onlyif mysql # aggregate syntax: 
query I rowsort label-75
SELECT - 11 + COUNT( * ) AS col0 FROM tab1
----
-8

skipif mysql # not compatible
query I rowsort label-75
SELECT - 11 + COUNT ( * ) AS col0 FROM tab1
----
-8

onlyif mysql # aggregate syntax: 
query II rowsort label-76
SELECT DISTINCT COUNT( * ) AS col1, + 27 * 66 FROM tab0, tab2 AS cor0
----
9
1782

skipif mysql # not compatible
query II rowsort label-76
SELECT DISTINCT COUNT ( * ) AS col1, + 27 * 66 FROM tab0, tab2 AS cor0
----
9
1782

onlyif mysql # aggregate syntax: 
query I rowsort label-77
SELECT + MAX( + ( col1 ) ) AS col0 FROM tab0 AS cor0
----
81

skipif mysql # not compatible
query I rowsort label-77
SELECT + MAX ( + ( col1 ) ) AS col0 FROM tab0 AS cor0
----
81

onlyif mysql # aggregate syntax: 
query I rowsort label-78
SELECT 85 * + SUM( + col0 ) FROM tab2 AS cor0
----
15725

skipif mysql # not compatible
query I rowsort label-78
SELECT 85 * + SUM ( + col0 ) FROM tab2 AS cor0
----
15725

query I rowsort
SELECT 4 * - - col0 FROM tab0
----
348
388
60

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-80
SELECT DISTINCT AVG ( ALL - + CAST( NULL AS SIGNED ) ) FROM tab1 AS cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-80
SELECT DISTINCT AVG ( ALL - + CAST ( NULL AS INTEGER ) ) FROM tab1 AS cor0
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-81
SELECT ALL + MAX( DISTINCT + - col0 ) FROM tab1 AS cor0
----
-51

skipif mysql # not compatible
query I rowsort label-81
SELECT ALL + MAX ( DISTINCT + - col0 ) FROM tab1 AS cor0
----
-51

onlyif mysql # aggregate syntax: 
query I rowsort label-82
SELECT DISTINCT + MAX( - 33 ) FROM tab0 AS cor0
----
-33

skipif mysql # not compatible
query I rowsort label-82
SELECT DISTINCT + MAX ( - 33 ) FROM tab0 AS cor0
----
-33

query I rowsort
SELECT DISTINCT - col0 AS col1 FROM tab2 cor0 WHERE NULL IS NULL
----
-46
-64
-75

query I rowsort
SELECT DISTINCT col0 + + + 58 AS col2 FROM tab0
----
145
155
73

query I rowsort
SELECT ALL - col1 + - ( - + col2 ) FROM tab0
----
-11
-34
98

query I rowsort
SELECT DISTINCT - - 81 + + col0 + 35 AS col1 FROM tab1 WHERE NOT + 74 <= + + col2
----
201
207

query I rowsort
SELECT ALL + - 86 FROM tab1 WHERE NOT - 86 = + col2 / - col1
----
-86
-86
-86

onlyif mysql # aggregate syntax: 
query I rowsort label-88
SELECT - 15 + + COUNT( * ) FROM tab2
----
-12

skipif mysql # not compatible
query I rowsort label-88
SELECT - 15 + + COUNT ( * ) FROM tab2
----
-12

onlyif mysql # aggregate syntax: 
query I rowsort label-89
SELECT ALL + COUNT( - + col0 ) AS col1 FROM tab0
----
3

skipif mysql # not compatible
query I rowsort label-89
SELECT ALL + COUNT ( - + col0 ) AS col1 FROM tab0
----
3

query III rowsort
SELECT ALL * FROM tab2 WHERE NOT + - col2 * - - col2 <> col2
----

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-91
SELECT + CAST( NULL AS SIGNED ) * - col2 * - + 65 + + + col0, - 34 AS col1 FROM tab1 AS cor0
----
NULL
-34
NULL
-34
NULL
-34

skipif mysql # not compatible
query II rowsort label-91
SELECT + CAST ( NULL AS INTEGER ) * - col2 * - + 65 + + + col0, - 34 AS col1 FROM tab1 AS cor0
----
NULL
-34
NULL
-34
NULL
-34

onlyif mysql # aggregate syntax: 
query I rowsort label-92
SELECT + 94 * + COUNT( * ) AS col0 FROM tab2 AS cor0
----
282

skipif mysql # not compatible
query I rowsort label-92
SELECT + 94 * + COUNT ( * ) AS col0 FROM tab2 AS cor0
----
282

query II rowsort
SELECT + col2 AS col0, + col1 * - - col2 FROM tab1 AS cor0
----
59
295
68
3196
96
1344

query I rowsort
SELECT + col0 + + 98 FROM tab0
----
113
185
195

query I rowsort
SELECT ( col2 ) + - col2 AS col1 FROM tab1
----
0
0
0

query I rowsort
SELECT ALL + 27 FROM tab2 AS cor0 CROSS JOIN tab2 AS cor1
----
9 values hashing to 701bf12d86392cb1585d9e4f3c72e9a8

onlyif mysql # aggregate syntax: 
query I rowsort label-97
SELECT + 0 * + + MIN( DISTINCT + + col2 ) + + ( + - ( COUNT( * ) ) ) FROM tab0 AS cor0
----
-3

skipif mysql # not compatible
query I rowsort label-97
SELECT + 0 * + + MIN ( DISTINCT + + col2 ) + + ( + - ( COUNT ( * ) ) ) FROM tab0 AS cor0
----
-3

query I rowsort
SELECT ALL - + 52 - col0 AS col0 FROM tab0 cor0
----
-139
-149
-67

onlyif mysql # aggregate syntax: 
query I rowsort label-99
SELECT 31 + MAX( DISTINCT 37 ) col0 FROM tab0 AS cor0
----
68

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-99
SELECT 31 + MAX ( DISTINCT 37 ) col0 FROM tab0 AS cor0
----
68

onlyif mysql # aggregate syntax: 
query I rowsort label-100
SELECT ALL - - MIN( ALL 29 ) * COUNT( * ) AS col0 FROM tab1 AS cor0
----
87

skipif mysql # not compatible
query I rowsort label-100
SELECT ALL - - MIN ( ALL 29 ) * COUNT ( * ) AS col0 FROM tab1 AS cor0
----
87

query I rowsort
SELECT - 21 * + 50 FROM tab1
----
-1050
-1050
-1050

onlyif mysql # aggregate syntax: 
query I rowsort label-102
SELECT DISTINCT 69 + MIN( ALL + col2 ) AS col1 FROM tab1
----
128

skipif mysql # not compatible
query I rowsort label-102
SELECT DISTINCT 69 + MIN ( ALL + col2 ) AS col1 FROM tab1
----
128

onlyif mysql # aggregate syntax: 
query I rowsort label-103
SELECT ALL + 37 * + COUNT( * ) AS col1 FROM tab1 WHERE NOT col2 NOT BETWEEN - 74 AND - col2
----
0

skipif mysql # not compatible
query I rowsort label-103
SELECT ALL + 37 * + COUNT ( * ) AS col1 FROM tab1 WHERE NOT col2 NOT BETWEEN - 74 AND - col2
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-104
SELECT SUM( + 60 ) FROM tab0
----
180

skipif mysql # not compatible
query I rowsort label-104
SELECT SUM ( + 60 ) FROM tab0
----
180

onlyif mysql # DIV for integer division: 
query I rowsort label-105
SELECT DISTINCT col1 DIV + - col2 FROM tab2
----
-1
-2

skipif mysql # not compatible
query I rowsort label-105
SELECT DISTINCT col1 / + - col2 FROM tab2
----
-1
-2

onlyif mysql # aggregate syntax: 
query I rowsort label-106
SELECT SUM( ALL + 90 ) AS col2 FROM tab1
----
270

skipif mysql # not compatible
query I rowsort label-106
SELECT SUM ( ALL + 90 ) AS col2 FROM tab1
----
270

onlyif mysql # aggregate syntax: 
query I rowsort label-107
SELECT ALL - + COUNT( ALL col0 ) AS col1 FROM tab1 cor0
----
-3

skipif mysql # not compatible
query I rowsort label-107
SELECT ALL - + COUNT ( ALL col0 ) AS col1 FROM tab1 cor0
----
-3

onlyif mysql # aggregate syntax: 
query I rowsort label-108
SELECT DISTINCT 93 * COUNT( * ) FROM tab2 AS cor0
----
279

skipif mysql # not compatible
query I rowsort label-108
SELECT DISTINCT 93 * COUNT ( * ) FROM tab2 AS cor0
----
279

query I rowsort
SELECT DISTINCT col2 FROM tab0 AS cor0 WHERE NOT ( NULL ) < NULL
----

query I rowsort
SELECT DISTINCT - - 56 AS col0 FROM tab2 AS cor0
----
56

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-111
SELECT ALL - CAST( + 1 AS SIGNED ), 97 + + 20 AS col1 FROM tab1 cor0
----
-1
117
-1
117
-1
117

skipif mysql # not compatible
query II rowsort label-111
SELECT ALL - CAST ( + 1 AS INTEGER ), 97 + + 20 AS col1 FROM tab1 cor0
----
-1
117
-1
117
-1
117

onlyif mysql # aggregate syntax: 
query I rowsort label-112
SELECT - SUM( col1 ) * 97 FROM tab2 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND col1
----
NULL

skipif mysql # not compatible
query I rowsort label-112
SELECT - SUM ( col1 ) * 97 FROM tab2 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND col1
----
NULL

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-113
SELECT ALL + - CAST( + + MAX( ALL - + 61 ) AS SIGNED ) FROM tab0 AS cor0
----
61

skipif mysql # not compatible
query I rowsort label-113
SELECT ALL + - CAST ( + + MAX ( ALL - + 61 ) AS INTEGER ) FROM tab0 AS cor0
----
61

query I rowsort
SELECT DISTINCT + col2 * - 67 AS col1 FROM tab0 AS cor0
----
-3149
-6633
-670

query I rowsort
SELECT ALL 26 + + + col1 - - ( - + 53 ) - + col2 * 93 * - + 12 FROM tab0
----
110458
11154
52506

onlyif mysql # aggregate syntax: 
query I rowsort label-116
SELECT - SUM( - - 32 ) AS col2 FROM tab0
----
-96

skipif mysql # not compatible
query I rowsort label-116
SELECT - SUM ( - - 32 ) AS col2 FROM tab0
----
-96

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL + col2 + - ( - col2 ) * + col0 col0 FROM tab0
----
752
880
9702

query I rowsort
SELECT DISTINCT + col1 + 46 FROM tab2
----
113
123
97

onlyif mysql # DIV for integer division: 
query I rowsort label-119
SELECT ALL + col2 + col1 * 77 DIV col1 FROM tab1
----
136
145
173

skipif mysql # not compatible
query I rowsort label-119
SELECT ALL + col2 + col1 * 77 / col1 FROM tab1
----
136
145
173

onlyif mysql # DIV for integer division: 
query I rowsort label-120
SELECT + col0 + + + col0 DIV - + col1 FROM tab2 AS cor0
----
46
64
74

skipif mysql # not compatible
query I rowsort label-120
SELECT + col0 + + + col0 / - + col1 FROM tab2 AS cor0
----
46
64
74

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-121
SELECT ALL + + CAST( + COUNT( * ) AS SIGNED ) AS col1 FROM tab1 AS cor0
----
3

skipif mysql # not compatible
query I rowsort label-121
SELECT ALL + + CAST ( + COUNT ( * ) AS INTEGER ) AS col1 FROM tab1 AS cor0
----
3

query I rowsort
SELECT col2 + + col2 - + col1 + - + 40 AS col2 FROM tab0 AS cor0
----
-27
-41
157

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-123
SELECT col1 * + 49 AS col0 FROM tab1 AS cor0 WHERE + CAST( NULL AS SIGNED ) NOT IN ( + col0 * + col0 )
----

skipif mysql # not compatible
query I rowsort label-123
SELECT col1 * + 49 AS col0 FROM tab1 AS cor0 WHERE + CAST ( NULL AS INTEGER ) NOT IN ( + col0 * + col0 )
----

query I rowsort
SELECT DISTINCT ( + 54 ) + + col1 FROM tab1
----
101
59
68

query II rowsort
SELECT - 71, col2 * - ( + col2 ) AS col1 FROM tab1 WHERE - col1 IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-126
SELECT - MAX( DISTINCT + 62 ) AS col0 FROM tab2
----
-62

skipif mysql # not compatible
query I rowsort label-126
SELECT - MAX ( DISTINCT + 62 ) AS col0 FROM tab2
----
-62

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-127
SELECT ALL * FROM tab2 AS cor0 WHERE col1 / + CAST( NULL AS SIGNED ) NOT BETWEEN NULL AND + + 81
----

skipif mysql # not compatible
query III rowsort label-127
SELECT ALL * FROM tab2 AS cor0 WHERE col1 / + CAST ( NULL AS INTEGER ) NOT BETWEEN NULL AND + + 81
----

onlyif mysql # aggregate syntax: DIV for integer division: 
query I rowsort label-128
SELECT DISTINCT - + COUNT( * ) DIV + - 24 - + 68 col2 FROM tab2 cor0
----
-68

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-128
SELECT DISTINCT - + COUNT ( * ) / + - 24 - + 68 col2 FROM tab2 cor0
----
-68

query I rowsort
SELECT DISTINCT - col0 * - 63 FROM tab0 AS cor0
----
5481
6111
945

onlyif mysql # aggregate syntax: 
query I rowsort label-130
SELECT - + COUNT( + + col1 ) FROM tab1 AS cor0
----
-3

skipif mysql # not compatible
query I rowsort label-130
SELECT - + COUNT ( + + col1 ) FROM tab1 AS cor0
----
-3

query I rowsort
SELECT ALL col1 - + col0 * + 52 * - col0 FROM tab1 AS cor0
----
135266
375705
430659

query I rowsort
SELECT DISTINCT + col1 - + + col1 * ( + - col1 ) FROM tab0 AS cor0
----
2
462
6642

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-133
SELECT DISTINCT + + CAST( - - 20 AS SIGNED ) * - + 67 col0 FROM tab2 AS cor0
----
-1340

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-133
SELECT DISTINCT + + CAST ( - - 20 AS INTEGER ) * - + 67 col0 FROM tab2 AS cor0
----
-1340

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-134
SELECT ALL - CAST( + + 61 AS SIGNED ) + - 36 FROM tab1 AS cor0
----
-97
-97
-97

skipif mysql # not compatible
query I rowsort label-134
SELECT ALL - CAST ( + + 61 AS INTEGER ) + - 36 FROM tab1 AS cor0
----
-97
-97
-97

query I rowsort
SELECT DISTINCT 23 * - 49 * 52 + + 81 FROM tab1 AS cor0
----
-58523

query I rowsort
SELECT ALL - 88 * - col0 * + - col2 AS col0 FROM tab1 AS cor0
----
-430848
-441320
-544544

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - + 55 col1, - 84 AS col0 FROM tab2 WHERE NOT NULL IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-138
SELECT DISTINCT SUM( - + col1 ) FROM tab2 WHERE NOT + col1 IS NULL
----
-195

skipif mysql # not compatible
query I rowsort label-138
SELECT DISTINCT SUM ( - + col1 ) FROM tab2 WHERE NOT + col1 IS NULL
----
-195

onlyif mysql # aggregate syntax: 
query I rowsort label-139
SELECT ALL SUM( - col0 ) FROM tab1 WHERE NOT col2 IS NOT NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-139
SELECT ALL SUM ( - col0 ) FROM tab1 WHERE NOT col2 IS NOT NULL
----
NULL

query III rowsort
SELECT DISTINCT * FROM tab0 AS cor0 WHERE col0 + col2 IS NOT NULL
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: DIV for integer division: 
query I rowsort label-141
SELECT DISTINCT + COUNT( DISTINCT + col2 ) DIV - ( 69 ) + - - CAST( 9 AS SIGNED ) * + COUNT( * ) FROM tab1 AS cor0 WHERE ( NULL ) IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-141
SELECT DISTINCT + COUNT ( DISTINCT + col2 ) / - ( 69 ) + - - CAST ( 9 AS INTEGER ) * + COUNT ( * ) FROM tab1 AS cor0 WHERE ( NULL ) IS NOT NULL
----
0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-142
SELECT ALL + + col0 / - + col2 FROM tab0 AS cor0 WHERE + CAST( NULL AS SIGNED ) NOT IN ( - + CAST( - + 85 AS SIGNED ), + 69 / + + col0 * + 12 * - col0 )
----

skipif mysql # not compatible
query I rowsort label-142
SELECT ALL + + col0 / - + col2 FROM tab0 AS cor0 WHERE + CAST ( NULL AS INTEGER ) NOT IN ( - + CAST ( - + 85 AS INTEGER ), + 69 / + + col0 * + 12 * - col0 )
----

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-143
SELECT ALL 70 * - + CAST( - - COUNT( * ) AS SIGNED ) FROM tab0, tab1 AS cor0
----
-630

skipif mysql # not compatible
query I rowsort label-143
SELECT ALL 70 * - + CAST ( - - COUNT ( * ) AS INTEGER ) FROM tab0, tab1 AS cor0
----
-630

onlyif mysql # DIV for integer division: 
query I rowsort label-144
SELECT col2 DIV 3 * - 36 FROM tab1
----
-1152
-684
-792

skipif mysql # not compatible
query I rowsort label-144
SELECT col2 / 3 * - 36 FROM tab1
----
-1152
-684
-792

query III rowsort
SELECT * FROM tab2 AS cor0 WHERE NULL IS NOT NULL OR - 56 + + 21 IS NOT NULL
----
9 values hashing to 75c998aa53ac83218cbf2feb962d0a49

query III rowsort
SELECT * FROM tab0 AS cor0 WHERE NOT col2 + - - ( + col2 ) + col2 + - col0 / - col0 + + col1 = col0 + + col1 * + col2
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-147
SELECT DISTINCT - CAST( NULL AS SIGNED ) + - CAST( COUNT( col2 ) AS SIGNED ) - COUNT( * ) AS col1 FROM tab0 cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-147
SELECT DISTINCT - CAST ( NULL AS INTEGER ) + - CAST ( COUNT ( col2 ) AS INTEGER ) - COUNT ( * ) AS col1 FROM tab0 cor0
----
NULL

onlyif mysql # DIV for integer division: 
query I rowsort label-148
SELECT DISTINCT col1 + col2 DIV + col0 AS col2 FROM tab2
----
51
67
77

skipif mysql # not compatible
query I rowsort label-148
SELECT DISTINCT col1 + col2 / + col0 AS col2 FROM tab2
----
51
67
77

onlyif mysql # aggregate syntax: 
query I rowsort label-149
SELECT DISTINCT + 32 + - COUNT( DISTINCT - 70 ) FROM tab1
----
31

skipif mysql # not compatible
query I rowsort label-149
SELECT DISTINCT + 32 + - COUNT ( DISTINCT - 70 ) FROM tab1
----
31

query II rowsort
SELECT col0 * - col2, + col0 * col1 AS col2 FROM tab0
----
-705
1215
-870
1827
-9603
97

onlyif mysql # aggregate syntax: 
query I rowsort label-151
SELECT ALL - 64 + + MAX( ALL 26 ) FROM tab0
----
-38

skipif mysql # not compatible
query I rowsort label-151
SELECT ALL - 64 + + MAX ( ALL 26 ) FROM tab0
----
-38

onlyif mysql # aggregate syntax: DIV for integer division: 
query I rowsort label-152
SELECT COUNT( * ) DIV - 91 * + 90 FROM tab2
----
0

skipif mysql # not compatible
query I rowsort label-152
SELECT COUNT ( * ) / - 91 * + 90 FROM tab2
----
0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-153
SELECT DISTINCT + CAST( NULL AS SIGNED ) * - 98 AS col2 FROM tab2
----
NULL

skipif mysql # not compatible
query I rowsort label-153
SELECT DISTINCT + CAST ( NULL AS INTEGER ) * - 98 AS col2 FROM tab2
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-154
SELECT 88 * COUNT( * ) FROM tab1
----
264

skipif mysql # not compatible
query I rowsort label-154
SELECT 88 * COUNT ( * ) FROM tab1
----
264

query III rowsort
SELECT * FROM tab2 AS cor0 WHERE ( NULL ) BETWEEN NULL AND - col1
----

query I rowsort
SELECT + col2 + - 48 FROM tab0
----
-1
-38
51

query III rowsort
SELECT * FROM tab2 WHERE - + col1 > + col2
----

query I rowsort
SELECT DISTINCT - col0 - + + 43 FROM tab0 WHERE NOT 51 IS NULL OR NOT 4 NOT BETWEEN - + 45 AND NULL
----
-130
-140
-58

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-159
SELECT DISTINCT + CAST( NULL AS SIGNED ) * + + col1 AS col2 FROM tab1 AS cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-159
SELECT DISTINCT + CAST ( NULL AS INTEGER ) * + + col1 AS col2 FROM tab1 AS cor0
----
NULL

query I rowsort
SELECT DISTINCT - 94 - + ( col1 ) - - 0 AS col1 FROM tab2 AS cor0
----
-145
-161
-171

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-161
SELECT DISTINCT CAST( NULL AS SIGNED ), col1 AS col2 FROM tab0 AS cor0
----
NULL
1
NULL
21
NULL
81

skipif mysql # not compatible
query II rowsort label-161
SELECT DISTINCT CAST ( NULL AS INTEGER ), col1 AS col2 FROM tab0 AS cor0
----
NULL
1
NULL
21
NULL
81

query III rowsort
SELECT DISTINCT * FROM tab1 AS cor0 WHERE - col1 + - - col1 IN ( - - col2, col2, col2 + col0, - - 39 )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - - 82 col2 FROM tab1 AS cor0
----
82
82
82

onlyif mysql # aggregate syntax: 
query I rowsort label-164
SELECT ALL + - MAX( ALL 91 ) AS col1 FROM tab2 AS cor0
----
-91

skipif mysql # not compatible
query I rowsort label-164
SELECT ALL + - MAX ( ALL 91 ) AS col1 FROM tab2 AS cor0
----
-91

query I rowsort
SELECT DISTINCT - - ( + col2 ) * - + col2 * - col0 * - + 64 + 27 AS col2 FROM tab0 AS cor0
----
-2120613
-556773
-60844581

query I rowsort
SELECT + 58 * - - col0 FROM tab1 cor0
----
2958
4930
5278

onlyif mysql # DIV for integer division: 
query I rowsort label-167
SELECT - + 16 DIV + col0 FROM tab2 AS cor0
----
0
0
0

skipif mysql # not compatible
query I rowsort label-167
SELECT - + 16 / + col0 FROM tab2 AS cor0
----
0
0
0

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-168
SELECT - col2, + 38 AS col1, col1 + + CAST( NULL AS SIGNED ) AS col0 FROM tab0
----
9 values hashing to 602b53657ce743479e7fd731d12d5ae5

skipif mysql # not compatible
query III rowsort label-168
SELECT - col2, + 38 AS col1, col1 + + CAST ( NULL AS INTEGER ) AS col0 FROM tab0
----
9 values hashing to 602b53657ce743479e7fd731d12d5ae5

query I rowsort
SELECT DISTINCT + col0 * + 93 AS col2 FROM tab1
----
4743
7905
8463

query II rowsort
SELECT + col0 AS col2, + col0 * + - col1 AS col0 FROM tab0
----
15
-1215
87
-1827
97
-97

query I rowsort
SELECT 12 * col2 AS col0 FROM tab2
----
276
480
696

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-172
SELECT DISTINCT + + col1 AS col0 FROM tab1 WHERE + 86 / - col2 NOT IN ( - col1 + 7, + col1, + - CAST( - + col1 AS SIGNED ) )
----
14
47
5

skipif mysql # not compatible
query I rowsort label-172
SELECT DISTINCT + + col1 AS col0 FROM tab1 WHERE + 86 / - col2 NOT IN ( - col1 + 7, + col1, + - CAST ( - + col1 AS INTEGER ) )
----
14
47
5

query II rowsort
SELECT ALL + col0, col2 * - ( 42 ) * - + 39 FROM tab2
----
46
37674
64
65520
75
95004

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col0 AS col0, 79 col2 FROM tab1
----
51
79
85
79
91
79

query III rowsort
SELECT * FROM tab1 cor0 WHERE NOT NULL NOT BETWEEN NULL AND + col0
----

query III rowsort
SELECT * FROM tab1 cor0 WHERE NOT col0 <= NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-177
SELECT ALL CAST( + 61 AS SIGNED ) * + - col2 AS col0 FROM tab2 cor0
----
-1403
-2440
-3538

skipif mysql # not compatible
query I rowsort label-177
SELECT ALL CAST ( + 61 AS INTEGER ) * + - col2 AS col0 FROM tab2 cor0
----
-1403
-2440
-3538

query I rowsort
SELECT - ( + - 90 ) AS col2 FROM tab0 AS cor0
----
90
90
90

onlyif mysql # DIV for integer division: 
query I rowsort label-179
SELECT DISTINCT + 61 DIV - + 69 FROM tab1 AS cor0
----
0

skipif mysql # not compatible
query I rowsort label-179
SELECT DISTINCT + 61 / - + 69 FROM tab1 AS cor0
----
0

query I rowsort
SELECT ALL + - ( 95 ) AS col2 FROM tab0 AS cor0
----
-95
-95
-95

query II rowsort
SELECT + + col1, 5 FROM tab1 AS cor0
----
14
5
47
5
5
5

query I rowsort
SELECT col0 FROM tab1 AS cor0 WHERE - col2 NOT IN ( + col0 + col1 + - 55 + - col0 )
----
51
85
91

query III rowsort
SELECT ALL * FROM tab2 AS cor0 WHERE 9 / col0 IS NULL
----

query I rowsort
SELECT - col2 * - - 43 FROM tab0 AS cor0
----
-2021
-4257
-430

query III rowsort
SELECT ALL * FROM tab1 AS cor0 WHERE + 77 IS NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + 39 AS col2, col1 - 51 col2 FROM tab2
----
39
0
39
16
39
26

query I rowsort
SELECT DISTINCT + col0 + - 13 + - col1 + col0 AS col1 FROM tab2
----
28
38
70

onlyif mysql # aggregate syntax: 
query I rowsort label-188
SELECT DISTINCT COUNT( * ) + - - ( + 37 ) AS col2 FROM tab2
----
40

skipif mysql # not compatible
query I rowsort label-188
SELECT DISTINCT COUNT ( * ) + - - ( + 37 ) AS col2 FROM tab2
----
40

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-189
SELECT ALL 46 + ( - CAST( NULL AS SIGNED ) ) FROM tab1
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-189
SELECT ALL 46 + ( - CAST ( NULL AS INTEGER ) ) FROM tab1
----
NULL
NULL
NULL

query III rowsort
SELECT ALL * FROM tab1 WHERE NOT - 15 IS NOT NULL
----

query III rowsort
SELECT * FROM tab1 WHERE col1 / col2 NOT BETWEEN ( NULL ) AND NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-192
SELECT DISTINCT - 57 - - MIN( ALL + - 15 ) AS col2 FROM tab2 AS cor0
----
-72

skipif mysql # not compatible
query I rowsort label-192
SELECT DISTINCT - 57 - - MIN ( ALL + - 15 ) AS col2 FROM tab2 AS cor0
----
-72

query I rowsort
SELECT - col1 + + + col2 FROM tab1 cor0
----
21
54
82

query III rowsort
SELECT DISTINCT * FROM tab1 cor0 WHERE NOT col2 + - 35 IS NULL
----
9 values hashing to c6c0a4111b36d04dbc811a11e4d54cad

onlyif mysql # DIV for integer division: 
query I rowsort label-195
SELECT DISTINCT - 33 DIV - + 65 * + - 29 * - col1 AS col0 FROM tab0 AS cor0
----
0

skipif mysql # not compatible
query I rowsort label-195
SELECT DISTINCT - 33 / - + 65 * + - 29 * - col1 AS col0 FROM tab0 AS cor0
----
0

query I rowsort
SELECT + 37 FROM tab1 AS cor0 CROSS JOIN tab0 AS cor1
----
9 values hashing to a10b03e72860b949bdff53827700a9a8

query II rowsort
SELECT 41 + - col2, - 12 AS col2 FROM tab2 AS cor0 WHERE NOT ( NULL ) NOT BETWEEN NULL AND NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT - - 63 col2 FROM tab1 AS cor0
----
63
63
63

onlyif mysql # aggregate syntax: 
query I rowsort label-199
SELECT DISTINCT - MIN( - 98 ) AS col2 FROM tab0 AS cor0
----
98

skipif mysql # not compatible
query I rowsort label-199
SELECT DISTINCT - MIN ( - 98 ) AS col2 FROM tab0 AS cor0
----
98

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT - + 66 col0 FROM tab2 AS cor0
----
-66

query III rowsort
SELECT * FROM tab0 WHERE NOT + 54 BETWEEN + 77 AND + - col1
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

query II rowsort
SELECT DISTINCT col0 AS col1, - 43 * - - col2 FROM tab1
----
51
-4128
85
-2537
91
-2924

onlyif mysql # aggregate syntax: 
query I rowsort label-203
SELECT ALL + MAX( DISTINCT - col1 ) FROM tab0
----
-1

skipif mysql # not compatible
query I rowsort label-203
SELECT ALL + MAX ( DISTINCT - col1 ) FROM tab0
----
-1

onlyif mysql # DIV for integer division: 
query I rowsort label-204
SELECT + 5 DIV 19 AS col1 FROM tab2
----
0
0
0

skipif mysql # not compatible
query I rowsort label-204
SELECT + 5 / 19 AS col1 FROM tab2
----
0
0
0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-205
SELECT 82 * + col0 * + CAST( + col1 AS SIGNED ) AS col1 FROM tab0
----
149814
7954
99630

skipif mysql # not compatible
query I rowsort label-205
SELECT 82 * + col0 * + CAST ( + col1 AS INTEGER ) AS col1 FROM tab0
----
149814
7954
99630

query I rowsort
SELECT DISTINCT - - 45 AS col2 FROM tab0 AS cor0
----
45

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query II rowsort label-207
SELECT 56 col1, - MIN( + - CAST( NULL AS SIGNED ) ) AS col2 FROM tab1
----
56
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-207
SELECT 56 col1, - MIN ( + - CAST ( NULL AS INTEGER ) ) AS col2 FROM tab1
----
56
NULL

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-208
SELECT col0 * - 4 * + + CAST( NULL AS SIGNED ) AS col1 FROM tab2
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-208
SELECT col0 * - 4 * + + CAST ( NULL AS INTEGER ) AS col1 FROM tab2
----
NULL
NULL
NULL

onlyif mysql # DIV for integer division: 
query I rowsort label-209
SELECT - 45 DIV + 58 AS col2 FROM tab1
----
0
0
0

skipif mysql # not compatible
query I rowsort label-209
SELECT - 45 / + 58 AS col2 FROM tab1
----
0
0
0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-210
SELECT DISTINCT + ( + - CAST( NULL AS SIGNED ) ) AS col2 FROM tab1
----
NULL

skipif mysql # not compatible
query I rowsort label-210
SELECT DISTINCT + ( + - CAST ( NULL AS INTEGER ) ) AS col2 FROM tab1
----
NULL

query III rowsort
SELECT ALL * FROM tab2 AS cor0 WHERE NOT 18 BETWEEN col1 AND NULL
----
9 values hashing to 75c998aa53ac83218cbf2feb962d0a49

query I rowsort
SELECT - col2 + + + col1 AS col1 FROM tab1 AS cor0
----
-21
-54
-82

query I rowsort
SELECT ( - + 55 ) + + col0 FROM tab2 AS cor0
----
-9
20
9

onlyif mysql # aggregate syntax: 
query I rowsort label-214
SELECT - + 45 * COUNT( * ) + SUM( col1 ) FROM tab0 AS cor0
----
-32

skipif mysql # not compatible
query I rowsort label-214
SELECT - + 45 * COUNT ( * ) + SUM ( col1 ) FROM tab0 AS cor0
----
-32

onlyif mysql # DIV for integer division: 
query I rowsort label-215
SELECT ALL + + col1 DIV col0 + + 1 AS col0 FROM tab1 cor0
----
1
1
1

skipif mysql # not compatible
query I rowsort label-215
SELECT ALL + + col1 / col0 + + 1 AS col0 FROM tab1 cor0
----
1
1
1

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-216
SELECT DISTINCT * FROM tab1 AS cor0 WHERE NOT 9 + - - 33 * + + CAST( NULL AS SIGNED ) * + col0 * - col0 / col1 NOT BETWEEN + col2 AND col2
----

skipif mysql # not compatible
query III rowsort label-216
SELECT DISTINCT * FROM tab1 AS cor0 WHERE NOT 9 + - - 33 * + + CAST ( NULL AS INTEGER ) * + col0 * - col0 / col1 NOT BETWEEN + col2 AND col2
----

onlyif mysql # aggregate syntax: 
query I rowsort label-217
SELECT DISTINCT + ( COUNT( DISTINCT + + col0 ) ) + - SUM( + - col0 ) AS col0 FROM tab1
----
230

skipif mysql # not compatible
query I rowsort label-217
SELECT DISTINCT + ( COUNT ( DISTINCT + + col0 ) ) + - SUM ( + - col0 ) AS col0 FROM tab1
----
230

query I rowsort
SELECT DISTINCT col0 + + col2 + + col2 FROM tab2
----
144
191
92

query I rowsort
SELECT DISTINCT + 89 - - + ( - + 59 ) FROM tab1 AS cor0
----
30

onlyif mysql # aggregate syntax: 
query I rowsort label-220
SELECT SUM( + 92 ) FROM tab0 AS cor0
----
276

skipif mysql # not compatible
query I rowsort label-220
SELECT SUM ( + 92 ) FROM tab0 AS cor0
----
276

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-221
SELECT ALL + CAST( + + col2 AS SIGNED ) - - + col0 FROM tab2 AS cor0
----
104
133
69

skipif mysql # not compatible
query I rowsort label-221
SELECT ALL + CAST ( + + col2 AS INTEGER ) - - + col0 FROM tab2 AS cor0
----
104
133
69

query I rowsort
SELECT ALL + ( - + col0 ) FROM tab1 cor0
----
-51
-85
-91

query III rowsort
SELECT DISTINCT * FROM tab2 AS cor0 WHERE NOT col0 / + col1 + + col0 IS NULL
----
9 values hashing to 75c998aa53ac83218cbf2feb962d0a49

onlyif mysql # aggregate syntax: 
query I rowsort label-224
SELECT DISTINCT SUM( + + ( + col1 ) ) AS col1 FROM tab0 cor0
----
103

skipif mysql # not compatible
query I rowsort label-224
SELECT DISTINCT SUM ( + + ( + col1 ) ) AS col1 FROM tab0 cor0
----
103

onlyif mysql # aggregate syntax: 
query II rowsort label-225
SELECT ALL - COUNT( * ) AS col1, COUNT( + + col2 ) FROM tab1 AS cor0
----
-3
3

skipif mysql # not compatible
query II rowsort label-225
SELECT ALL - COUNT ( * ) AS col1, COUNT ( + + col2 ) FROM tab1 AS cor0
----
-3
3

query I rowsort
SELECT DISTINCT - col2 FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
-23
-40
-58

onlyif mysql # aggregate syntax: 
query I rowsort label-227
SELECT ALL SUM( ALL + 38 ) FROM tab2 cor0
----
114

skipif mysql # not compatible
query I rowsort label-227
SELECT ALL SUM ( ALL + 38 ) FROM tab2 cor0
----
114

query III rowsort
SELECT ALL * FROM tab1 AS cor0 WHERE NOT col0 * col2 * - col2 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-229
SELECT ALL - + COUNT( + - 65 ) AS col0 FROM tab1 AS cor0
----
-3

skipif mysql # not compatible
query I rowsort label-229
SELECT ALL - + COUNT ( + - 65 ) AS col0 FROM tab1 AS cor0
----
-3

query I rowsort
SELECT ( + col1 ) * + 37 FROM tab1
----
1739
185
518

query I rowsort
SELECT - col1 * 77 AS col0 FROM tab2
----
-3927
-5159
-5929

query I rowsort
SELECT + + col0 FROM tab1 WHERE NOT col2 * - col2 IS NOT NULL
----

query I rowsort
SELECT ALL - + col2 AS col0 FROM tab0 AS cor0 WHERE + 2 IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-234
SELECT - - COUNT( ALL + col2 ) + + 99 FROM tab2 AS cor0
----
102

skipif mysql # not compatible
query I rowsort label-234
SELECT - - COUNT ( ALL + col2 ) + + 99 FROM tab2 AS cor0
----
102

query I rowsort
SELECT ALL + col0 + + 77 AS col1 FROM tab2 AS cor0
----
123
141
152

query I rowsort
SELECT DISTINCT 58 AS col2 FROM tab1 AS cor0 WHERE ( NULL ) <> - 46
----

query I rowsort
SELECT - col2 AS col0 FROM tab1 AS cor0 WHERE + col0 IS NOT NULL
----
-59
-68
-96

query I rowsort
SELECT 31 * - + ( + 99 ) AS col2 FROM tab2 cor0
----
-3069
-3069
-3069

query I rowsort
SELECT - col2 * + + 42 AS col1 FROM tab1 AS cor0
----
-2478
-2856
-4032

query III rowsort
SELECT DISTINCT * FROM tab0 AS cor0 WHERE NOT 13 IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-241
SELECT + CAST( NULL AS SIGNED ) * + 20 AS col1 FROM tab0 AS cor0 WHERE NULL IS NOT NULL
----

skipif mysql # not compatible
query I rowsort label-241
SELECT + CAST ( NULL AS INTEGER ) * + 20 AS col1 FROM tab0 AS cor0 WHERE NULL IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-242
SELECT ALL - - 38, CAST( col2 AS SIGNED ) AS col2 FROM tab2 AS cor0
----
38
23
38
40
38
58

skipif mysql # not compatible
query II rowsort label-242
SELECT ALL - - 38, CAST ( col2 AS INTEGER ) AS col2 FROM tab2 AS cor0
----
38
23
38
40
38
58

query III rowsort
SELECT * FROM tab0 AS cor0 WHERE NULL = - ( + col0 )
----

onlyif mysql # aggregate syntax: 
query I rowsort label-244
SELECT DISTINCT - COUNT( * ) + 66 FROM tab0 AS cor0
----
63

skipif mysql # not compatible
query I rowsort label-244
SELECT DISTINCT - COUNT ( * ) + 66 FROM tab0 AS cor0
----
63

onlyif mysql # aggregate syntax: 
query I rowsort label-245
SELECT DISTINCT - COUNT( - col0 ) + 34 AS col2 FROM tab2
----
31

skipif mysql # not compatible
query I rowsort label-245
SELECT DISTINCT - COUNT ( - col0 ) + 34 AS col2 FROM tab2
----
31

onlyif mysql # CAST syntax: SIGNED type: DIV for integer division: 
query I rowsort label-246
SELECT ALL 42 DIV col2 + + CAST( 42 AS SIGNED ) AS col2 FROM tab0
----
42
42
46

skipif mysql # not compatible
query I rowsort label-246
SELECT ALL 42 / col2 + + CAST ( 42 AS INTEGER ) AS col2 FROM tab0
----
42
42
46

query III rowsort
SELECT ALL * FROM tab2 WHERE NOT NULL IS NULL AND NULL IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-248
SELECT ALL SUM( - col1 ) FROM tab2 WHERE - + 8 + + col2 IS NOT NULL
----
-195

skipif mysql # not compatible
query I rowsort label-248
SELECT ALL SUM ( - col1 ) FROM tab2 WHERE - + 8 + + col2 IS NOT NULL
----
-195

query I rowsort
SELECT + 81 + + 86 FROM tab2 AS cor0
----
167
167
167

onlyif mysql # DIV for integer division: 
query II rowsort label-250
SELECT DISTINCT - col0, - col1 DIV col0 * + col1 AS col1 FROM tab1 AS cor0
----
-51
0
-85
0
-91
0

skipif mysql # not compatible
query II rowsort label-250
SELECT DISTINCT - col0, - col1 / col0 * + col1 AS col1 FROM tab1 AS cor0
----
-51
0
-85
0
-91
0

onlyif mysql # aggregate syntax: 
query I rowsort label-251
SELECT ALL + + 34 * - + 64 + + - COUNT( * ) AS col0 FROM tab2 AS cor0
----
-2179

skipif mysql # not compatible
query I rowsort label-251
SELECT ALL + + 34 * - + 64 + + - COUNT ( * ) AS col0 FROM tab2 AS cor0
----
-2179

onlyif mysql # aggregate syntax: 
query I rowsort label-252
SELECT + - MAX( + col1 ) * 12 FROM tab2 AS cor0
----
-924

skipif mysql # not compatible
query I rowsort label-252
SELECT + - MAX ( + col1 ) * 12 FROM tab2 AS cor0
----
-924

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-253
SELECT ALL SUM( ALL - CAST( - - ( + + col0 ) AS SIGNED ) ) AS col1 FROM tab0
----
-199

skipif mysql # not compatible
query I rowsort label-253
SELECT ALL SUM ( ALL - CAST ( - - ( + + col0 ) AS INTEGER ) ) AS col1 FROM tab0
----
-199

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-254
SELECT * FROM tab0 AS cor0 WHERE NOT 64 * + CAST( NULL AS SIGNED ) <= col2
----

skipif mysql # not compatible
query III rowsort label-254
SELECT * FROM tab0 AS cor0 WHERE NOT 64 * + CAST ( NULL AS INTEGER ) <= col2
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT - - 61 col0 FROM tab2 AS cor0
----
61
61
61

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-256
SELECT DISTINCT * FROM tab2 AS cor0 WHERE col0 * + CAST( NULL AS SIGNED ) <> 93
----

skipif mysql # not compatible
query III rowsort label-256
SELECT DISTINCT * FROM tab2 AS cor0 WHERE col0 * + CAST ( NULL AS INTEGER ) <> 93
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-257
SELECT - 58 * + col2 + CAST( NULL AS SIGNED ) col1 FROM tab0
----
NULL
NULL
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-257
SELECT - 58 * + col2 + CAST ( NULL AS INTEGER ) col1 FROM tab0
----
NULL
NULL
NULL

query I rowsort
SELECT DISTINCT - 40 * + - col1 FROM tab2 WHERE NOT NULL IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-259
SELECT ( ( + - 87 ) ) * + - MIN( - col2 ) FROM tab2
----
-5046

skipif mysql # not compatible
query I rowsort label-259
SELECT ( ( + - 87 ) ) * + - MIN ( - col2 ) FROM tab2
----
-5046

onlyif mysql # aggregate syntax: 
query I rowsort label-260
SELECT DISTINCT + - COUNT( ALL - col1 ) AS col2 FROM tab1 AS cor0
----
-3

skipif mysql # not compatible
query I rowsort label-260
SELECT DISTINCT + - COUNT ( ALL - col1 ) AS col2 FROM tab1 AS cor0
----
-3

query I rowsort
SELECT DISTINCT + ( col2 ) + - - col1 - col0 * - + col1 AS col1 FROM tab1 AS cor0 WHERE NOT NULL < col2
----

onlyif mysql # aggregate syntax: 
query I rowsort label-262
SELECT MIN( - col2 ) col1 FROM tab0 AS cor0
----
-99

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-262
SELECT MIN ( - col2 ) col1 FROM tab0 AS cor0
----
-99

query I rowsort
SELECT ALL - + ( - 11 ) FROM tab0 cor0
----
11
11
11

query I rowsort
SELECT + - col0 AS col1 FROM tab0 AS cor0 WHERE NULL NOT BETWEEN NULL AND col1
----

query I rowsort
SELECT ALL 25 * col1 AS col2 FROM tab2
----
1275
1675
1925

query I rowsort
SELECT ALL - 78 * 48 FROM tab2
----
-3744
-3744
-3744

onlyif mysql # aggregate syntax: 
query I rowsort label-267
SELECT DISTINCT 14 * - SUM( ALL ( + col1 ) ) col1 FROM tab1
----
-924

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-267
SELECT DISTINCT 14 * - SUM ( ALL ( + col1 ) ) col1 FROM tab1
----
-924

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT - 19 * col2 col0 FROM tab1
----
-1121
-1292
-1824

onlyif mysql # aggregate syntax: 
query I rowsort label-269
SELECT - MIN( col2 ) FROM tab1 WHERE NOT col2 IN ( + col1 )
----
-59

skipif mysql # not compatible
query I rowsort label-269
SELECT - MIN ( col2 ) FROM tab1 WHERE NOT col2 IN ( + col1 )
----
-59

query III rowsort
SELECT * FROM tab1 WHERE ( NULL ) BETWEEN NULL AND + col1 * - col2
----

query III rowsort
SELECT * FROM tab2 WHERE ( NULL ) NOT BETWEEN NULL AND - col2
----

onlyif mysql # aggregate syntax: 
query I rowsort label-272
SELECT DISTINCT COUNT( * ) * + 67 AS col2 FROM tab2
----
201

skipif mysql # not compatible
query I rowsort label-272
SELECT DISTINCT COUNT ( * ) * + 67 AS col2 FROM tab2
----
201

query III rowsort
SELECT DISTINCT * FROM tab1 WHERE ( + 39 ) >= NULL
----

query I rowsort
SELECT DISTINCT col1 AS col0 FROM tab2 WHERE + col0 * col1 IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-275
SELECT COUNT( * ) * + COUNT( ALL ( + col2 ) ) AS col1 FROM tab2
----
9

skipif mysql # not compatible
query I rowsort label-275
SELECT COUNT ( * ) * + COUNT ( ALL ( + col2 ) ) AS col1 FROM tab2
----
9

query III rowsort
SELECT DISTINCT * FROM tab0 WHERE ( col1 ) NOT BETWEEN + 44 AND + col1 + + 11
----
87
21
10
97
1
99

query I rowsort
SELECT DISTINCT + ( col2 ) * - col0 + col0 FROM tab2
----
-1012
-2496
-4275

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-278
SELECT ALL * FROM tab2 WHERE NOT ( NULL ) NOT BETWEEN + CAST( NULL AS SIGNED ) AND col0
----

skipif mysql # not compatible
query III rowsort label-278
SELECT ALL * FROM tab2 WHERE NOT ( NULL ) NOT BETWEEN + CAST ( NULL AS INTEGER ) AND col0
----

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-279
SELECT DISTINCT * FROM tab1 WHERE NOT ( NULL ) NOT IN ( + CAST( - 31 AS SIGNED ) * + 33 )
----

skipif mysql # not compatible
query III rowsort label-279
SELECT DISTINCT * FROM tab1 WHERE NOT ( NULL ) NOT IN ( + CAST ( - 31 AS INTEGER ) * + 33 )
----

query I rowsort
SELECT ( 83 ) AS col2 FROM tab0 WHERE NOT NULL <= ( - col1 )
----

query I rowsort
SELECT DISTINCT - col0 + 19 AS col0 FROM tab0 WHERE NOT - col1 - col1 * col2 <> - 44
----

query I rowsort
SELECT 37 * 73 FROM tab2 WHERE ( NULL ) < + ( col1 )
----

onlyif mysql # aggregate syntax: DIV for integer division: 
query I rowsort label-283
SELECT + ( + MIN( ALL + col0 ) ) + COUNT( * ) DIV - ( COUNT( * ) ) FROM tab0
----
14

skipif mysql # not compatible
query I rowsort label-283
SELECT + ( + MIN ( ALL + col0 ) ) + COUNT ( * ) / - ( COUNT ( * ) ) FROM tab0
----
14

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-284
SELECT + 6 / CAST( NULL AS SIGNED ) col2 FROM tab1
----
NULL
NULL
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-284
SELECT + 6 / CAST ( NULL AS INTEGER ) col2 FROM tab1
----
NULL
NULL
NULL

query III rowsort
SELECT * FROM tab0 WHERE 88 * 50 NOT IN ( - ( + col0 ) )
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-286
SELECT COUNT( * ) + COUNT( * ) AS col0 FROM tab0 AS cor0 WHERE NOT + 39 + CAST( col1 AS SIGNED ) IN ( col0 - col2 )
----
6

skipif mysql # not compatible
query I rowsort label-286
SELECT COUNT ( * ) + COUNT ( * ) AS col0 FROM tab0 AS cor0 WHERE NOT + 39 + CAST ( col1 AS INTEGER ) IN ( col0 - col2 )
----
6

query I rowsort
SELECT ALL col0 FROM tab0 AS cor0 WHERE NOT ( - col2 * + col0 ) IS NULL
----
15
87
97

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-288
SELECT + col1 * + CAST( CAST( NULL AS SIGNED ) / + ( - 38 / col2 ) AS SIGNED ) FROM tab2 AS cor0
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-288
SELECT + col1 * + CAST ( CAST ( NULL AS INTEGER ) / + ( - 38 / col2 ) AS INTEGER ) FROM tab2 AS cor0
----
NULL
NULL
NULL

query III rowsort
SELECT DISTINCT * FROM tab2 AS cor0 WHERE NOT + col2 + col1 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-290
SELECT ALL - 87 * + COUNT( * ) FROM tab1
----
-261

skipif mysql # not compatible
query I rowsort label-290
SELECT ALL - 87 * + COUNT ( * ) FROM tab1
----
-261

onlyif mysql # aggregate syntax: 
query I rowsort label-291
SELECT MIN( DISTINCT 39 ) FROM tab0 AS cor0 WHERE NOT NULL <> NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-291
SELECT MIN ( DISTINCT 39 ) FROM tab0 AS cor0 WHERE NOT NULL <> NULL
----
NULL

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL 87 col1 FROM tab0 AS cor0 WHERE + 44 * col0 IS NULL
----

query I rowsort
SELECT col2 * col2 + ( 32 + col0 ) FROM tab2 AS cor0 WHERE NOT ( NULL ) < NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-294
SELECT DISTINCT - + MIN( + col0 ) FROM tab1 AS cor0
----
-51

skipif mysql # not compatible
query I rowsort label-294
SELECT DISTINCT - + MIN ( + col0 ) FROM tab1 AS cor0
----
-51

query I rowsort
SELECT - col1 * - ( + col1 ) AS col0 FROM tab0 AS cor0
----
1
441
6561

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-296
SELECT ALL ( 44 ) / CAST( NULL AS DECIMAL ) AS col2 FROM tab1 AS cor0
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-296
SELECT ALL ( 44 ) / CAST ( NULL AS REAL ) AS col2 FROM tab1 AS cor0
----
NULL
NULL
NULL

query I rowsort
SELECT + + 58 * 19 FROM tab0 cor0
----
1102
1102
1102

query I rowsort
SELECT DISTINCT - col2 + - 85 AS col0 FROM tab0 AS cor0
----
-132
-184
-95

query I rowsort
SELECT ALL + ( - col2 ) + + col0 AS col2 FROM tab0
----
-2
-32
77

query III rowsort
SELECT * FROM tab2 WHERE NOT ( + 26 ) IN ( - col0 )
----
9 values hashing to 75c998aa53ac83218cbf2feb962d0a49

onlyif mysql # DIV for integer division: 
query I rowsort label-301
SELECT DISTINCT col0 DIV 32 FROM tab0
----
0
2
3

skipif mysql # not compatible
query I rowsort label-301
SELECT DISTINCT col0 / 32 FROM tab0
----
0
2
3

query I rowsort
SELECT + col2 * + - col2 AS col0 FROM tab1
----
-3481
-4624
-9216

onlyif mysql # aggregate syntax: 
query I rowsort label-303
SELECT + MIN( + 70 ) AS col1 FROM tab2
----
70

skipif mysql # not compatible
query I rowsort label-303
SELECT + MIN ( + 70 ) AS col1 FROM tab2
----
70

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - col0 * - + col1 col0 FROM tab0
----
1215
1827
97

query III rowsort
SELECT ALL * FROM tab2 WHERE NOT ( NULL ) <> - 49
----

onlyif mysql # aggregate syntax: 
query I rowsort label-306
SELECT DISTINCT + COUNT( ALL + 3 ) * - SUM( ALL ( - col0 ) * col0 ) FROM tab0
----
51609

skipif mysql # not compatible
query I rowsort label-306
SELECT DISTINCT + COUNT ( ALL + 3 ) * - SUM ( ALL ( - col0 ) * col0 ) FROM tab0
----
51609

query III rowsort
SELECT DISTINCT * FROM tab1 WHERE NOT - col2 * col2 IN ( + col2 )
----
9 values hashing to c6c0a4111b36d04dbc811a11e4d54cad

query I rowsort
SELECT + col0 FROM tab2 AS cor0 WHERE NOT 4 * - col0 + 55 IS NULL AND NOT + col2 IS NOT NULL
----

query I rowsort
SELECT DISTINCT col1 + + + col1 FROM tab2 AS cor0
----
102
134
154

query I rowsort
SELECT + col0 * - col0 + + col1 + 87 FROM tab2 cor0
----
-1978
-3932
-5471

query I rowsort
SELECT ALL - 98 AS col2 FROM tab0 AS cor0 CROSS JOIN tab2 cor1
----
9 values hashing to f17b7008a7deae1eb5a2e707ec237638

query I rowsort
SELECT DISTINCT ( 30 ) + 61 FROM tab0 AS cor0 CROSS JOIN tab2 AS cor1
----
91

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - col1 col1 FROM tab2 WHERE - col1 * - col1 IS NOT NULL
----
-51
-67
-77

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-314
SELECT ALL CAST( NULL AS SIGNED ) FROM tab2 cor0 CROSS JOIN tab2 cor1
----
9 values hashing to cd7a7901e47c15155404aff0d216fe0b

skipif mysql # not compatible
query I rowsort label-314
SELECT ALL CAST ( NULL AS INTEGER ) FROM tab2 cor0 CROSS JOIN tab2 cor1
----
9 values hashing to cd7a7901e47c15155404aff0d216fe0b

query I rowsort
SELECT col2 * + 13 FROM tab0
----
1287
130
611

onlyif mysql # DIV for integer division: 
query I rowsort label-316
SELECT DISTINCT - col2 DIV - col1 + + 52 AS col1 FROM tab2 AS cor0
----
52

skipif mysql # not compatible
query I rowsort label-316
SELECT DISTINCT - col2 / - col1 + + 52 AS col1 FROM tab2 AS cor0
----
52

query III rowsort
SELECT * FROM tab0 AS cor0 WHERE - col1 + - - col1 / col1 NOT BETWEEN ( + col0 ) AND - 7
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-318
SELECT ALL CAST( NULL AS DECIMAL ) AS col1 FROM tab2 AS cor0 WHERE NULL NOT BETWEEN NULL AND - col0
----

skipif mysql # not compatible
query I rowsort label-318
SELECT ALL CAST ( NULL AS REAL ) AS col1 FROM tab2 AS cor0 WHERE NULL NOT BETWEEN NULL AND - col0
----

query I rowsort
SELECT DISTINCT 70 * - col0 - + - col1 FROM tab2 AS cor0
----
-3169
-4403
-5183

query I rowsort
SELECT + col0 - + - col1 * + - col2 AS col1 FROM tab0 AS cor0
----
-123
-2
-3792

onlyif mysql # aggregate syntax: 
query I rowsort label-321
SELECT ( 74 ) - + SUM( DISTINCT 89 ) FROM tab1 AS cor0
----
-15

skipif mysql # not compatible
query I rowsort label-321
SELECT ( 74 ) - + SUM ( DISTINCT 89 ) FROM tab1 AS cor0
----
-15

onlyif mysql # DIV for integer division: 
query I rowsort label-322
SELECT 94 DIV col0 AS col0 FROM tab0 AS cor0 WHERE col0 IS NOT NULL
----
0
1
6

skipif mysql # not compatible
query I rowsort label-322
SELECT 94 / col0 AS col0 FROM tab0 AS cor0 WHERE col0 IS NOT NULL
----
0
1
6

query I rowsort
SELECT col1 * + + col1 * - + col0 - col0 * - col0 AS col2 FROM tab2 AS cor0
----
-117530
-331050
-375360

query I rowsort
SELECT + col1 - ( - col1 ) * col2 FROM tab0 AS cor0
----
100
231
3888

query I rowsort
SELECT DISTINCT + + 86 * - + col1 FROM tab0 AS cor0
----
-1806
-6966
-86

query III rowsort
SELECT ALL * FROM tab0 WHERE ( - col0 ) NOT IN ( 85 - 8 )
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

query III rowsort
SELECT * FROM tab1 WHERE NOT - 49 - + - col0 >= - col1
----

onlyif mysql # DIV for integer division: 
query I rowsort label-328
SELECT - 19 DIV + col1 col1 FROM tab1
----
-1
-3
0

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-328
SELECT - 19 / + col1 col1 FROM tab1
----
-1
-3
0

query III rowsort
SELECT * FROM tab1 WHERE NOT NULL = ( - col1 * - - col2 )
----

query I rowsort
SELECT - + ( col0 ) AS col2 FROM tab0 AS cor0 WHERE NOT - 83 IS NOT NULL
----

query I rowsort
SELECT DISTINCT col0 AS col2 FROM tab1 AS cor0 WHERE col2 + col2 IN ( 32 * + col0 )
----

onlyif mysql # aggregate syntax: 
query I rowsort label-332
SELECT COUNT( DISTINCT - - col2 ) AS col1 FROM tab0
----
3

skipif mysql # not compatible
query I rowsort label-332
SELECT COUNT ( DISTINCT - - col2 ) AS col1 FROM tab0
----
3

onlyif mysql # DIV for integer division: 
query I rowsort label-333
SELECT - col1 DIV 97 AS col1 FROM tab2
----
0
0
0

skipif mysql # not compatible
query I rowsort label-333
SELECT - col1 / 97 AS col1 FROM tab2
----
0
0
0

onlyif mysql # aggregate syntax: 
query I rowsort label-334
SELECT ( + 77 ) * SUM( ALL + + ( - 59 ) ) FROM tab1 AS cor0
----
-13629

skipif mysql # not compatible
query I rowsort label-334
SELECT ( + 77 ) * SUM ( ALL + + ( - 59 ) ) FROM tab1 AS cor0
----
-13629

query III rowsort
SELECT ALL * FROM tab1 cor0 WHERE NULL NOT BETWEEN col1 AND + col0
----

onlyif mysql # aggregate syntax: 
query I rowsort label-336
SELECT DISTINCT COUNT( + 10 ) FROM tab2 AS cor0
----
3

skipif mysql # not compatible
query I rowsort label-336
SELECT DISTINCT COUNT ( + 10 ) FROM tab2 AS cor0
----
3

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-337
SELECT ALL * FROM tab2 AS cor0 WHERE NOT CAST( NULL AS SIGNED ) <= + col1
----

skipif mysql # not compatible
query III rowsort label-337
SELECT ALL * FROM tab2 AS cor0 WHERE NOT CAST ( NULL AS INTEGER ) <= + col1
----

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-338
SELECT ALL * FROM tab1 cor0 WHERE - CAST( NULL AS SIGNED ) = NULL
----

skipif mysql # not compatible
query III rowsort label-338
SELECT ALL * FROM tab1 cor0 WHERE - CAST ( NULL AS INTEGER ) = NULL
----

query III rowsort
SELECT ALL * FROM tab0 AS cor0 WHERE - 25 IS NOT NULL
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

query I rowsort
SELECT ALL - col2 * - col1 * + col1 * + col2 FROM tab1 AS cor0
----
10214416
1806336
87025

query III rowsort
SELECT * FROM tab0 AS cor0 WHERE NOT + 1 IS NOT NULL
----

query I rowsort
SELECT - col1 + 17 FROM tab0
----
-4
-64
16

query III rowsort
SELECT DISTINCT * FROM tab1 WHERE - col0 * + - col2 >= col2
----
9 values hashing to c6c0a4111b36d04dbc811a11e4d54cad

query I rowsort
SELECT col2 AS col0 FROM tab2 WHERE - + col1 + - - col1 * - col0 + - col0 < + col1
----
23
40
58

query I rowsort
SELECT ALL + 22 + 62 FROM tab0 WHERE NULL IS NULL
----
84
84
84

query I rowsort
SELECT col1 + 22 AS col1 FROM tab2
----
73
89
99

query I rowsort
SELECT DISTINCT + col1 + + - ( - - ( - + col0 ) ) AS col1 FROM tab2
----
141
142
97

query I rowsort
SELECT + col1 + 65 FROM tab1
----
112
70
79

onlyif mysql # aggregate syntax: 
query I rowsort label-349
SELECT - 24 * + COUNT( * ) AS col2 FROM tab2
----
-72

skipif mysql # not compatible
query I rowsort label-349
SELECT - 24 * + COUNT ( * ) AS col2 FROM tab2
----
-72

query III rowsort
SELECT * FROM tab0 WHERE ( - col2 IS NULL )
----

query I rowsort
SELECT DISTINCT - col0 + - + col0 + - col0 AS col0 FROM tab1 AS cor0 WHERE NOT col2 IS NOT NULL
----

query III rowsort
SELECT * FROM tab1 AS cor0 WHERE col2 * + 24 IS NULL
----

query IIIIII rowsort
SELECT ALL * FROM tab0 AS cor0 CROSS JOIN tab2 cor1 WHERE NULL IS NULL
----
54 values hashing to eaa394f1627c8d5e53406d9ca3b09469

onlyif mysql # DIV for integer division: 
query I rowsort label-354
SELECT DISTINCT col1 DIV - - col0 - - 10 AS col1 FROM tab2
----
10
11

skipif mysql # not compatible
query I rowsort label-354
SELECT DISTINCT col1 / - - col0 - - 10 AS col1 FROM tab2
----
10
11

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-355
SELECT DISTINCT + CAST( NULL AS SIGNED ) + 24, + col2 + - col2 * + 26 AS col0 FROM tab0
----
NULL
-1175
NULL
-2475
NULL
-250

skipif mysql # not compatible
query II rowsort label-355
SELECT DISTINCT + CAST ( NULL AS INTEGER ) + 24, + col2 + - col2 * + 26 AS col0 FROM tab0
----
NULL
-1175
NULL
-2475
NULL
-250

query I rowsort
SELECT - + col2 + + col0 + + col2 AS col0 FROM tab1 AS cor0
----
51
85
91

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-357
SELECT DISTINCT CAST( - COUNT( * ) AS SIGNED ) - + 65 AS col0 FROM tab1 AS cor0
----
-68

skipif mysql # not compatible
query I rowsort label-357
SELECT DISTINCT CAST ( - COUNT ( * ) AS INTEGER ) - + 65 AS col0 FROM tab1 AS cor0
----
-68

query III rowsort
SELECT ALL * FROM tab1 AS cor0 WHERE ( NULL >= - + col0 )
----

query I rowsort
SELECT DISTINCT + + col2 * - + 5 FROM tab1 AS cor0 WHERE 14 + + 16 IS NOT NULL
----
-295
-340
-480

query I rowsort
SELECT ALL - col1 - 10 + + col2 * - col2 - + 35 AS col2 FROM tab0 AS cor0
----
-166
-2335
-9847

onlyif mysql # aggregate syntax: 
query I rowsort label-361
SELECT DISTINCT - COUNT( * ) * - COUNT( * ) - - MAX( DISTINCT + + col1 ) col0 FROM tab2 AS cor0
----
86

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-361
SELECT DISTINCT - COUNT ( * ) * - COUNT ( * ) - - MAX ( DISTINCT + + col1 ) col0 FROM tab2 AS cor0
----
86

query II rowsort
SELECT - col1 AS col2, col1 FROM tab0
----
-1
1
-21
21
-81
81

query III rowsort
SELECT * FROM tab1 WHERE NOT ( - 10 ) BETWEEN ( NULL ) AND NULL
----

query I rowsort
SELECT col1 * + - col2 AS col2 FROM tab1
----
-1344
-295
-3196

query III rowsort
SELECT * FROM tab0 WHERE NOT col1 NOT IN ( + col0, col2 )
----

query I rowsort
SELECT DISTINCT 83 AS col0 FROM tab1 WHERE NOT NULL NOT IN ( + + col2 * + 51 * col2 + - + col1 - + col2 + - 19 + - col0 / - col0 )
----

query I rowsort
SELECT DISTINCT 58 * col0 * - col2 AS col2 FROM tab0 WHERE - 21 IS NOT NULL
----
-40890
-50460
-556974

onlyif mysql # aggregate syntax: 
query I rowsort label-368
SELECT SUM( - 78 ) AS col0 FROM tab2
----
-234

skipif mysql # not compatible
query I rowsort label-368
SELECT SUM ( - 78 ) AS col0 FROM tab2
----
-234

onlyif mysql # aggregate syntax: 
query I rowsort label-369
SELECT MAX( ALL + 74 ) AS col2 FROM tab2 AS cor0 WHERE NOT ( + col1 ) IS NOT NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-369
SELECT MAX ( ALL + 74 ) AS col2 FROM tab2 AS cor0 WHERE NOT ( + col1 ) IS NOT NULL
----
NULL

query II rowsort
SELECT DISTINCT - - col1, col0 AS col1 FROM tab1 AS cor0 WHERE col0 IS NULL
----

query II rowsort
SELECT DISTINCT + - 79, col0 FROM tab2 AS cor0
----
-79
46
-79
64
-79
75

onlyif mysql # aggregate syntax: 
query I rowsort label-372
SELECT ALL - COUNT( ALL - - col0 ) FROM tab1
----
-3

skipif mysql # not compatible
query I rowsort label-372
SELECT ALL - COUNT ( ALL - - col0 ) FROM tab1
----
-3

query III rowsort
SELECT ALL * FROM tab2 AS cor0 WHERE - col1 * + col0 * + - 36 IS NOT NULL
----
9 values hashing to 75c998aa53ac83218cbf2feb962d0a49

query I rowsort
SELECT - - 74 FROM tab2 cor0
----
74
74
74

query III rowsort
SELECT * FROM tab2 AS cor0 WHERE 58 / - ( - + col1 ) IS NULL
----

query III rowsort
SELECT DISTINCT * FROM tab2 WHERE + - 57 <= - col0 + + col1 + 83
----
9 values hashing to 75c998aa53ac83218cbf2feb962d0a49

query I rowsort
SELECT ALL col1 + 59 AS col1 FROM tab2
----
110
126
136

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-378
SELECT DISTINCT - CAST( NULL AS DECIMAL ) + + 83 + col0 * - - col1 FROM tab1
----
NULL

skipif mysql # not compatible
query I rowsort label-378
SELECT DISTINCT - CAST ( NULL AS REAL ) + + 83 + col0 * - - col1 FROM tab1
----
NULL

query I rowsort
SELECT ALL + col2 * 94 FROM tab0
----
4418
9306
940

onlyif mysql # aggregate syntax: 
query I rowsort label-380
SELECT DISTINCT 49 + - COUNT( * ) col0 FROM tab1
----
46

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-380
SELECT DISTINCT 49 + - COUNT ( * ) col0 FROM tab1
----
46

query I rowsort
SELECT DISTINCT col0 * - 4 AS col1 FROM tab0
----
-348
-388
-60

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-382
SELECT CAST( NULL AS SIGNED ) + + col0 col0 FROM tab1
----
NULL
NULL
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-382
SELECT CAST ( NULL AS INTEGER ) + + col0 col0 FROM tab1
----
NULL
NULL
NULL

query I rowsort
SELECT ALL col2 * + 25 FROM tab1 cor0
----
1475
1700
2400

query I rowsort
SELECT + col0 * col1 + - col2 AS col2 FROM tab1 AS cor0
----
366
4209
618

onlyif mysql # aggregate syntax: 
query I rowsort label-385
SELECT + COUNT( DISTINCT + - col2 ) + - + 33 col1 FROM tab0 AS cor0
----
-30

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-385
SELECT + COUNT ( DISTINCT + - col2 ) + - + 33 col1 FROM tab0 AS cor0
----
-30

onlyif mysql # aggregate syntax: 
query I rowsort label-386
SELECT MIN( col0 ) AS col0 FROM tab0 cor0
----
15

skipif mysql # not compatible
query I rowsort label-386
SELECT MIN ( col0 ) AS col0 FROM tab0 cor0
----
15

query I rowsort
SELECT DISTINCT + col2 + + 3 AS col1 FROM tab2
----
26
43
61

onlyif mysql # aggregate syntax: 
query I rowsort label-388
SELECT ALL COUNT( * ) + - 30 * ( + 98 ) FROM tab0
----
-2937

skipif mysql # not compatible
query I rowsort label-388
SELECT ALL COUNT ( * ) + - 30 * ( + 98 ) FROM tab0
----
-2937

query I rowsort
SELECT + col0 + - + col0 * - - 66 * + col2 AS col2 FROM tab0 WHERE ( - 98 ) IS NOT NULL
----
-46515
-57333
-633701

onlyif mysql # CAST syntax: SIGNED type: DECIMAL type: 
query I rowsort label-390
SELECT DISTINCT + col2 * + - col2 / - col1 + col1 - - + CAST( NULL AS SIGNED ) * col0 + - + CAST( 27 AS DECIMAL ) AS col1 FROM tab0 AS cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-390
SELECT DISTINCT + col2 * + - col2 / - col1 + col1 - - + CAST ( NULL AS INTEGER ) * col0 + - + CAST ( 27 AS REAL ) AS col1 FROM tab0 AS cor0
----
NULL

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-391
SELECT ALL - CAST( NULL AS SIGNED ), 96 col2 FROM tab1 AS cor0
----
NULL
96
NULL
96
NULL
96

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-391
SELECT ALL - CAST ( NULL AS INTEGER ), 96 col2 FROM tab1 AS cor0
----
NULL
96
NULL
96
NULL
96

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-392
SELECT ALL CAST( + + col0 AS SIGNED ) AS col2 FROM tab1 AS cor0
----
51
85
91

skipif mysql # not compatible
query I rowsort label-392
SELECT ALL CAST ( + + col0 AS INTEGER ) AS col2 FROM tab1 AS cor0
----
51
85
91

query II rowsort
SELECT ALL 78 AS col0, 64 AS col0 FROM tab0 AS cor0
----
78
64
78
64
78
64

onlyif mysql # aggregate syntax: 
query I rowsort label-394
SELECT - - COUNT( * ) * + + 96 AS col1 FROM tab1 AS cor0
----
288

skipif mysql # not compatible
query I rowsort label-394
SELECT - - COUNT ( * ) * + + 96 AS col1 FROM tab1 AS cor0
----
288

query I rowsort
SELECT ALL col2 AS col1 FROM tab0 AS cor0 WHERE 33 IS NOT NULL
----
10
47
99

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-396
SELECT ALL * FROM tab2 AS cor0 WHERE NOT CAST( NULL AS SIGNED ) * col0 * - col2 IS NULL
----

skipif mysql # not compatible
query III rowsort label-396
SELECT ALL * FROM tab2 AS cor0 WHERE NOT CAST ( NULL AS INTEGER ) * col0 * - col2 IS NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - 45 * + col2 * - 54 + + 74 col0 FROM tab2 AS cor0
----
141014
55964
97274

query I rowsort
SELECT DISTINCT + 25 * + 95 FROM tab1 AS cor0
----
2375

query I rowsort
SELECT DISTINCT col2 + + 64 FROM tab1 WHERE NOT col1 + + + col1 IS NULL
----
123
132
160

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-400
SELECT col2 / + - col1 col2 FROM tab2 WHERE NOT NULL NOT BETWEEN + - CAST( NULL AS SIGNED ) AND + col1
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-400
SELECT col2 / + - col1 col2 FROM tab2 WHERE NOT NULL NOT BETWEEN + - CAST ( NULL AS INTEGER ) AND + col1
----

query I rowsort
SELECT col0 * + 76 FROM tab0 WHERE NOT ( NULL ) IS NOT NULL
----
1140
6612
7372

onlyif mysql # DIV for integer division: 
query I rowsort label-402
SELECT 93 DIV + + 5 AS col0 FROM tab1
----
18
18
18

skipif mysql # not compatible
query I rowsort label-402
SELECT 93 / + + 5 AS col0 FROM tab1
----
18
18
18

query I rowsort
SELECT DISTINCT + ( + - 92 ) AS col1 FROM tab0 WHERE + col2 + + col0 IS NOT NULL
----
-92

query I rowsort
SELECT DISTINCT - 13 * col0 FROM tab2 AS cor0 WHERE ( NULL ) IS NOT NULL
----

query III rowsort
SELECT * FROM tab2 WHERE NOT NULL NOT BETWEEN - 5 AND - - col2
----

query III rowsort
SELECT DISTINCT * FROM tab2 WHERE 67 + col1 + - col0 >= NULL
----

query I rowsort
SELECT ALL col0 FROM tab1 WHERE + 58 <> + col1 * + col2
----
51
85
91

onlyif mysql # aggregate syntax: 
query II rowsort label-408
SELECT - COUNT( * ) AS col0, + COUNT( * ) FROM tab2
----
-3
3

skipif mysql # not compatible
query II rowsort label-408
SELECT - COUNT ( * ) AS col0, + COUNT ( * ) FROM tab2
----
-3
3

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: DIV for integer division: 
query I rowsort label-409
SELECT - CAST( - + CAST( AVG ( + - 17 ) AS SIGNED ) AS SIGNED ) DIV ( - COUNT( * ) ) FROM tab1 cor0
----
5

skipif mysql # not compatible
query I rowsort label-409
SELECT - CAST ( - + CAST ( AVG ( + - 17 ) AS INTEGER ) AS INTEGER ) / ( - COUNT ( * ) ) FROM tab1 cor0
----
5

query I rowsort
SELECT + col0 FROM tab0 AS cor0 WHERE + col0 / + 17 + + - col0 IS NOT NULL
----
15
87
97

query I rowsort
SELECT ALL col1 FROM tab1 AS cor0 WHERE NOT ( + col1 ) <> NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-412
SELECT DISTINCT - SUM( DISTINCT - col0 ) FROM tab1 AS cor0
----
227

skipif mysql # not compatible
query I rowsort label-412
SELECT DISTINCT - SUM ( DISTINCT - col0 ) FROM tab1 AS cor0
----
227

query III rowsort
SELECT * FROM tab0 AS cor0 WHERE ( NULL ) >= + col2
----

query I rowsort
SELECT ALL col2 FROM tab2 AS cor0 WHERE - 99 IS NULL
----

onlyif mysql # DIV for integer division: 
query I rowsort label-415
SELECT + 89 * - col2 + - 14 DIV + - ( + col1 ) AS col0 FROM tab0 AS cor0
----
-4183
-8797
-890

skipif mysql # not compatible
query I rowsort label-415
SELECT + 89 * - col2 + - 14 / + - ( + col1 ) AS col0 FROM tab0 AS cor0
----
-4183
-8797
-890

query I rowsort
SELECT - col1 AS col2 FROM tab1 WHERE NULL BETWEEN NULL AND NULL
----

query I rowsort
SELECT DISTINCT + ( col2 ) + - 78 FROM tab0
----
-31
-68
21

query I rowsort
SELECT col0 + - + 95 FROM tab0
----
-8
-80
2

query I rowsort
SELECT ALL - + col2 FROM tab0 WHERE ( + 98 ) IS NOT NULL
----
-10
-47
-99

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-420
SELECT DISTINCT col0 + - 21 - + CAST( NULL AS DECIMAL ) * + + 30 AS col0 FROM tab1
----
NULL

skipif mysql # not compatible
query I rowsort label-420
SELECT DISTINCT col0 + - 21 - + CAST ( NULL AS REAL ) * + + 30 AS col0 FROM tab1
----
NULL

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-421
SELECT ALL CAST( NULL AS DECIMAL ) - + + col2 + - 4 FROM tab0
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-421
SELECT ALL CAST ( NULL AS REAL ) - + + col2 + - 4 FROM tab0
----
NULL
NULL
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-422
SELECT MAX( ALL + col0 ) AS col0 FROM tab0
----
97

skipif mysql # not compatible
query I rowsort label-422
SELECT MAX ( ALL + col0 ) AS col0 FROM tab0
----
97

onlyif mysql # aggregate syntax: 
query I rowsort label-423
SELECT - ( COUNT( - - 78 ) ) + COUNT( * ) + - + 59 col2 FROM tab2 AS cor0 WHERE col1 <= 89
----
-59

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-423
SELECT - ( COUNT ( - - 78 ) ) + COUNT ( * ) + - + 59 col2 FROM tab2 AS cor0 WHERE col1 <= 89
----
-59

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query II rowsort label-424
SELECT ALL + CAST( - 29 AS SIGNED ) + + - MIN( DISTINCT + 72 ) + + 70 AS col2, - 99 FROM tab0
----
-31
-99

skipif mysql # not compatible
query II rowsort label-424
SELECT ALL + CAST ( - 29 AS INTEGER ) + + - MIN ( DISTINCT + 72 ) + + 70 AS col2, - 99 FROM tab0
----
-31
-99

query I rowsort
SELECT + 39 * - - col1 + - - col2 FROM tab2
----
2012
2671
3043

query I rowsort
SELECT DISTINCT + 76 AS col0 FROM tab2 WHERE NULL <> NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-427
SELECT * FROM tab2 AS cor0 WHERE NOT + CAST( - 77 AS SIGNED ) * + col1 < - 39
----

skipif mysql # not compatible
query III rowsort label-427
SELECT * FROM tab2 AS cor0 WHERE NOT + CAST ( - 77 AS INTEGER ) * + col1 < - 39
----

onlyif mysql # aggregate syntax: 
query I rowsort label-428
SELECT DISTINCT + COUNT( * ) FROM tab0 AS cor0 WHERE NOT 7 * + 81 IS NULL
----
3

skipif mysql # not compatible
query I rowsort label-428
SELECT DISTINCT + COUNT ( * ) FROM tab0 AS cor0 WHERE NOT 7 * + 81 IS NULL
----
3

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-429
SELECT DISTINCT 93 * - + ( - col2 ) * + CAST( NULL AS SIGNED ) / - col1 AS col2 FROM tab0 AS cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-429
SELECT DISTINCT 93 * - + ( - col2 ) * + CAST ( NULL AS INTEGER ) / - col1 AS col2 FROM tab0 AS cor0
----
NULL

query II rowsort
SELECT - col2 AS col0, - col2 + - col2 * + + col1 FROM tab0 cor0
----
-10
-220
-47
-3854
-99
-198

onlyif mysql # aggregate syntax: 
query I rowsort label-431
SELECT - 83 * - 68 * - + COUNT( * ) col1 FROM tab0
----
-16932

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-431
SELECT - 83 * - 68 * - + COUNT ( * ) col1 FROM tab0
----
-16932

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT ( 89 ) col0 FROM tab1
----
89

onlyif mysql # aggregate syntax: 
query I rowsort label-433
SELECT ALL - COUNT( DISTINCT 53 ) col2 FROM tab1
----
-1

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-433
SELECT ALL - COUNT ( DISTINCT 53 ) col2 FROM tab1
----
-1

query II rowsort
SELECT - col0 AS col1, 54 AS col0 FROM tab0 AS cor0
----
-15
54
-87
54
-97
54

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT - 99 col0 FROM tab2 AS cor0
----
-99
-99
-99

onlyif mysql # aggregate syntax: 
query I rowsort label-436
SELECT - COUNT( * ) + + COUNT( * ) FROM tab0 AS cor0 WHERE NOT col0 IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-436
SELECT - COUNT ( * ) + + COUNT ( * ) FROM tab0 AS cor0 WHERE NOT col0 IS NOT NULL
----
0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-437
SELECT ALL + CAST( 55 AS SIGNED ) AS col2 FROM tab1 AS cor0
----
55
55
55

skipif mysql # not compatible
query I rowsort label-437
SELECT ALL + CAST ( 55 AS INTEGER ) AS col2 FROM tab1 AS cor0
----
55
55
55

query I rowsort
SELECT - col2 FROM tab2 AS cor0 WHERE NULL NOT BETWEEN NULL AND 86
----

query I rowsort
SELECT DISTINCT ( + col2 ) + - col1 AS col0 FROM tab0 WHERE + - col1 <= ( NULL )
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-440
SELECT CAST( - 11 AS SIGNED ) * - 69 * + + ( col2 ) - + 88 * col0 * + + col2 * col1 + col1 FROM tab1
----
-2161814
-25541909
-5958994

skipif mysql # not compatible
query I rowsort label-440
SELECT CAST ( - 11 AS INTEGER ) * - 69 * + + ( col2 ) - + 88 * col0 * + + col2 * col1 + col1 FROM tab1
----
-2161814
-25541909
-5958994

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-441
SELECT ALL + 65 * - 8 + - 41 * + + col1 * CAST( NULL AS SIGNED ) FROM tab0
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-441
SELECT ALL + 65 * - 8 + - 41 * + + col1 * CAST ( NULL AS INTEGER ) FROM tab0
----
NULL
NULL
NULL

query I rowsort
SELECT DISTINCT 42 AS col2 FROM tab2 WHERE col2 + - col1 IS NULL
----

query II rowsort
SELECT DISTINCT col0 AS col0, + col2 + col1 AS col2 FROM tab1
----
51
110
85
64
91
115

query I rowsort
SELECT - + col1 AS col0 FROM tab2 WHERE ( col2 ) >= NULL
----

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-445
SELECT + COUNT( ALL - 59 ) * + CAST( NULL AS SIGNED ) * - 27 AS col0 FROM tab1 AS cor0 WHERE NULL > ( + col1 )
----
NULL

skipif mysql # not compatible
query I rowsort label-445
SELECT + COUNT ( ALL - 59 ) * + CAST ( NULL AS INTEGER ) * - 27 AS col0 FROM tab1 AS cor0 WHERE NULL > ( + col1 )
----
NULL

query I rowsort
SELECT ALL ( - col2 ) * - + ( - 86 ) AS col2 FROM tab2 AS cor0
----
-1978
-3440
-4988

query I rowsort
SELECT - + col1 * + - col0 FROM tab1 AS cor0
----
425
4277
714

onlyif mysql # aggregate syntax: 
query I rowsort label-448
SELECT ALL - 54 * - SUM( - 13 ) AS col1 FROM tab1 AS cor0
----
-2106

skipif mysql # not compatible
query I rowsort label-448
SELECT ALL - 54 * - SUM ( - 13 ) AS col1 FROM tab1 AS cor0
----
-2106

query I rowsort
SELECT 62 FROM tab1 cor0 WHERE NULL NOT BETWEEN NULL AND NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-450
SELECT ALL - 0 + + CAST( NULL AS DECIMAL ) + + - 5 + + AVG ( DISTINCT - col2 ) + - 64 AS col1 FROM tab2 AS cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-450
SELECT ALL - 0 + + CAST ( NULL AS REAL ) + + - 5 + + AVG ( DISTINCT - col2 ) + - 64 AS col1 FROM tab2 AS cor0
----
NULL

query I rowsort
SELECT DISTINCT - + 90 FROM tab2 AS cor0 CROSS JOIN tab0 AS cor1
----
-90

query I rowsort
SELECT col0 * 21 AS col0 FROM tab1
----
1071
1785
1911

query IIIIII rowsort
SELECT * FROM tab0 AS cor0 CROSS JOIN tab2 AS cor1 WHERE NOT - + 72 IS NULL AND NOT NULL IS NOT NULL
----
54 values hashing to eaa394f1627c8d5e53406d9ca3b09469

query I rowsort
SELECT DISTINCT - col1 * + + col2 * col2 FROM tab1 AS cor0
----
-129024
-17405
-217328

query I rowsort
SELECT ALL + - col0 * + ( - - col2 ) AS col0 FROM tab0 AS cor0
----
-705
-870
-9603

onlyif mysql # aggregate syntax: 
query II rowsort label-456
SELECT ALL - MAX( ALL - col1 ), + COUNT( * ) AS col0 FROM tab0 AS cor0
----
1
3

skipif mysql # not compatible
query II rowsort label-456
SELECT ALL - MAX ( ALL - col1 ), + COUNT ( * ) AS col0 FROM tab0 AS cor0
----
1
3

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-457
SELECT DISTINCT - COUNT( * ) AS col0 FROM tab1 WHERE + CAST( CAST( - - col1 AS SIGNED ) AS SIGNED ) - + 66 + - + 88 >= NULL
----
0

skipif mysql # not compatible
query I rowsort label-457
SELECT DISTINCT - COUNT ( * ) AS col0 FROM tab1 WHERE + CAST ( CAST ( - - col1 AS INTEGER ) AS INTEGER ) - + 66 + - + 88 >= NULL
----
0

onlyif mysql # DIV for integer division: 
query I rowsort label-458
SELECT DISTINCT 1 DIV col0 AS col2 FROM tab0
----
0

skipif mysql # not compatible
query I rowsort label-458
SELECT DISTINCT 1 / col0 AS col2 FROM tab0
----
0

query III rowsort
SELECT DISTINCT * FROM tab2 WHERE NOT + 65 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-460
SELECT DISTINCT SUM( DISTINCT - 40 ) col2 FROM tab2
----
-40

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-460
SELECT DISTINCT SUM ( DISTINCT - 40 ) col2 FROM tab2
----
-40

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT col2 * - col0 col0 FROM tab0
----
-705
-870
-9603

query I rowsort
SELECT col2 * col1 * 32 AS col2 FROM tab2
----
124352
37536
98560

onlyif mysql # DIV for integer division: 
query II rowsort label-463
SELECT ALL col2 AS col2, col2 DIV - col0 FROM tab0
----
10
0
47
-3
99
-1

skipif mysql # not compatible
query II rowsort label-463
SELECT ALL col2 AS col2, col2 / - col0 FROM tab0
----
10
0
47
-3
99
-1

query I rowsort
SELECT - col1 * + + 74 * + 97 FROM tab1 AS cor0
----
-100492
-337366
-35890

onlyif mysql # DIV for integer division: 
query II rowsort label-465
SELECT col0 AS col0, col1 * 66 DIV + - 99 FROM tab2 AS cor0
----
46
-34
64
-51
75
-44

skipif mysql # not compatible
query II rowsort label-465
SELECT col0 AS col0, col1 * 66 / + - 99 FROM tab2 AS cor0
----
46
-34
64
-51
75
-44

query I rowsort
SELECT DISTINCT + col1 + + 84 FROM tab2 cor0
----
135
151
161

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-467
SELECT ALL CAST( NULL AS SIGNED ) / + + COUNT( * ) FROM tab1, tab2 AS cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-467
SELECT ALL CAST ( NULL AS INTEGER ) / + + COUNT ( * ) FROM tab1, tab2 AS cor0
----
NULL

onlyif mysql # DIV for integer division: 
query I rowsort label-468
SELECT DISTINCT col0 DIV + + 21 AS col0 FROM tab0 cor0
----
0
4

skipif mysql # not compatible
query I rowsort label-468
SELECT DISTINCT col0 / + + 21 AS col0 FROM tab0 cor0
----
0
4

query I rowsort
SELECT ALL - + 76 * + col2 AS col2 FROM tab0 AS cor0
----
-3572
-7524
-760

query I rowsort
SELECT - col1 + + 54 * + + ( col1 ) AS col0 FROM tab0 AS cor0
----
1113
4293
53

query I rowsort
SELECT - + 36 + + col1 AS col1 FROM tab2 AS cor0
----
15
31
41

query II rowsort
SELECT ALL col1, col1 AS col0 FROM tab2 AS cor0
----
51
51
67
67
77
77

query III rowsort
SELECT DISTINCT * FROM tab1 AS cor0 WHERE NOT + 49 IS NULL
----
9 values hashing to c6c0a4111b36d04dbc811a11e4d54cad

query III rowsort
SELECT * FROM tab0 cor0 WHERE + ( + 86 ) IS NOT NULL
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

onlyif mysql # DIV for integer division: 
query II rowsort label-475
SELECT + + 36 AS col1, col0 DIV + col0 AS col1 FROM tab2 AS cor0
----
36
1
36
1
36
1

skipif mysql # not compatible
query II rowsort label-475
SELECT + + 36 AS col1, col0 / + col0 AS col1 FROM tab2 AS cor0
----
36
1
36
1
36
1

query I rowsort
SELECT DISTINCT - 88 AS col0 FROM tab2 WHERE NULL BETWEEN NULL AND - 38 - + col2
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT + col0 + 8 + - col0 * col0 col1 FROM tab2
----
-2062
-4024
-5542

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-478
SELECT ALL MIN( - 58 ) - CAST( NULL AS SIGNED ) * - COUNT( - - 49 ) * - + 44 AS col1 FROM tab0
----
NULL

skipif mysql # not compatible
query I rowsort label-478
SELECT ALL MIN ( - 58 ) - CAST ( NULL AS INTEGER ) * - COUNT ( - - 49 ) * - + 44 AS col1 FROM tab0
----
NULL

query I rowsort
SELECT DISTINCT col2 - + - 17 AS col1 FROM tab2
----
40
57
75

query I rowsort
SELECT DISTINCT col0 + + ( + 17 ) AS col2 FROM tab0
----
104
114
32

query I rowsort
SELECT DISTINCT col1 FROM tab2 WHERE NULL NOT BETWEEN NULL AND - + col0
----

onlyif mysql # CAST syntax: SIGNED type: DIV for integer division: 
query I rowsort label-482
SELECT ALL ( - - col1 ) DIV CAST( col1 AS SIGNED ) - - col0 + + col1 FROM tab2
----
142
143
98

skipif mysql # not compatible
query I rowsort label-482
SELECT ALL ( - - col1 ) / CAST ( col1 AS INTEGER ) - - col0 + + col1 FROM tab2
----
142
143
98

query I rowsort
SELECT + col2 FROM tab0 AS cor0 WHERE - col0 > NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-484
SELECT DISTINCT - MIN( DISTINCT col0 ) AS col2 FROM tab0 AS cor0
----
-15

skipif mysql # not compatible
query I rowsort label-484
SELECT DISTINCT - MIN ( DISTINCT col0 ) AS col2 FROM tab0 AS cor0
----
-15

onlyif mysql # aggregate syntax: 
query I rowsort label-485
SELECT - ( + - COUNT( DISTINCT + 97 ) ) AS col0 FROM tab1 AS cor0 CROSS JOIN tab0 AS cor1
----
1

skipif mysql # not compatible
query I rowsort label-485
SELECT - ( + - COUNT ( DISTINCT + 97 ) ) AS col0 FROM tab1 AS cor0 CROSS JOIN tab0 AS cor1
----
1

onlyif mysql # aggregate syntax: 
query I rowsort label-486
SELECT DISTINCT + MAX( ALL + + ( + col0 ) ) col1 FROM tab2 AS cor0
----
75

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-486
SELECT DISTINCT + MAX ( ALL + + ( + col0 ) ) col1 FROM tab2 AS cor0
----
75

onlyif mysql # aggregate syntax: 
query I rowsort label-487
SELECT ALL + MAX( ALL 13 ) FROM tab1 AS cor0
----
13

skipif mysql # not compatible
query I rowsort label-487
SELECT ALL + MAX ( ALL 13 ) FROM tab1 AS cor0
----
13

query I rowsort
SELECT DISTINCT ( - 14 ) AS col0 FROM tab2 cor0
----
-14

query II rowsort
SELECT ALL col2 * - ( - col1 ), + col0 FROM tab1 AS cor0
----
1344
51
295
85
3196
91

query II rowsort
SELECT - 26 AS col2, ( - ( - col0 ) ) AS col0 FROM tab2 AS cor0
----
-26
46
-26
64
-26
75

query II rowsort
SELECT + - 15 + + col2 AS col2, + col2 AS col2 FROM tab0 AS cor0 WHERE NOT NULL IS NOT NULL AND NULL <= 46 + + - col2
----

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-492
SELECT ALL * FROM tab0 AS cor0 WHERE NULL <= + CAST( NULL AS SIGNED ) * - - col2
----

skipif mysql # not compatible
query III rowsort label-492
SELECT ALL * FROM tab0 AS cor0 WHERE NULL <= + CAST ( NULL AS INTEGER ) * - - col2
----

onlyif mysql # aggregate syntax: 
query II rowsort label-493
SELECT - + ( - SUM( + - 96 ) ), + COUNT( ALL - 68 ) AS col0 FROM tab0 AS cor0
----
-288
3

skipif mysql # not compatible
query II rowsort label-493
SELECT - + ( - SUM ( + - 96 ) ), + COUNT ( ALL - 68 ) AS col0 FROM tab0 AS cor0
----
-288
3

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-494
SELECT DISTINCT - 3 / + col2 + - - 9 / CAST( NULL AS SIGNED ) / 63 FROM tab0 AS cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-494
SELECT DISTINCT - 3 / + col2 + - - 9 / CAST ( NULL AS INTEGER ) / 63 FROM tab0 AS cor0
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-495
SELECT 95 * - + COUNT( * ) * - 26 FROM tab2
----
7410

skipif mysql # not compatible
query I rowsort label-495
SELECT 95 * - + COUNT ( * ) * - 26 FROM tab2
----
7410

query I rowsort
SELECT DISTINCT + col2 AS col0 FROM tab2 WHERE - col1 < NULL
----

query III rowsort
SELECT * FROM tab1 WHERE NOT - + col2 * - - col1 IS NOT NULL
----

query III rowsort
SELECT * FROM tab0 WHERE NOT - 78 = NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-499
SELECT ALL col1 * + 89 * - CAST( NULL AS DECIMAL ) AS col1 FROM tab2
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-499
SELECT ALL col1 * + 89 * - CAST ( NULL AS REAL ) AS col1 FROM tab2
----
NULL
NULL
NULL

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-500
SELECT * FROM tab0 WHERE NOT - col0 > - 8 - - CAST( NULL AS SIGNED ) - + 54 * + 10
----

skipif mysql # not compatible
query III rowsort label-500
SELECT * FROM tab0 WHERE NOT - col0 > - 8 - - CAST ( NULL AS INTEGER ) - + 54 * + 10
----

onlyif mysql # DIV for integer division: 
query I rowsort label-501
SELECT ALL + - col1 DIV - col2 col2 FROM tab0 AS cor0
----
0
1
2

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-501
SELECT ALL + - col1 / - col2 col2 FROM tab0 AS cor0
----
0
1
2

query III rowsort
SELECT * FROM tab0 AS cor0 WHERE - col1 + col2 * + - col2 IS NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT + - col1 + 49 col2 FROM tab0 AS cor0
----
-32
28
48

query I rowsort
SELECT ALL + 47 * + - ( - - col2 ) + ( - + col1 ) AS col2 FROM tab0 AS cor0
----
-2290
-4654
-491

query I rowsort
SELECT col0 FROM tab0 AS cor0 WHERE ( + col2 + 9 + col0 > - + 10 * - - col1 )
----
15
87
97

query I rowsort
SELECT - - ( col1 ) * col0 FROM tab0 cor0
----
1215
1827
97

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT col1 col2 FROM tab1 AS cor0 WHERE NULL IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-508
SELECT ALL - COUNT( - - ( + - col2 ) ) col0 FROM tab1 AS cor0
----
-3

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-508
SELECT ALL - COUNT ( - - ( + - col2 ) ) col0 FROM tab1 AS cor0
----
-3

query I rowsort
SELECT + 29 - col2 - - - col0 AS col1 FROM tab2 cor0
----
-104
-40
-75

onlyif mysql # aggregate syntax: 
query I rowsort label-510
SELECT - + MIN( col0 ) AS col1 FROM tab0 WHERE ( NULL ) >= col2
----
NULL

skipif mysql # not compatible
query I rowsort label-510
SELECT - + MIN ( col0 ) AS col1 FROM tab0 WHERE ( NULL ) >= col2
----
NULL

query III rowsort
SELECT * FROM tab2 WHERE 26 > - col0
----
9 values hashing to 75c998aa53ac83218cbf2feb962d0a49

query III rowsort
SELECT * FROM tab0 WHERE NULL >= + col1 - - col2
----

query III rowsort
SELECT * FROM tab2 WHERE + ( + col2 ) BETWEEN ( - + 28 ) AND - 57
----

onlyif mysql # aggregate syntax: 
query I rowsort label-514
SELECT ALL COUNT( * ) AS col2 FROM tab2 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND - col2 - - col0
----
0

skipif mysql # not compatible
query I rowsort label-514
SELECT ALL COUNT ( * ) AS col2 FROM tab2 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND - col2 - - col0
----
0

query I rowsort
SELECT col2 * - col1 * 41 FROM tab1 AS cor0 WHERE NOT NULL IS NULL
----

onlyif mysql # aggregate syntax: DIV for integer division: 
query I rowsort label-516
SELECT DISTINCT + SUM( DISTINCT - + col1 ) DIV - + COUNT( * ) AS col0 FROM tab2 AS cor0
----
65

skipif mysql # not compatible
query I rowsort label-516
SELECT DISTINCT + SUM ( DISTINCT - + col1 ) / - + COUNT ( * ) AS col0 FROM tab2 AS cor0
----
65

query II rowsort
SELECT - + 98, - col0 AS col0 FROM tab0 AS cor0
----
-98
-15
-98
-87
-98
-97

query II rowsort
SELECT - col1 AS col2, - 34 AS col0 FROM tab0 AS cor0
----
-1
-34
-21
-34
-81
-34

onlyif mysql # aggregate syntax: 
query I rowsort label-519
SELECT DISTINCT SUM( DISTINCT + 88 ) + - 17 FROM tab2 cor0 CROSS JOIN tab0 AS cor1
----
71

skipif mysql # not compatible
query I rowsort label-519
SELECT DISTINCT SUM ( DISTINCT + 88 ) + - 17 FROM tab2 cor0 CROSS JOIN tab0 AS cor1
----
71

onlyif mysql # aggregate syntax: 
query I rowsort label-520
SELECT + SUM( 34 ) AS col1 FROM tab2 AS cor0
----
102

skipif mysql # not compatible
query I rowsort label-520
SELECT + SUM ( 34 ) AS col1 FROM tab2 AS cor0
----
102

query I rowsort
SELECT ALL 99 * 25 * - 64 FROM tab1 AS cor0 WHERE NOT NULL IS NOT NULL
----
-158400
-158400
-158400

query I rowsort
SELECT DISTINCT 96 FROM tab0 AS cor0 WHERE ( NULL ) IS NULL
----
96

onlyif mysql # DIV for integer division: 
query I rowsort label-523
SELECT - col1 DIV - - 50 FROM tab2 cor0
----
-1
-1
-1

skipif mysql # not compatible
query I rowsort label-523
SELECT - col1 / - - 50 FROM tab2 cor0
----
-1
-1
-1

query I rowsort
SELECT ALL ( + 2 ) AS col0 FROM tab1 AS cor0
----
2
2
2

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-525
SELECT DISTINCT + + 65 * - + 54 + - - CAST( NULL AS SIGNED ) FROM tab0 AS cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-525
SELECT DISTINCT + + 65 * - + 54 + - - CAST ( NULL AS INTEGER ) FROM tab0 AS cor0
----
NULL

query III rowsort
SELECT DISTINCT * FROM tab2 WHERE NOT NULL <= + col0
----

onlyif mysql # DIV for integer division: 
query I rowsort label-527
SELECT 57 + - 35 DIV + 35 FROM tab0
----
56
56
56

skipif mysql # not compatible
query I rowsort label-527
SELECT 57 + - 35 / + 35 FROM tab0
----
56
56
56

query III rowsort
SELECT * FROM tab1 WHERE NOT NULL > + col0 - col2 + - + col2 / - 50 + - col1
----

query I rowsort
SELECT DISTINCT - col2 + - col2 * 56 FROM tab1
----
-3363
-3876
-5472

query II rowsort
SELECT + 87 * col0 * - col1 AS col1, col0 AS col1 FROM tab2
----
-204102
46
-428736
64
-437175
75

onlyif mysql # aggregate syntax: 
query I rowsort label-531
SELECT DISTINCT ( + COUNT( * ) ) * + + 38 FROM tab0
----
114

skipif mysql # not compatible
query I rowsort label-531
SELECT DISTINCT ( + COUNT ( * ) ) * + + 38 FROM tab0
----
114

onlyif mysql # aggregate syntax: 
query I rowsort label-532
SELECT - MIN( - + col2 ) FROM tab0
----
99

skipif mysql # not compatible
query I rowsort label-532
SELECT - MIN ( - + col2 ) FROM tab0
----
99

onlyif mysql # aggregate syntax: 
query I rowsort label-533
SELECT ALL SUM( - 21 ) FROM tab0 AS cor0
----
-63

skipif mysql # not compatible
query I rowsort label-533
SELECT ALL SUM ( - 21 ) FROM tab0 AS cor0
----
-63

onlyif mysql # DIV for integer division: 
query I rowsort label-534
SELECT ( - - col1 ) + + col1 DIV ( + col1 ) FROM tab0
----
2
22
82

skipif mysql # not compatible
query I rowsort label-534
SELECT ( - - col1 ) + + col1 / ( + col1 ) FROM tab0
----
2
22
82

query I rowsort
SELECT col0 + - - 49 + - + col1 FROM tab1
----
129
86
93

query I rowsort
SELECT - 27 + + col2 + + + col2 FROM tab1 AS cor0
----
109
165
91

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-537
SELECT ALL col2 - + col2 + - CAST( 62 AS SIGNED ) + + 88 * - 18 FROM tab2 AS cor0
----
-1646
-1646
-1646

skipif mysql # not compatible
query I rowsort label-537
SELECT ALL col2 - + col2 + - CAST ( 62 AS INTEGER ) + + 88 * - 18 FROM tab2 AS cor0
----
-1646
-1646
-1646

query I rowsort
SELECT 49 * + col1 * + + col2 AS col2 FROM tab2 AS cor0
----
150920
190414
57477

onlyif mysql # aggregate syntax: 
query I rowsort label-539
SELECT ALL - COUNT( * ) - - + COUNT( * ) FROM tab0 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-539
SELECT ALL - COUNT ( * ) - - + COUNT ( * ) FROM tab0 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
0

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-540
SELECT - - CAST( NULL AS DECIMAL ) * - + col1 + - col0 FROM tab1 AS cor0
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-540
SELECT - - CAST ( NULL AS REAL ) * - + col1 + - col0 FROM tab1 AS cor0
----
NULL
NULL
NULL

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-541
SELECT CAST( NULL AS DECIMAL ) * + col0 col2 FROM tab2
----
NULL
NULL
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-541
SELECT CAST ( NULL AS REAL ) * + col0 col2 FROM tab2
----
NULL
NULL
NULL

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-542
SELECT DISTINCT 27 + + - 29 + - CAST( - SUM( ALL + col1 ) AS SIGNED ) - 24 AS col0 FROM tab1
----
40

skipif mysql # not compatible
query I rowsort label-542
SELECT DISTINCT 27 + + - 29 + - CAST ( - SUM ( ALL + col1 ) AS INTEGER ) - 24 AS col0 FROM tab1
----
40

onlyif mysql # aggregate syntax: 
query I rowsort label-543
SELECT + MIN( ALL - ( col2 ) ) * - 76 FROM tab2
----
4408

skipif mysql # not compatible
query I rowsort label-543
SELECT + MIN ( ALL - ( col2 ) ) * - 76 FROM tab2
----
4408

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT + 89 * ( col0 ) col0 FROM tab1
----
4539
7565
8099

query III rowsort
SELECT ALL * FROM tab2 AS cor0 WHERE NOT col1 + + col1 IS NOT NULL
----

query I rowsort
SELECT DISTINCT + - 88 AS col0 FROM tab2 cor0
----
-88

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - - ( 7 ) col0 FROM tab1 AS cor0
----
7
7
7

onlyif mysql # aggregate syntax: 
query I rowsort label-548
SELECT ( + - MAX( + col1 ) ) FROM tab1 AS cor0
----
-47

skipif mysql # not compatible
query I rowsort label-548
SELECT ( + - MAX ( + col1 ) ) FROM tab1 AS cor0
----
-47

query I rowsort
SELECT - col1 * - col2 * - - 31 * - 45 * + + col1 AS col1 FROM tab2
----
-330838200
-363204990
-83453085

onlyif mysql # DIV for integer division: 
query II rowsort label-550
SELECT DISTINCT ( - ( col0 ) ) DIV - col1 col0, - 17 AS col2 FROM tab2
----
0
-17
1
-17

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-550
SELECT DISTINCT ( - ( col0 ) ) / - col1 col0, - 17 AS col2 FROM tab2
----
0
-17
1
-17

onlyif mysql # CAST syntax: aggregate syntax: DECIMAL type: 
query I rowsort label-551
SELECT ALL MAX( DISTINCT - 22 ) + - MAX( ALL + + col0 ) FROM tab0 WHERE + + CAST( - col2 AS DECIMAL ) IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-551
SELECT ALL MAX ( DISTINCT - 22 ) + - MAX ( ALL + + col0 ) FROM tab0 WHERE + + CAST ( - col2 AS REAL ) IS NULL
----
NULL

query I rowsort
SELECT + 13 * - + col0 FROM tab0
----
-1131
-1261
-195

onlyif mysql # DIV for integer division: 
query I rowsort label-553
SELECT DISTINCT - col0 DIV - + 16 AS col2 FROM tab2
----
2
4

skipif mysql # not compatible
query I rowsort label-553
SELECT DISTINCT - col0 / - + 16 AS col2 FROM tab2
----
2
4

query I rowsort
SELECT + col0 * - 34 AS col2 FROM tab1
----
-1734
-2890
-3094

query I rowsort
SELECT DISTINCT + 24 AS col0 FROM tab1 AS cor0 CROSS JOIN tab1 AS cor1
----
24

query II rowsort
SELECT DISTINCT - col2, + col1 + + 7 AS col0 FROM tab1 cor0
----
-59
12
-68
54
-96
21

query II rowsort
SELECT ALL col0, + col0 AS col2 FROM tab2 AS cor0
----
46
46
64
64
75
75

query I rowsort
SELECT + col2 * + col0 AS col1 FROM tab2 AS cor0 WHERE NOT NULL IS NOT NULL
----
1058
2560
4350

onlyif mysql # aggregate syntax: 
query I rowsort label-559
SELECT + + MIN( ALL + 36 ) col0 FROM tab2 AS cor0
----
36

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-559
SELECT + + MIN ( ALL + 36 ) col0 FROM tab2 AS cor0
----
36

query II rowsort
SELECT ALL - col2, 21 * - 87 + ( + col0 ) * col0 AS col1 FROM tab2 AS cor0
----
-23
289
-40
2269
-58
3798

query II rowsort
SELECT 67 AS col2, - col1 FROM tab1 AS cor0
----
67
-14
67
-47
67
-5

onlyif mysql # aggregate syntax: 
query I rowsort label-562
SELECT ALL + 24 + COUNT( * ) AS col1 FROM tab1 AS cor0
----
27

skipif mysql # not compatible
query I rowsort label-562
SELECT ALL + 24 + COUNT ( * ) AS col1 FROM tab1 AS cor0
----
27

query I rowsort
SELECT DISTINCT + 56 + + - 86 AS col1 FROM tab0
----
-30

onlyif mysql # aggregate syntax: 
query I rowsort label-564
SELECT ALL - COUNT( * ) FROM tab1 WHERE NOT ( ( + 15 ) > + col2 - - ( 46 ) ) OR NOT col0 + col2 * + col2 IS NULL
----
-3

skipif mysql # not compatible
query I rowsort label-564
SELECT ALL - COUNT ( * ) FROM tab1 WHERE NOT ( ( + 15 ) > + col2 - - ( 46 ) ) OR NOT col0 + col2 * + col2 IS NULL
----
-3

query I rowsort
SELECT DISTINCT + col1 + + ( col0 ) FROM tab1
----
138
65
90

onlyif mysql # aggregate syntax: 
query I rowsort label-566
SELECT - COUNT( 72 ) * - - COUNT( ALL - 75 ) + + COUNT( * ) FROM tab2 AS cor0
----
-6

skipif mysql # not compatible
query I rowsort label-566
SELECT - COUNT ( 72 ) * - - COUNT ( ALL - 75 ) + + COUNT ( * ) FROM tab2 AS cor0
----
-6

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-567
SELECT - CAST( + - 56 AS SIGNED ) + - - col0 FROM tab1 cor0
----
107
141
147

skipif mysql # not compatible
query I rowsort label-567
SELECT - CAST ( + - 56 AS INTEGER ) + - - col0 FROM tab1 cor0
----
107
141
147

onlyif mysql # aggregate syntax: 
query I rowsort label-568
SELECT + 35 + MIN( DISTINCT - col0 ) FROM tab2 cor0
----
-40

skipif mysql # not compatible
query I rowsort label-568
SELECT + 35 + MIN ( DISTINCT - col0 ) FROM tab2 cor0
----
-40

query I rowsort
SELECT DISTINCT - col2 + - 47 FROM tab1
----
-106
-115
-143

query I rowsort
SELECT DISTINCT + + col2 * + - col1 FROM tab0 WHERE - 96 * - 60 NOT BETWEEN - col0 + + + 80 AND NULL
----

query I rowsort
SELECT ALL + 99 FROM ( tab1 AS cor0 CROSS JOIN tab1 AS cor1 )
----
9 values hashing to 4b77467dd5f346109d29f6364a7bb8db

query I rowsort
SELECT DISTINCT + + ( + - col0 ) + 27 AS col2 FROM tab1 AS cor0
----
-24
-58
-64

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-573
SELECT CAST( + 50 AS SIGNED ) * - col2 FROM tab2 AS cor0 WHERE ( NULL ) = NULL
----

skipif mysql # not compatible
query I rowsort label-573
SELECT CAST ( + 50 AS INTEGER ) * - col2 FROM tab2 AS cor0 WHERE ( NULL ) = NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-574
SELECT ALL + 59 - - CAST( NULL AS SIGNED ) + + col2 FROM tab0 AS cor0
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-574
SELECT ALL + 59 - - CAST ( NULL AS INTEGER ) + + col2 FROM tab0 AS cor0
----
NULL
NULL
NULL

query II rowsort
SELECT ALL - col1 - + + 65 AS col2, col1 FROM tab2 AS cor0 WHERE NOT NULL < 56
----

query I rowsort
SELECT + col0 - - col1 AS col0 FROM tab1 AS cor0
----
138
65
90

query II rowsort
SELECT ALL + col2 AS col2, + col1 * col2 AS col2 FROM tab2 AS cor0
----
23
1173
40
3080
58
3886

query I rowsort
SELECT - 19 + - 30 + 56 FROM tab1 AS cor0
----
7
7
7

query I rowsort
SELECT ALL + - col0 * + 22 AS col1 FROM tab1 AS cor0
----
-1122
-1870
-2002

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-580
SELECT DISTINCT CAST( 1 AS SIGNED ) * - ( + CAST( + ( + - col2 ) AS SIGNED ) ) FROM tab0
----
10
47
99

skipif mysql # not compatible
query I rowsort label-580
SELECT DISTINCT CAST ( 1 AS INTEGER ) * - ( + CAST ( + ( + - col2 ) AS INTEGER ) ) FROM tab0
----
10
47
99

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT - - 20 - + + col0 + - ( + col0 ) col1 FROM tab2 WHERE NOT NULL IS NOT NULL
----
-108
-130
-72

query III rowsort
SELECT * FROM tab2 WHERE NOT + + col0 - + + col1 IS NOT NULL
----

query III rowsort
SELECT DISTINCT * FROM tab0 WHERE - + col0 > - 75
----
15
81
47

onlyif mysql # aggregate syntax: 
query I rowsort label-584
SELECT + COUNT( ALL - - col1 ) AS col0 FROM tab2 AS cor0
----
3

skipif mysql # not compatible
query I rowsort label-584
SELECT + COUNT ( ALL - - col1 ) AS col0 FROM tab2 AS cor0
----
3

query II rowsort
SELECT + col0 * - - col0 - + col1 + 48 + + 66 AS col1, col1 AS col2 FROM tab2 AS cor0 WHERE NOT NULL >= 23
----

query III rowsort
SELECT ALL * FROM tab0 AS cor0 WHERE NULL > 98 + - + col1 + - col1
----

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-587
SELECT MIN( - + CAST( NULL AS SIGNED ) ) FROM tab2 AS cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-587
SELECT MIN ( - + CAST ( NULL AS INTEGER ) ) FROM tab2 AS cor0
----
NULL

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-588
SELECT DISTINCT COUNT( * ) * - ( - - MIN( DISTINCT - - col2 ) ) + + CAST( NULL AS SIGNED ) AS col2 FROM tab2 cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-588
SELECT DISTINCT COUNT ( * ) * - ( - - MIN ( DISTINCT - - col2 ) ) + + CAST ( NULL AS INTEGER ) AS col2 FROM tab2 cor0
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-589
SELECT - COUNT( * ) * + + 5 FROM tab0
----
-15

skipif mysql # not compatible
query I rowsort label-589
SELECT - COUNT ( * ) * + + 5 FROM tab0
----
-15

query I rowsort
SELECT + col2 * - col2 * + col1 * 39 FROM tab0
----
-382239
-6978231
-81900

onlyif mysql # aggregate syntax: 
query I rowsort label-591
SELECT DISTINCT - COUNT( - 73 ) FROM tab2 cor0 CROSS JOIN tab1 AS cor1
----
-9

skipif mysql # not compatible
query I rowsort label-591
SELECT DISTINCT - COUNT ( - 73 ) FROM tab2 cor0 CROSS JOIN tab1 AS cor1
----
-9

query I rowsort
SELECT ALL col2 * + col0 * + 87 AS col1 FROM tab2 AS cor0
----
222720
378450
92046

query I rowsort
SELECT - + 99 FROM tab0 cor0
----
-99
-99
-99

onlyif mysql # aggregate syntax: 
query II rowsort label-594
SELECT COUNT( * ), 3 col1 FROM tab2 AS cor0
----
3
3

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-594
SELECT COUNT ( * ), 3 col1 FROM tab2 AS cor0
----
3
3

query I rowsort
SELECT - 72 + - col2 * ( + 17 ) FROM tab1 AS cor0
----
-1075
-1228
-1704

query I rowsort
SELECT ALL ( + col1 ) * col1 AS col2 FROM tab1 AS cor0
----
196
2209
25

query I rowsort
SELECT + 77 + - - col2 FROM tab0 cor0
----
124
176
87

onlyif mysql # DIV for integer division: 
query I rowsort label-598
SELECT DISTINCT - col2 DIV + + col0 FROM tab1 cor0
----
-1
0

skipif mysql # not compatible
query I rowsort label-598
SELECT DISTINCT - col2 / + + col0 FROM tab1 cor0
----
-1
0

query III rowsort
SELECT * FROM tab0 AS cor0 WHERE col1 * - col1 <= - col2
----
15
81
47
87
21
10

query I rowsort
SELECT DISTINCT + col2 AS col1 FROM tab0 AS cor0 WHERE col2 + + - col1 NOT BETWEEN NULL AND NULL
----

query III rowsort
SELECT ALL * FROM tab2 AS cor0 WHERE - 15 IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-602
SELECT ALL - MAX( ALL - col2 ) AS col1 FROM tab1 WHERE NULL IS NOT NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-602
SELECT ALL - MAX ( ALL - col2 ) AS col1 FROM tab1 WHERE NULL IS NOT NULL
----
NULL

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-603
SELECT DISTINCT col0 + - 53 - - col0 * + col0 + + + col1 * + CAST( NULL AS SIGNED ), col1 AS col0 FROM tab2
----
NULL
51
NULL
67
NULL
77

skipif mysql # not compatible
query II rowsort label-603
SELECT DISTINCT col0 + - 53 - - col0 * + col0 + + + col1 * + CAST ( NULL AS INTEGER ), col1 AS col0 FROM tab2
----
NULL
51
NULL
67
NULL
77

query I rowsort
SELECT - ( - 97 ) + - col0 AS col1 FROM tab2
----
22
33
51

query I rowsort
SELECT ALL - col1 / + col2 FROM tab1 WHERE + - 69 * 59 - - 6 IS NULL
----

query I rowsort
SELECT ALL + 52 FROM tab0, tab1 AS cor0
----
9 values hashing to 7f4ae30893ab330784829711032ae599

query I rowsort
SELECT - 20 FROM tab0 WHERE NULL IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-608
SELECT DISTINCT * FROM tab2 WHERE NOT NULL NOT BETWEEN CAST( - col1 AS SIGNED ) AND col0 * 74 - + col1 + - col2 / + 13 / - 94
----

skipif mysql # not compatible
query III rowsort label-608
SELECT DISTINCT * FROM tab2 WHERE NOT NULL NOT BETWEEN CAST ( - col1 AS INTEGER ) AND col0 * 74 - + col1 + - col2 / + 13 / - 94
----

query II rowsort
SELECT + 21 AS col1, col0 * ( - + col2 ) FROM tab2
----
21
-1058
21
-2560
21
-4350

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-610
SELECT ALL CAST( NULL AS SIGNED ) + + 81 AS col2 FROM tab2
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-610
SELECT ALL CAST ( NULL AS INTEGER ) + + 81 AS col2 FROM tab2
----
NULL
NULL
NULL

query I rowsort
SELECT + 93 * + ( col2 ) FROM tab2
----
2139
3720
5394

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-612
SELECT ALL - 47 + - col2 * + CAST( NULL AS DECIMAL ) * - col1 AS col2 FROM tab2 AS cor0
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-612
SELECT ALL - 47 + - col2 * + CAST ( NULL AS REAL ) * - col1 AS col2 FROM tab2 AS cor0
----
NULL
NULL
NULL

query II rowsort
SELECT + + col0 - col2, col0 AS col0 FROM tab2 AS cor0
----
17
75
23
46
24
64

query I rowsort
SELECT ALL - col0 * + col2 * - col0 - - col2 FROM tab1
----
249792
426334
563176

query I rowsort
SELECT + + 33 AS col1 FROM tab2 AS cor0 CROSS JOIN tab1 cor1
----
9 values hashing to 620d384286e82d1c6c8b1b2b109a7da5

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-616
SELECT col1 + - 19 + CAST( + 82 AS SIGNED ) AS col1 FROM tab2
----
114
130
140

skipif mysql # not compatible
query I rowsort label-616
SELECT col1 + - 19 + CAST ( + 82 AS INTEGER ) AS col1 FROM tab2
----
114
130
140

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT + ( 60 ) col2 FROM tab0 AS cor0
----
60
60
60

onlyif mysql # aggregate syntax: 
query I rowsort label-618
SELECT ALL + + COUNT( * ) * ( + - 1 ) FROM tab0 AS cor0
----
-3

skipif mysql # not compatible
query I rowsort label-618
SELECT ALL + + COUNT ( * ) * ( + - 1 ) FROM tab0 AS cor0
----
-3

query I rowsort
SELECT DISTINCT - col2 AS col2 FROM tab2 AS cor0 WHERE NOT NULL IS NOT NULL
----
-23
-40
-58

query I rowsort
SELECT DISTINCT - col1 * 32 FROM tab0 AS cor0
----
-2592
-32
-672

query II rowsort
SELECT + 43 AS col0, + col0 AS col2 FROM tab1
----
43
51
43
85
43
91

query II rowsort
SELECT 92 AS col0, col2 FROM tab2
----
92
23
92
40
92
58

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-623
SELECT ALL - CAST( + col0 AS SIGNED ) AS col0 FROM tab2
----
-46
-64
-75

skipif mysql # not compatible
query I rowsort label-623
SELECT ALL - CAST ( + col0 AS INTEGER ) AS col0 FROM tab2
----
-46
-64
-75

onlyif mysql # CAST syntax: SIGNED type: DECIMAL type: 
query III rowsort label-624
SELECT * FROM tab1 WHERE NOT - + 51 - - CAST( NULL AS SIGNED ) >= + CAST( NULL AS DECIMAL )
----

skipif mysql # not compatible
query III rowsort label-624
SELECT * FROM tab1 WHERE NOT - + 51 - - CAST ( NULL AS INTEGER ) >= + CAST ( NULL AS REAL )
----

query III rowsort
SELECT DISTINCT * FROM tab1 WHERE NOT col2 + - + 24 IS NOT NULL
----

query III rowsort
SELECT DISTINCT * FROM tab0 AS cor0 WHERE + 75 IN ( + 39 + ( + col2 ) - 32, - 68 )
----

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-627
SELECT col1, 70 FROM tab1 AS cor0 WHERE NOT + CAST( NULL AS SIGNED ) <= - + 87 * - - col2 * + CAST( NULL AS SIGNED )
----

skipif mysql # not compatible
query II rowsort label-627
SELECT col1, 70 FROM tab1 AS cor0 WHERE NOT + CAST ( NULL AS INTEGER ) <= - + 87 * - - col2 * + CAST ( NULL AS INTEGER )
----

query II rowsort
SELECT + col1, col2 AS col0 FROM tab2 cor0
----
51
23
67
58
77
40

query II rowsort
SELECT - 10 AS col0, col2 AS col1 FROM tab2 AS cor0
----
-10
23
-10
40
-10
58

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-630
SELECT ALL - CAST( - col0 AS SIGNED ) * - col2 * + col2 * + col2 AS col2, 28 * - col1 FROM tab1 AS cor0
----
-17457215
-140
-28613312
-1316
-45121536
-392

skipif mysql # not compatible
query II rowsort label-630
SELECT ALL - CAST ( - col0 AS INTEGER ) * - col2 * + col2 * + col2 AS col2, 28 * - col1 FROM tab1 AS cor0
----
-17457215
-140
-28613312
-1316
-45121536
-392

onlyif mysql # DIV for integer division: 
query I rowsort label-631
SELECT DISTINCT + + col2 DIV - 64 FROM tab2 AS cor0
----
0

skipif mysql # not compatible
query I rowsort label-631
SELECT DISTINCT + + col2 / - 64 FROM tab2 AS cor0
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-632
SELECT - + 55 * + - MIN( + col0 ) FROM tab2 AS cor0
----
2530

skipif mysql # not compatible
query I rowsort label-632
SELECT - + 55 * + - MIN ( + col0 ) FROM tab2 AS cor0
----
2530

query III rowsort
SELECT DISTINCT * FROM tab0 WHERE NULL IN ( col2 * + col1 + + col2, col1 )
----

query I rowsort
SELECT + 90 - - 31 FROM tab0
----
121
121
121

query I rowsort
SELECT ALL + 61 + - + col1 FROM tab2
----
-16
-6
10

onlyif mysql # aggregate syntax: 
query I rowsort label-636
SELECT ALL - + COUNT( ALL - 99 ) AS col0 FROM tab0 AS cor0
----
-3

skipif mysql # not compatible
query I rowsort label-636
SELECT ALL - + COUNT ( ALL - 99 ) AS col0 FROM tab0 AS cor0
----
-3

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-637
SELECT - - CAST( NULL AS DECIMAL ) AS col1 FROM tab0 AS cor0
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-637
SELECT - - CAST ( NULL AS REAL ) AS col1 FROM tab0 AS cor0
----
NULL
NULL
NULL

query I rowsort
SELECT ALL + col1 + - col2 * - ( - 1 ) AS col2 FROM tab1 AS cor0
----
-21
-54
-82

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - col0 col2, col2 AS col2 FROM tab2
----
-46
23
-64
40
-75
58

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL + 24 + col2 col0 FROM tab0
----
123
34
71

query I rowsort
SELECT 36 * - 58 FROM tab2 AS cor0 CROSS JOIN tab2 AS cor1
----
9 values hashing to 58e9f3902c238258a25fa87e37d76735

onlyif mysql # CAST syntax: DECIMAL type: 
query II rowsort label-642
SELECT DISTINCT 14 AS col1, CAST( NULL AS DECIMAL ) col2 FROM tab0
----
14
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-642
SELECT DISTINCT 14 AS col1, CAST ( NULL AS REAL ) col2 FROM tab0
----
14
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-643
SELECT MAX( col1 ) AS col2 FROM tab0 AS cor0
----
81

skipif mysql # not compatible
query I rowsort label-643
SELECT MAX ( col1 ) AS col2 FROM tab0 AS cor0
----
81

query II rowsort
SELECT DISTINCT - + 62, 93 AS col2 FROM tab0 AS cor0
----
-62
93

query II rowsort
SELECT col0, ( - col1 ) * + col1 * - - 55 + col0 FROM tab0 AS cor0
----
15
-360840
87
-24168
97
42

query III rowsort
SELECT ALL * FROM tab2 AS cor0 WHERE - 57 < NULL
----

query II rowsort
SELECT - - 11, col2 FROM tab1 AS cor0
----
11
59
11
68
11
96

onlyif mysql # aggregate syntax: 
query I rowsort label-648
SELECT ALL COUNT( * ) * ( + 60 ) FROM tab2 AS cor0
----
180

skipif mysql # not compatible
query I rowsort label-648
SELECT ALL COUNT ( * ) * ( + 60 ) FROM tab2 AS cor0
----
180

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT - 45 * + col1 col0 FROM tab0 AS cor0
----
-3645
-45
-945

onlyif mysql # aggregate syntax: 
query II rowsort label-650
SELECT - COUNT( * ), - 0 AS col2 FROM tab1 AS cor0
----
-3
0

skipif mysql # not compatible
query II rowsort label-650
SELECT - COUNT ( * ), - 0 AS col2 FROM tab1 AS cor0
----
-3
0

query I rowsort
SELECT - 76 * + col0 FROM tab2
----
-3496
-4864
-5700

onlyif mysql # aggregate syntax: 
query I rowsort label-652
SELECT DISTINCT 2 * SUM( ALL 95 ) FROM tab2, tab0 AS cor0
----
1710

skipif mysql # not compatible
query I rowsort label-652
SELECT DISTINCT 2 * SUM ( ALL 95 ) FROM tab2, tab0 AS cor0
----
1710

query I rowsort
SELECT ALL col0 * 30 * 39 FROM tab2
----
53820
74880
87750

onlyif mysql # aggregate syntax: 
query I rowsort label-654
SELECT DISTINCT - ( - MIN( - - col0 ) ) col2 FROM tab0
----
15

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-654
SELECT DISTINCT - ( - MIN ( - - col0 ) ) col2 FROM tab0
----
15

query II rowsort
SELECT DISTINCT 57 AS col1, - 78 * - col1 FROM tab1
----
57
1092
57
3666
57
390

query I rowsort
SELECT ALL + 22 * + col1 FROM tab0
----
1782
22
462

query III rowsort
SELECT * FROM tab2 WHERE NOT NULL <> col2 AND col2 IS NOT NULL
----

query I rowsort
SELECT + 57 + 88 AS col1 FROM tab1 AS cor0
----
145
145
145

onlyif mysql # aggregate syntax: 
query I rowsort label-659
SELECT DISTINCT + + 10 * + MAX( ALL ( col0 ) ) FROM tab2 cor0
----
750

skipif mysql # not compatible
query I rowsort label-659
SELECT DISTINCT + + 10 * + MAX ( ALL ( col0 ) ) FROM tab2 cor0
----
750

query I rowsort
SELECT DISTINCT + - 82 FROM tab0 AS cor0 WHERE NOT + col2 NOT BETWEEN + 86 / - + col2 * + col1 AND + - col0
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL col1 + - col2 col2, col1 AS col0 FROM tab1
----
-21
47
-54
5
-82
14

onlyif mysql # DIV for integer division: 
query I rowsort label-662
SELECT 72 DIV ( col2 ) FROM tab2
----
1
1
3

skipif mysql # not compatible
query I rowsort label-662
SELECT 72 / ( col2 ) FROM tab2
----
1
1
3

query I rowsort
SELECT DISTINCT 35 + - col0 FROM tab0
----
-52
-62
20

query I rowsort
SELECT - + col0 * 8 / + col0 AS col0 FROM tab1 WHERE + + 13 < - 75 + - + col1 + + + col0
----

onlyif mysql # aggregate syntax: 
query I rowsort label-665
SELECT ALL + - SUM( - 84 ) - + 92 FROM tab0 AS cor0
----
160

skipif mysql # not compatible
query I rowsort label-665
SELECT ALL + - SUM ( - 84 ) - + 92 FROM tab0 AS cor0
----
160

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT 79 col0 FROM tab0 AS cor0 WHERE NULL IS NOT NULL
----

query I rowsort
SELECT ALL - + col2 - - + col1 AS col0 FROM tab1 cor0
----
-21
-54
-82

onlyif mysql # DIV for integer division: 
query I rowsort label-668
SELECT DISTINCT - 33 DIV - col1 FROM tab2
----
0

skipif mysql # not compatible
query I rowsort label-668
SELECT DISTINCT - 33 / - col1 FROM tab2
----
0

query I rowsort
SELECT 74 + + 11 + col2 FROM tab0 AS cor0 WHERE NOT NULL IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-670
SELECT DISTINCT + + SUM( - col0 ) col1 FROM tab2 AS cor0
----
-185

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-670
SELECT DISTINCT + + SUM ( - col0 ) col1 FROM tab2 AS cor0
----
-185

query II rowsort
SELECT DISTINCT col0, col1 AS col2 FROM tab0
----
15
81
87
21
97
1

onlyif mysql # aggregate syntax: 
query I rowsort label-672
SELECT - COUNT( * ) * - 15 FROM tab2
----
45

skipif mysql # not compatible
query I rowsort label-672
SELECT - COUNT ( * ) * - 15 FROM tab2
----
45

query I rowsort
SELECT + 92 * 48 FROM tab0
----
4416
4416
4416

onlyif mysql # aggregate syntax: 
query II rowsort label-674
SELECT ALL COUNT( * ) AS col1, MAX( - - col0 ) FROM tab2
----
3
75

skipif mysql # not compatible
query II rowsort label-674
SELECT ALL COUNT ( * ) AS col1, MAX ( - - col0 ) FROM tab2
----
3
75

onlyif mysql # aggregate syntax: 
query I rowsort label-675
SELECT MAX( DISTINCT + + col2 ) * 28 * - 96 AS col0 FROM tab0 AS cor0 WHERE ( - 35 * col0 * + 60 * + - col2 + + 58 IS NULL )
----
NULL

skipif mysql # not compatible
query I rowsort label-675
SELECT MAX ( DISTINCT + + col2 ) * 28 * - 96 AS col0 FROM tab0 AS cor0 WHERE ( - 35 * col0 * + 60 * + - col2 + + 58 IS NULL )
----
NULL

query III rowsort
SELECT ALL * FROM tab2 AS cor0 WHERE NULL <> + 86 * - col1
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-677
SELECT - + col1 + - - col0 + - CAST( NULL AS SIGNED ) FROM tab1 AS cor0
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-677
SELECT - + col1 + - - col0 + - CAST ( NULL AS INTEGER ) FROM tab1 AS cor0
----
NULL
NULL
NULL

onlyif mysql # DIV for integer division: 
query I rowsort label-678
SELECT + col0 + + col0 DIV col0 AS col1 FROM tab2
----
47
65
76

skipif mysql # not compatible
query I rowsort label-678
SELECT + col0 + + col0 / col0 AS col1 FROM tab2
----
47
65
76

onlyif mysql # DIV for integer division: 
query I rowsort label-679
SELECT - col2 - col0 DIV col0 FROM tab0 cor0
----
-100
-11
-48

skipif mysql # not compatible
query I rowsort label-679
SELECT - col2 - col0 / col0 FROM tab0 cor0
----
-100
-11
-48

onlyif mysql # DIV for integer division: 
query I rowsort label-680
SELECT + col1 DIV col1 * col0 + + 32 - - - col2 AS col0 FROM tab0 AS cor0
----
0
109
30

skipif mysql # not compatible
query I rowsort label-680
SELECT + col1 / col1 * col0 + + 32 - - - col2 AS col0 FROM tab0 AS cor0
----
0
109
30

onlyif mysql # aggregate syntax: DIV for integer division: 
query I rowsort label-681
SELECT - 90 - - COUNT( * ) + + COUNT( * ) + - + COUNT( * ) DIV + 60 FROM tab0 AS cor0
----
-84

skipif mysql # not compatible
query I rowsort label-681
SELECT - 90 - - COUNT ( * ) + + COUNT ( * ) + - + COUNT ( * ) / + 60 FROM tab0 AS cor0
----
-84

query I rowsort
SELECT 92 + col2 AS col2 FROM tab0
----
102
139
191

onlyif mysql # aggregate syntax: 
query I rowsort label-683
SELECT ALL COUNT( * ) + + - COUNT( + col1 ) AS col0 FROM tab1
----
0

skipif mysql # not compatible
query I rowsort label-683
SELECT ALL COUNT ( * ) + + - COUNT ( + col1 ) AS col0 FROM tab1
----
0

query I rowsort
SELECT ALL col2 * 5 FROM tab0 WHERE ( 34 + 33 IS NULL )
----

query II rowsort
SELECT - ( ( 13 ) ), + col1 FROM tab1 AS cor0
----
-13
14
-13
47
-13
5

query III rowsort
SELECT ALL * FROM tab0 AS cor0 WHERE NOT 21 = NULL
----

query I rowsort
SELECT 61 FROM tab2 WHERE + 61 * ( - col0 ) IS NOT NULL
----
61
61
61

query I rowsort
SELECT ALL + col2 * + col1 FROM tab1 WHERE NULL NOT IN ( 75 + - 76 )
----

query I rowsort
SELECT DISTINCT 56 * - 52 FROM tab0 WHERE 87 / + 19 + col0 * col0 IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-690
SELECT COUNT( * ) FROM tab0 WHERE NOT ( NULL ) >= ( col0 )
----
0

skipif mysql # not compatible
query I rowsort label-690
SELECT COUNT ( * ) FROM tab0 WHERE NOT ( NULL ) >= ( col0 )
----
0

onlyif mysql # aggregate syntax: DIV for integer division: 
query I rowsort label-691
SELECT ALL ( 80 ) + MAX( DISTINCT - col1 + col2 ) DIV COUNT( * ) FROM tab2
----
77

skipif mysql # not compatible
query I rowsort label-691
SELECT ALL ( 80 ) + MAX ( DISTINCT - col1 + col2 ) / COUNT ( * ) FROM tab2
----
77

onlyif mysql # aggregate syntax: 
query I rowsort label-692
SELECT ( + MAX( DISTINCT col2 ) ) AS col1 FROM tab1
----
96

skipif mysql # not compatible
query I rowsort label-692
SELECT ( + MAX ( DISTINCT col2 ) ) AS col1 FROM tab1
----
96

onlyif mysql # aggregate syntax: 
query I rowsort label-693
SELECT + COUNT( DISTINCT + 14 ) + MIN( 46 ) col0 FROM tab2 WHERE - col1 + col0 IN ( - col2 + 19 )
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-693
SELECT + COUNT ( DISTINCT + 14 ) + MIN ( 46 ) col0 FROM tab2 WHERE - col1 + col0 IN ( - col2 + 19 )
----
NULL

query III rowsort
SELECT ALL * FROM tab0 WHERE NOT col2 * col0 IN ( + col2 * col0 + - col0 )
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

query I rowsort
SELECT ALL + ( - col1 ) FROM tab2 WHERE NOT col0 / col0 IS NOT NULL
----

query I rowsort
SELECT + col0 AS col1 FROM tab2 WHERE NOT NULL IS NOT NULL
----
46
64
75

query I rowsort
SELECT ALL - col2 - 75 * col1 FROM tab1
----
-1146
-3593
-434

query III rowsort
SELECT ALL * FROM tab0 WHERE - 78 BETWEEN ( 66 ) AND - ( - col0 )
----

query III rowsort
SELECT * FROM tab0 WHERE - col1 * - col0 IS NOT NULL
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

query I rowsort
SELECT 7 + - col0 FROM tab2 WHERE NULL IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT + 91 col0 FROM tab1
----
91
91
91

query I rowsort
SELECT 79 + + 77 AS col2 FROM tab2
----
156
156
156

query I rowsort
SELECT ALL - col1 FROM tab0 WHERE - col0 * - col1 + - col0 * col2 IS NULL
----

query III rowsort
SELECT DISTINCT * FROM tab2 AS cor0 WHERE NOT + col2 * - col1 + + col2 NOT IN ( col0 / + 20 )
----

query I rowsort
SELECT + col1 FROM tab0 WHERE - col2 * + col1 IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-706
SELECT + MAX( DISTINCT + col0 ) + COUNT( * ) AS col1 FROM tab2
----
78

skipif mysql # not compatible
query I rowsort label-706
SELECT + MAX ( DISTINCT + col0 ) + COUNT ( * ) AS col1 FROM tab2
----
78

query I rowsort
SELECT - col1 + - 34 * - col1 FROM tab2
----
1683
2211
2541

onlyif mysql # aggregate syntax: 
query I rowsort label-708
SELECT ALL COUNT( * ) * - 48 AS col0 FROM tab0 WHERE ( col2 ) IS NOT NULL
----
-144

skipif mysql # not compatible
query I rowsort label-708
SELECT ALL COUNT ( * ) * - 48 AS col0 FROM tab0 WHERE ( col2 ) IS NOT NULL
----
-144

query IIIIII rowsort
SELECT DISTINCT * FROM ( tab1 cor0 CROSS JOIN tab1 )
----
54 values hashing to 375f372843089b03f23b00160007527a

onlyif mysql # aggregate syntax: 
query I rowsort label-710
SELECT COUNT( * ) + - ( 33 ) AS col2 FROM tab2
----
-30

skipif mysql # not compatible
query I rowsort label-710
SELECT COUNT ( * ) + - ( 33 ) AS col2 FROM tab2
----
-30

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-711
SELECT ALL + col1 * + CAST( - ( - 85 ) AS SIGNED ) AS col0 FROM tab1 AS cor0
----
1190
3995
425

skipif mysql # not compatible
query I rowsort label-711
SELECT ALL + col1 * + CAST ( - ( - 85 ) AS INTEGER ) AS col0 FROM tab1 AS cor0
----
1190
3995
425

query I rowsort
SELECT DISTINCT + col0 * - 76 FROM tab1 AS cor0
----
-3876
-6460
-6916

onlyif mysql # aggregate syntax: 
query I rowsort label-713
SELECT + + SUM( DISTINCT col1 ) + - ( 58 ) FROM tab2 AS cor0
----
137

skipif mysql # not compatible
query I rowsort label-713
SELECT + + SUM ( DISTINCT col1 ) + - ( 58 ) FROM tab2 AS cor0
----
137

query I rowsort
SELECT col2 * + col0 AS col2 FROM tab0 AS cor0 WHERE NULL BETWEEN ( + col1 ) AND + 57
----

onlyif mysql # DIV for integer division: 
query I rowsort label-715
SELECT DISTINCT + col0 DIV 4 - - col1 * col0 FROM tab1 AS cor0
----
4299
446
726

skipif mysql # not compatible
query I rowsort label-715
SELECT DISTINCT + col0 / 4 - - col1 * col0 FROM tab1 AS cor0
----
4299
446
726

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - col2 col1 FROM tab2 AS cor0 WHERE NOT - col1 <> + col1
----

query I rowsort
SELECT + col2 FROM tab1 AS cor0 WHERE ( col1 + - 98 * + col2 ) > NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-718
SELECT ALL ( + COUNT( * ) ) * 19 FROM tab2 cor0
----
57

skipif mysql # not compatible
query I rowsort label-718
SELECT ALL ( + COUNT ( * ) ) * 19 FROM tab2 cor0
----
57

query I rowsort
SELECT DISTINCT + col0 + 45 FROM tab1 AS cor0
----
130
136
96

query III rowsort
SELECT ALL * FROM tab1 WHERE NOT col2 * 78 + - col0 BETWEEN NULL AND ( + col2 )
----
9 values hashing to c6c0a4111b36d04dbc811a11e4d54cad

query III rowsort
SELECT * FROM tab1 WHERE - 93 NOT BETWEEN NULL AND - col2
----
51
14
96

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-722
SELECT DISTINCT CAST( NULL AS DECIMAL ) * col1 AS col2 FROM tab1
----
NULL

skipif mysql # not compatible
query I rowsort label-722
SELECT DISTINCT CAST ( NULL AS REAL ) * col1 AS col2 FROM tab1
----
NULL

query III rowsort
SELECT ALL * FROM tab0 WHERE ( col0 + - 92 * col1 ) < NULL
----

query I rowsort
SELECT ALL - col2 + - + 88 AS col0 FROM tab2
----
-111
-128
-146

query I rowsort
SELECT ALL 48 + - col2 AS col0 FROM tab0
----
-51
1
38

query I rowsort
SELECT - col1 - - + 70 AS col0 FROM tab1
----
23
56
65

onlyif mysql # DIV for integer division: 
query I rowsort label-727
SELECT 22 * + ( col0 ) - col1 DIV - col2 FROM tab2
----
1014
1409
1651

skipif mysql # not compatible
query I rowsort label-727
SELECT 22 * + ( col0 ) - col1 / - col2 FROM tab2
----
1014
1409
1651

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-728
SELECT ALL - col0 + + CAST( NULL AS SIGNED ) - + col0 FROM tab1
----
NULL
NULL
NULL

skipif mysql # not compatible
query I rowsort label-728
SELECT ALL - col0 + + CAST ( NULL AS INTEGER ) - + col0 FROM tab1
----
NULL
NULL
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-729
SELECT DISTINCT + + COUNT( * ) * 92 * - 91 AS col0 FROM tab1 cor0
----
-25116

skipif mysql # not compatible
query I rowsort label-729
SELECT DISTINCT + + COUNT ( * ) * 92 * - 91 AS col0 FROM tab1 cor0
----
-25116

query I rowsort
SELECT ALL 95 AS col1 FROM tab0 AS cor0 WHERE NOT + col1 * + col0 IS NULL
----
95
95
95

onlyif mysql # aggregate syntax: 
query I rowsort label-731
SELECT DISTINCT 21 + + COUNT( * ) AS col2 FROM tab2 WHERE NULL IS NULL
----
24

skipif mysql # not compatible
query I rowsort label-731
SELECT DISTINCT 21 + + COUNT ( * ) AS col2 FROM tab2 WHERE NULL IS NULL
----
24

query II rowsort
SELECT DISTINCT col0, col2 + + col1 - col2 * col1 FROM tab0
----
15
-3679
87
-179
97
1

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-733
SELECT ALL + CAST( + col0 AS SIGNED ) col0 FROM tab0
----
15
87
97

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-733
SELECT ALL + CAST ( + col0 AS INTEGER ) col0 FROM tab0
----
15
87
97

onlyif mysql # aggregate syntax: 
query I rowsort label-734
SELECT ALL SUM( - ( - 66 ) ) FROM tab2 AS cor0 CROSS JOIN tab0 AS cor1
----
594

skipif mysql # not compatible
query I rowsort label-734
SELECT ALL SUM ( - ( - 66 ) ) FROM tab2 AS cor0 CROSS JOIN tab0 AS cor1
----
594

query III rowsort
SELECT * FROM tab1 WHERE NOT + 7 > ( - 71 * 95 - 84 )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL + - col2 * - col0 * col0 * - col1 col0 FROM tab0 cor0
----
-1589490
-856575
-931491

onlyif mysql # aggregate syntax: 
query I rowsort label-737
SELECT ALL + - SUM( ALL - col2 ) FROM tab0 cor0
----
156

skipif mysql # not compatible
query I rowsort label-737
SELECT ALL + - SUM ( ALL - col2 ) FROM tab0 cor0
----
156

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-738
SELECT DISTINCT col0 * CAST( 62 AS SIGNED ) * 18 - - col0 FROM tab2 AS cor0
----
51382
71488
83775

skipif mysql # not compatible
query I rowsort label-738
SELECT DISTINCT col0 * CAST ( 62 AS INTEGER ) * 18 - - col0 FROM tab2 AS cor0
----
51382
71488
83775

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL + ( - col2 ) * - - col2 col1 FROM tab0 AS cor0
----
-100
-2209
-9801

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT - col0 * + + 83 * - - 69 col2 FROM tab1 AS cor0
----
-292077
-486795
-521157

onlyif mysql # aggregate syntax: 
query I rowsort label-741
SELECT ALL MIN( ALL 87 ) AS col1 FROM tab1 AS cor0 WHERE ( col2 / - ( - col1 ) + col1 ) NOT IN ( 45 )
----
87

skipif mysql # not compatible
query I rowsort label-741
SELECT ALL MIN ( ALL 87 ) AS col1 FROM tab1 AS cor0 WHERE ( col2 / - ( - col1 ) + col1 ) NOT IN ( 45 )
----
87

onlyif mysql # aggregate syntax: 
query I rowsort label-742
SELECT - 65 * + + COUNT( * ) * + + 23 * - COUNT( * ) * 63 FROM tab0
----
847665

skipif mysql # not compatible
query I rowsort label-742
SELECT - 65 * + + COUNT ( * ) * + + 23 * - COUNT ( * ) * 63 FROM tab0
----
847665

onlyif mysql # aggregate syntax: 
query I rowsort label-743
SELECT DISTINCT COUNT( DISTINCT col2 ) AS col1 FROM tab1 WHERE NOT ( 17 ) NOT BETWEEN 8 AND ( col0 ) * col2
----
3

skipif mysql # not compatible
query I rowsort label-743
SELECT DISTINCT COUNT ( DISTINCT col2 ) AS col1 FROM tab1 WHERE NOT ( 17 ) NOT BETWEEN 8 AND ( col0 ) * col2
----
3

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - - 85 + col0 col0 FROM tab1 WHERE NOT - 30 IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-745
SELECT * FROM tab1 WHERE ( ( col2 ) ) < CAST( + col2 AS SIGNED )
----

skipif mysql # not compatible
query III rowsort label-745
SELECT * FROM tab1 WHERE ( ( col2 ) ) < CAST ( + col2 AS INTEGER )
----

query I rowsort
SELECT - col2 AS col0 FROM tab0 WHERE NULL <= + - col0
----

query I rowsort
SELECT col1 + - + 61 * col0 AS col1 FROM tab1 AS cor0
----
-3097
-5180
-5504

onlyif mysql # aggregate syntax: 
query I rowsort label-748
SELECT 71 * - - COUNT( * ) + MAX( DISTINCT + col1 ) AS col1 FROM tab0 AS cor0
----
294

skipif mysql # not compatible
query I rowsort label-748
SELECT 71 * - - COUNT ( * ) + MAX ( DISTINCT + col1 ) AS col1 FROM tab0 AS cor0
----
294

onlyif mysql # aggregate syntax: 
query II rowsort label-749
SELECT + COUNT( * ) AS col2, + 99 AS col2 FROM tab1 cor0 WHERE NULL IS NOT NULL
----
0
99

skipif mysql # not compatible
query II rowsort label-749
SELECT + COUNT ( * ) AS col2, + 99 AS col2 FROM tab1 cor0 WHERE NULL IS NOT NULL
----
0
99

query III rowsort
SELECT * FROM tab2 WHERE + 85 IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-751
SELECT ALL - + ( - 12 ) * - + COUNT( * ) FROM tab2 AS cor0 CROSS JOIN tab2 cor1
----
-108

skipif mysql # not compatible
query I rowsort label-751
SELECT ALL - + ( - 12 ) * - + COUNT ( * ) FROM tab2 AS cor0 CROSS JOIN tab2 cor1
----
-108

query I rowsort
SELECT + 51 FROM tab1 cor0 CROSS JOIN tab0 AS cor1 WHERE NOT ( NULL ) IS NOT NULL
----
9 values hashing to d8bf0a05c9c4d2a93812d106baae4752

onlyif mysql # aggregate syntax: 
query I rowsort label-753
SELECT ALL MAX( DISTINCT - + col1 ) FROM tab2 AS cor0
----
-51

skipif mysql # not compatible
query I rowsort label-753
SELECT ALL MAX ( DISTINCT - + col1 ) FROM tab2 AS cor0
----
-51

query I rowsort
SELECT - col2 AS col1 FROM tab2 AS cor0 WHERE col2 < ( 81 / - col2 + - + col1 )
----

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-755
SELECT - 70 - + - 69 + - COUNT( * ) * CAST( COUNT( * ) AS SIGNED ) - MIN( ALL col0 ) AS col2 FROM tab1 cor0
----
-61

skipif mysql # not compatible
query I rowsort label-755
SELECT - 70 - + - 69 + - COUNT ( * ) * CAST ( COUNT ( * ) AS INTEGER ) - MIN ( ALL col0 ) AS col2 FROM tab1 cor0
----
-61

query II rowsort
SELECT - + col0 - - col1 * - + col1 AS col2, col1 FROM tab2 AS cor0
----
-2647
51
-4564
67
-5993
77

query I rowsort
SELECT + col2 - - - 7 AS col1 FROM tab0 AS cor0
----
3
40
92

query I rowsort
SELECT DISTINCT col0 AS col2 FROM tab1 cor0 WHERE ( col2 ) IS NOT NULL AND NOT ( + + 16 ) < - col2 - ( + 85 )
----
51
85
91

query I rowsort
SELECT col0 - + 28 FROM tab1 AS cor0
----
23
57
63

onlyif mysql # aggregate syntax: 
query I rowsort label-760
SELECT ALL - COUNT( * ) + - ( - - 51 ) AS col1 FROM tab0 AS cor0
----
-54

skipif mysql # not compatible
query I rowsort label-760
SELECT ALL - COUNT ( * ) + - ( - - 51 ) AS col1 FROM tab0 AS cor0
----
-54

onlyif mysql # aggregate syntax: 
query I rowsort label-761
SELECT ALL - COUNT( * ) * + 15 FROM tab0 AS cor0
----
-45

skipif mysql # not compatible
query I rowsort label-761
SELECT ALL - COUNT ( * ) * + 15 FROM tab0 AS cor0
----
-45

query III rowsort
SELECT * FROM tab2 AS cor0 WHERE col1 IN ( - 81, + col1 + + col1 + - col1 )
----
9 values hashing to 75c998aa53ac83218cbf2feb962d0a49

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-763
SELECT * FROM tab0 AS cor0 WHERE col0 * + col1 + - - col1 BETWEEN ( - CAST( col2 AS SIGNED ) ) AND ( + col2 )
----
97
1
99

skipif mysql # not compatible
query III rowsort label-763
SELECT * FROM tab0 AS cor0 WHERE col0 * + col1 + - - col1 BETWEEN ( - CAST ( col2 AS INTEGER ) ) AND ( + col2 )
----
97
1
99

onlyif mysql # aggregate syntax: 
query I rowsort label-764
SELECT COUNT( * ) + + 41 AS col0 FROM tab1 AS cor0
----
44

skipif mysql # not compatible
query I rowsort label-764
SELECT COUNT ( * ) + + 41 AS col0 FROM tab1 AS cor0
----
44

onlyif mysql # aggregate syntax: 
query I rowsort label-765
SELECT - 64 + - - COUNT( * ) FROM tab0 AS cor0
----
-61

skipif mysql # not compatible
query I rowsort label-765
SELECT - 64 + - - COUNT ( * ) FROM tab0 AS cor0
----
-61

query I rowsort
SELECT - col1 * + - col2 + - + col0 AS col1 FROM tab2
----
1127
3016
3811

query I rowsort
SELECT DISTINCT col1 * + col2 + + col1 FROM tab1
----
1358
300
3243

onlyif mysql # aggregate syntax: 
query I rowsort label-768
SELECT ALL 52 + MIN( ALL col1 ) AS col1 FROM tab0
----
53

skipif mysql # not compatible
query I rowsort label-768
SELECT ALL 52 + MIN ( ALL col1 ) AS col1 FROM tab0
----
53

onlyif mysql # aggregate syntax: 
query I rowsort label-769
SELECT 99 + + ( + SUM( - col0 ) ) FROM tab2 WHERE col0 IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-769
SELECT 99 + + ( + SUM ( - col0 ) ) FROM tab2 WHERE col0 IS NULL
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-770
SELECT DISTINCT MAX( - col1 ) AS col0 FROM tab2 WHERE col2 IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-770
SELECT DISTINCT MAX ( - col1 ) AS col0 FROM tab2 WHERE col2 IS NULL
----
NULL

onlyif mysql # CAST syntax: SIGNED type: DECIMAL type: 
query III rowsort label-771
SELECT * FROM tab1 WHERE NOT ( ( + col1 * + - col2 ) BETWEEN + CAST( NULL AS SIGNED ) / + CAST( col1 * 8 AS DECIMAL ) AND + col1 / ( - col1 ) )
----

skipif mysql # not compatible
query III rowsort label-771
SELECT * FROM tab1 WHERE NOT ( ( + col1 * + - col2 ) BETWEEN + CAST ( NULL AS INTEGER ) / + CAST ( col1 * 8 AS REAL ) AND + col1 / ( - col1 ) )
----

query II rowsort
SELECT 54, + col2 + - 80 AS col0 FROM tab0
----
54
-33
54
-70
54
19

query III rowsort
SELECT ALL * FROM tab2 WHERE - 59 IS NULL
----

query I rowsort
SELECT DISTINCT ( + + col2 ) FROM tab1 cor0
----
59
68
96

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-775
SELECT + - CAST( COUNT( * ) AS SIGNED ) * 11 FROM tab0 AS cor0
----
-33

skipif mysql # not compatible
query I rowsort label-775
SELECT + - CAST ( COUNT ( * ) AS INTEGER ) * 11 FROM tab0 AS cor0
----
-33

query I rowsort
SELECT - - col0 * - 17 - col1 + 99 + - 8 AS col2 FROM tab1 AS cor0
----
-1359
-1503
-790

query II rowsort
SELECT DISTINCT 58 * - 98 AS col1, 34 FROM tab0
----
-5684
34

query I rowsort
SELECT DISTINCT + col2 + + ( + - col2 ) AS col0 FROM tab1 WHERE NOT NULL <> NULL
----

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-779
SELECT - CAST( - COUNT( * ) AS SIGNED ) FROM tab2 AS cor0 CROSS JOIN tab0 AS cor1
----
9

skipif mysql # not compatible
query I rowsort label-779
SELECT - CAST ( - COUNT ( * ) AS INTEGER ) FROM tab2 AS cor0 CROSS JOIN tab0 AS cor1
----
9

query I rowsort
SELECT + col1 AS col1 FROM tab1 AS cor0 WHERE NOT NULL >= + col1
----

onlyif mysql # CAST syntax: aggregate syntax: DECIMAL type: 
query I rowsort label-781
SELECT DISTINCT + - ( CAST( NULL AS DECIMAL ) ) * - + MAX( - col2 ) AS col1 FROM tab1 AS cor0
----
NULL

skipif mysql # not compatible
query I rowsort label-781
SELECT DISTINCT + - ( CAST ( NULL AS REAL ) ) * - + MAX ( - col2 ) AS col1 FROM tab1 AS cor0
----
NULL

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-782
SELECT - 66 / + - CAST( NULL AS SIGNED ), col0 AS col2 FROM tab1 AS cor0
----
NULL
51
NULL
85
NULL
91

skipif mysql # not compatible
query II rowsort label-782
SELECT - 66 / + - CAST ( NULL AS INTEGER ), col0 AS col2 FROM tab1 AS cor0
----
NULL
51
NULL
85
NULL
91

onlyif mysql # DIV for integer division: 
query I rowsort label-783
SELECT DISTINCT col2 DIV + col1 FROM tab0 AS cor0 WHERE NOT ( NOT NULL IS NULL )
----
0
99

skipif mysql # not compatible
query I rowsort label-783
SELECT DISTINCT col2 / + col1 FROM tab0 AS cor0 WHERE NOT ( NOT NULL IS NULL )
----
0
99

onlyif mysql # aggregate syntax: 
query I rowsort label-784
SELECT 44 + - MAX( ALL col2 ) AS col0 FROM tab2 AS cor0
----
-14

skipif mysql # not compatible
query I rowsort label-784
SELECT 44 + - MAX ( ALL col2 ) AS col0 FROM tab2 AS cor0
----
-14

query I rowsort
SELECT col0 AS col1 FROM tab0 AS cor0 WHERE NOT ( NULL ) IN ( - 48 )
----

query I rowsort
SELECT col2 AS col2 FROM tab1 WHERE ( NULL ) IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-787
SELECT DISTINCT - col2 * + - CAST( NULL AS SIGNED ) / - - 66 col1 FROM tab2
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-787
SELECT DISTINCT - col2 * + - CAST ( NULL AS INTEGER ) / - - 66 col1 FROM tab2
----
NULL

query I rowsort
SELECT ALL 76 + - - 62 AS col0 FROM tab2
----
138
138
138

onlyif mysql # aggregate syntax: 
query I rowsort label-789
SELECT ALL COUNT( * ) * + 61 FROM tab1
----
183

skipif mysql # not compatible
query I rowsort label-789
SELECT ALL COUNT ( * ) * + 61 FROM tab1
----
183