sqllogictest

onlyif mysql # aggregate syntax: 
query I rowsort label-2573
SELECT - + 52 / - COUNT( * ) * - - ( + SUM( ALL - + col0 ) ) AS col2 FROM tab0 WHERE NULL <> - 41
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-2573
SELECT - + 52 / - COUNT ( * ) * - - ( + SUM ( ALL - + col0 ) ) AS col2 FROM tab0 WHERE NULL <> - 41
----
NULL

query III rowsort
SELECT * FROM tab2 AS cor0 WHERE col0 BETWEEN NULL AND + 56 * + + col2 * col1

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-3594
SELECT col0 / col1 AS col2, + 78 * 68 / - 0 AS col2 FROM tab1 AS cor0 WHERE NOT NULL > + col2 + CAST( NULL AS SIGNED )
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query II rowsort label-3594
SELECT col0 / col1 AS col2, + 78 * 68 / - 0 AS col2 FROM tab1 AS cor0 WHERE NOT NULL > + col2 + CAST ( NULL AS INTEGER )
----

query I rowsort
SELECT + 89 * 34 FROM tab0 AS cor0
----

query I rowsort
SELECT - 33 col1 FROM tab2 cor0
----
-33
-33
-33

skipif postgresql # PostgreSQL does not promote INTEGER (32-bit) results
query I rowsort
SELECT + col2 FROM tab0 AS cor0 WHERE NOT col1 * col2 * - + 86 * - 70 * - - 93 * - + col2 / + 33 > col0 + - col0
----
10
47
99

onlyif mysql # aggregate syntax: 
query I rowsort label-1319
SELECT + COUNT( * ) / + COUNT( * ) * + MAX( + col0 ) AS col2 FROM tab2 AS cor0 WHERE NOT NULL IS NULL
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-1319
SELECT + COUNT ( * ) / + COUNT ( * ) * + MAX ( + col0 ) AS col2 FROM tab2 AS cor0 WHERE NOT NULL IS NULL
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-1320

SELECT DISTINCT + col2 * + col2 * - col2 * col2 * + col2 DIV + col2 + col0 AS col2 FROM tab0
----
-4879666
-96059504
-9913

skipif mysql # not compatible
skipif postgresql # PostgreSQL does not promote INTEGER (32-bit) results
query I rowsort label-2475
SELECT DISTINCT + col2 * + col2 * - col2 * col2 * + col2 / + col2 + col0 AS col2 FROM tab0
----
-4879666
-96059504
-9913

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

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort
SELECT ALL + 28 FROM tab1 WHERE NULL BETWEEN ( 58 / - 0 + - col2 ) AND NULL
----

query I rowsort
SELECT DISTINCT col1 + col2 * - col0 AS col1 FROM tab2
----

4288
5025

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

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort
SELECT DISTINCT 40 + + 78 / - 0 FROM tab0 WHERE NOT NULL IS NULL
----

query I rowsort
SELECT + ( + 62 ) * - col2 * - col2 + + + col1 FROM tab1
----

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

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort
SELECT 50 / + + 0 AS col2 FROM tab0 cor0 WHERE + 79 <= NULL
----

query I rowsort
SELECT - - 3 + - + col0 + 61 - col1 + - col1 * 95 FROM tab1 AS cor0
----

onlyif mysql # aggregate syntax: 
query I rowsort label-4186
SELECT DISTINCT - ( - + 95 ) + - COUNT( * ) AS col0 FROM tab1 WHERE NOT + col1 / - 26 * col0 + 58 / + 0 / - col2 - + col1 < NULL
----
95

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-4186
SELECT DISTINCT - ( - + 95 ) + - COUNT ( * ) AS col0 FROM tab1 WHERE NOT + col1 / - 26 * col0 + 58 / + 0 / - col2 - + col1 < NULL
----
95

query I rowsort
SELECT DISTINCT col1 * + col2 + + ( + - 65 ) * + col0 AS col2 FROM tab1

SELECT col2 * + + col0 * col2 * col0 * + - col2 DIV - + col2 AS col0 FROM tab0 AS cor0
----
497025
756900
92217609

skipif mysql # not compatible
skipif postgresql # PostgreSQL does not promote INTEGER (32-bit) results
query I rowsort label-3738
SELECT col2 * + + col0 * col2 * col0 * + - col2 / - + col2 AS col0 FROM tab0 AS cor0
----
497025
756900
92217609

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-9346
SELECT DISTINCT 95 / + COUNT( * ) * - CAST( MIN( ALL - col0 ) AS SIGNED ) AS col1 FROM tab2 AS cor0 WHERE NOT NULL IS NULL
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-9346
SELECT DISTINCT 95 / + COUNT ( * ) * - CAST ( MIN ( ALL - col0 ) AS INTEGER ) AS col1 FROM tab2 AS cor0 WHERE NOT NULL IS NULL
----
NULL

query III rowsort
SELECT * FROM tab0 AS cor0 WHERE - 0 IS NULL

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-7694
SELECT - col0 + - col0 + - 50 / + + 0 + - ( 4 ) FROM tab2 WHERE NULL IS NULL AND NOT ( NULL ) <> - 60 * - CAST( NULL AS SIGNED )
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-7694
SELECT - col0 + - col0 + - 50 / + + 0 + - ( 4 ) FROM tab2 WHERE NULL IS NULL AND NOT ( NULL ) <> - 60 * - CAST ( NULL AS INTEGER )
----

query I rowsort
SELECT ALL 64 - - - col0 AS col0 FROM tab0
----

onlyif mysql # CAST syntax: SIGNED type: 
query III rowsort label-7426
SELECT ALL * FROM tab0 cor0 WHERE NOT - 66 + + 72 - + col1 + - col2 * + + col0 * - CAST( 93 AS SIGNED ) * + + col2 * - col0 * - col1 / - 15 IS NULL
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

skipif mysql # not compatible
skipif postgresql # PostgreSQL does not promote INTEGER (32-bit) results
query III rowsort label-7426
SELECT ALL * FROM tab0 cor0 WHERE NOT - 66 + + 72 - + col1 + - col2 * + + col0 * - CAST ( 93 AS INTEGER ) * + + col2 * - col0 * - col1 / - 15 IS NULL
----
9 values hashing to c4b42765dff94eaaa46040e537fb43b7

query I rowsort
SELECT - - col2 * + - col2 FROM tab2 cor0

query I rowsort
SELECT DISTINCT + col2 + + ( - 35 ) AS col1 FROM tab0 cor0
----
-25
12
64

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query IIIIII rowsort
SELECT * FROM tab1 AS cor0 CROSS JOIN tab1 AS cor1 WHERE NOT NULL = 38 / 0
----

query II rowsort
SELECT 84 AS col0, + col0 AS col1 FROM tab2
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-4077
SELECT ALL - 30 / - 0 * - AVG ( + - CAST( NULL AS SIGNED ) ) FROM tab1
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-4077
SELECT ALL - 30 / - 0 * - AVG ( + - CAST ( NULL AS INTEGER ) ) FROM tab1
----
NULL

query I rowsort
SELECT + + col0 FROM tab2 WHERE NOT NULL > NULL

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-324
SELECT DISTINCT + col2 FROM tab0 AS cor0 WHERE NOT ( + + 14 / + 0 * + 90 - + 84 / + 67 ) < ( NULL ) AND NOT CAST( col2 AS SIGNED ) = NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-324
SELECT DISTINCT + col2 FROM tab0 AS cor0 WHERE NOT ( + + 14 / + 0 * + 90 - + 84 / + 67 ) < ( NULL ) AND NOT CAST ( col2 AS INTEGER ) = NULL
----

query I rowsort
SELECT ALL + - 42 * - + 27 * - ( col0 ) AS col1 FROM tab0 AS cor0
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-178
SELECT ( ( col1 ) ) * + - col1 + - - 85 / - - CAST( 0 AS SIGNED ) - - 13 / ( + 97 ) FROM tab2 WHERE - - 68 IS NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-178
SELECT ( ( col1 ) ) * + - col1 + - - 85 / - - CAST ( 0 AS INTEGER ) - - 13 / ( + 97 ) FROM tab2 WHERE - - 68 IS NULL
----

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

onlyif mysql # aggregate syntax: 
query I rowsort label-9867
SELECT ALL COUNT( - col2 ) * + 10 / - + COUNT( * ) * + + SUM( + - col2 ) AS col2 FROM tab2 AS cor0 WHERE NULL IS NOT NULL
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-9867
SELECT ALL COUNT ( - col2 ) * + 10 / - + COUNT ( * ) * + + SUM ( + - col2 ) AS col2 FROM tab2 AS cor0 WHERE NULL IS NOT NULL
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-9868

skipif mysql # not compatible
query I rowsort label-6860
SELECT DISTINCT + 13 * + + COUNT ( * ) FROM tab1
----
39

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query IIIIII rowsort
SELECT ALL * FROM tab0, tab1 AS cor0 WHERE - + 22 / - 0 NOT BETWEEN NULL AND NULL
----

onlyif mysql # aggregate syntax: DIV for integer division: 
query I rowsort label-6862
SELECT COUNT( * ) DIV + + COUNT( * ) col0 FROM tab2

query I rowsort
SELECT DISTINCT - + ( + - col1 ) AS col2 FROM tab0 cor0
----
1
21
81

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query II rowsort
SELECT 55 / 0 AS col1, + col1 * col1 * + - col0 AS col2 FROM tab2 cor0 WHERE NOT NULL >= NULL
----

query III rowsort
SELECT * FROM tab0 AS cor0 WHERE NOT col2 BETWEEN NULL AND + + col0
----

46
2601
64
5929
75
4489

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query II rowsort
SELECT ALL col2 * + + 68 AS col2, - 37 / - 0 AS col2 FROM tab2 WHERE NOT NULL > + col0 OR NULL = ( NULL )
----

onlyif mysql # aggregate syntax: 
query I rowsort label-4731
SELECT ALL + COUNT( * ) FROM tab1 WHERE NOT + + col0 > + - 75 + + col1

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

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort
SELECT ALL 0 / 0 AS col2 FROM tab1 AS cor0 WHERE NOT ( NOT NULL IS NOT NULL )
----

query I rowsort
SELECT DISTINCT - - col0 * + - col2 AS col0 FROM tab1 AS cor0
----

skipif mysql # not compatible
query I rowsort label-979
SELECT ALL MAX ( 0 ) FROM tab0 AS cor0
----
0

skipif postgresql # PostgreSQL does not promote INTEGER (32-bit) results
query III rowsort
SELECT DISTINCT * FROM tab0 AS cor0 WHERE NOT col2 NOT IN ( 14, - 66 * - 55 / + col1 * col2 * + col0 * col0 * + col0 + + col0, + col2 + - col0 )
----

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

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-4461
SELECT - - CAST( COUNT( * ) AS SIGNED ) / - COUNT( * ) / - AVG ( ALL - col1 ) + MAX( DISTINCT col2 ) AS col1 FROM tab0 WHERE NOT + ( + col2 ) BETWEEN NULL AND + CAST( NULL AS SIGNED )
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-4461
SELECT - - CAST ( COUNT ( * ) AS INTEGER ) / - COUNT ( * ) / - AVG ( ALL - col1 ) + MAX ( DISTINCT col2 ) AS col1 FROM tab0 WHERE NOT + ( + col2 ) BETWEEN NULL AND + CAST ( NULL AS INTEGER )
----
NULL

query III rowsort
SELECT * FROM tab1 AS cor0 WHERE NOT col1 * - col1 > NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-2429
SELECT ALL COUNT( col0 ) / - - COUNT( * ) * - + SUM( DISTINCT - ( col1 ) ) + 13 AS col1 FROM tab0 WHERE NOT - col1 IS NOT NULL
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-2429
SELECT ALL COUNT ( col0 ) / - - COUNT ( * ) * - + SUM ( DISTINCT - ( col1 ) ) + 13 AS col1 FROM tab0 WHERE NOT - col1 IS NOT NULL
----
NULL

onlyif mysql # aggregate syntax: DIV for integer division: 
query I rowsort label-2430

query II rowsort label-8042
SELECT DISTINCT 0 AS col0, - 52 / - 0 * + col2 * + CAST( NULL AS SIGNED ) + 65 FROM tab1
----
0
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query II rowsort label-8042
SELECT DISTINCT 0 AS col0, - 52 / - 0 * + col2 * + CAST ( NULL AS INTEGER ) + 65 FROM tab1
----
0
NULL

onlyif mysql # DIV for integer division: 

26
78

query III rowsort
SELECT * FROM tab2 AS cor0 WHERE ( NULL ) NOT IN ( - 76, col0 )
----

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query III rowsort
SELECT DISTINCT * FROM tab0 cor0 WHERE NOT ( NULL ) BETWEEN ( 25 * 22 / ( + - 0 ) + 46 ) AND col0 + col2
----

onlyif mysql # aggregate syntax: 
query I rowsort label-859
SELECT - 59 + - 85 * + COUNT( * ) AS col0 FROM tab1 AS cor0

-167517
-25873

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

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query III rowsort
SELECT * FROM tab0 AS cor0 WHERE ( NOT - 4 / + + 0 > NULL )
----

query I rowsort
SELECT ALL 87 FROM tab0 AS cor0 WHERE NOT NULL IS NOT NULL
----

skipif mysql # not compatible
query I rowsort label-302
SELECT COUNT ( - 93 ) + + 27 FROM tab2
----
30

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort
SELECT DISTINCT + + col0 * + + col1 / + + 66 FROM tab0 WHERE NULL = + col0 + - 85 / 0
----

query III rowsort
SELECT DISTINCT * FROM tab1 AS cor0 WHERE NOT ( NOT - col2 + + 88 IS NULL )
----

SELECT ALL - ( + 0 ) * - 48 + - 49 + + + col1 * + 27 * - - ( - 93 ) * - + 49 * - 87 * + col0 DIV - + col0 AS col1 FROM tab1 AS cor0
----
149861453
503106422
53521916

skipif mysql # not compatible
skipif postgresql # PostgreSQL does not promote INTEGER (32-bit) results
query I rowsort label-110
SELECT ALL - ( + 0 ) * - 48 + - 49 + + + col1 * + 27 * - - ( - 93 ) * - + 49 * - 87 * + col0 / - + col0 AS col1 FROM tab1 AS cor0
----
149861453
503106422
53521916

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-8432
SELECT ALL + COUNT ( * ) * + CAST ( NULL AS INTEGER ) col2 FROM tab1 AS cor0
----
NULL

skipif postgresql # PostgreSQL does not promote INTEGER (32-bit) results
query III rowsort
SELECT * FROM tab2 AS cor0 WHERE + col0 * + col1 * 98 * ( col0 ) * - + 86 / - col2 > - - col1 + + 92 + - 69
----
9 values hashing to 75c998aa53ac83218cbf2feb962d0a49

onlyif mysql # aggregate syntax: 
query I rowsort label-8434

----

skipif mysql # not compatible
query III rowsort label-8633
SELECT ALL * FROM tab1 AS cor0 WHERE col0 * + ( CAST ( + 53 AS INTEGER ) ) < col1 * - - ( + col2 ) + + 26
----

skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query III rowsort
SELECT ALL * FROM tab0 AS cor0 WHERE NULL NOT BETWEEN + 0 * col0 AND + ( 66 ) / + 0
----

onlyif mysql # aggregate syntax: 
query I rowsort label-8635
SELECT + MAX( ALL - col2 ) FROM tab0 AS cor0

onlyif mysql # aggregate syntax: 
query I rowsort label-8894
SELECT ALL 7 / + - COUNT( * ) * + + MIN( + ( + 87 ) ) AS col1 FROM tab2 cor0 WHERE NOT NULL >= NULL
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-8894
SELECT ALL 7 / + - COUNT ( * ) * + + MIN ( + ( + 87 ) ) AS col1 FROM tab2 cor0 WHERE NOT NULL >= NULL
----
NULL

query I rowsort
SELECT DISTINCT + - ( + 88 ) * col2 AS col2 FROM tab1 AS cor0

onlyif mysql # aggregate syntax: 
query I rowsort label-6055
SELECT ALL 8 / - COUNT( * ) * MAX( ALL 11 ) * MIN( DISTINCT + col0 ) AS col2 FROM tab0 cor0 WHERE - col1 * + + col1 IN ( col0 )
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL handles NULL in DIV/0 by differently
query I rowsort label-6055
SELECT ALL 8 / - COUNT ( * ) * MAX ( ALL 11 ) * MIN ( DISTINCT + col0 ) AS col2 FROM tab0 cor0 WHERE - col1 * + + col1 IN ( col0 )
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-6056

24

query I rowsort
SELECT DISTINCT 98 FROM tab1 AS cor0 GROUP BY cor0.col1
----
98

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - COALESCE ( - 86, + cor0.col1, cor0.col1, - cor0.col0 ) AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col0
----
86

query I rowsort
SELECT DISTINCT COALESCE ( cor0.col0, cor0.col0 ) AS col1 FROM tab1 cor0 GROUP BY cor0.col0
----
22
28
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + 33 * - COALESCE ( - 86, tab1.col2 ) + + col1 FROM tab1 GROUP BY tab1.col1
----
2844
2882
2895

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + COALESCE ( - cor0.col1, cor0.col1, 63, - cor0.col2 ) * - cor0.col1 AS col1 FROM tab0 cor0 GROUP BY cor0.col0, col1
----
0
0
6561

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-4217
SELECT DISTINCT + ( + CASE + 64 WHEN cor0.col0 THEN NULL WHEN 77 THEN cor0.col2 END * cor0.col0 ) + + CAST( NULL AS SIGNED ) FROM tab0 AS cor0 GROUP BY col0
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-4217
SELECT DISTINCT + ( + CASE + 64 WHEN cor0.col0 THEN NULL WHEN 77 THEN cor0.col2 END * cor0.col0 ) + + CAST ( NULL AS INTEGER ) FROM tab0 AS cor0 GROUP BY col0
----
NULL

query I rowsort
SELECT ALL tab2.col0 AS col1 FROM tab2 GROUP BY tab2.col0 HAVING NOT ( NULL ) IS NOT NULL

query I rowsort
SELECT ALL 98 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col0
----
98
98
98

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + - COALESCE ( 59, - cor0.col1 ) * 64 FROM tab2, tab2 AS cor0 GROUP BY tab2.col2
----
-3776
-3776
-3776

query I rowsort
SELECT cor0.col1 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col1, cor0.col2
----
44
57
6

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT cor0.col1 + - COALESCE ( + 57, + col2 ) FROM tab1 AS cor0 GROUP BY col1
----
-13
-51
0

query I rowsort
SELECT ALL COALESCE ( - 12, - cor0.col1, + cor0.col1 ) * + cor0.col1 * + 58 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col1
----
-30624
-39672
-4176

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( - 88, + cor0.col0, cor0.col1 ) + 51 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
----
-37
-37
-37

query I rowsort label-4544
SELECT - 58 / + cor1.col0 + ( 95 ) FROM tab2 cor0 CROSS JOIN tab1 AS cor1 GROUP BY cor1.col0
----
93
93
95

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( - 86, + cor0.col1, cor0.col1, - cor0.col0 ) + cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col0
----
-3
-43
-60

query I rowsort
SELECT DISTINCT - cor0.col0 FROM tab1 cor0 GROUP BY cor0.col2, cor0.col0
----
-22
-28
-82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + COALESCE ( COALESCE ( - 86, tab1.col2 ), - tab1.col0, tab1.col1 ) AS col1 FROM tab1 GROUP BY tab1.col1
----
-86
-86
-86

query I rowsort
SELECT DISTINCT + cor0.col1 * - cor0.col1 FROM tab1 AS cor0 GROUP BY cor0.col1
----
-1936
-3249
-36

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - COALESCE ( - 4, - cor0.col0 ) * cor0.col2 AS col1 FROM tab1 cor0 GROUP BY cor0.col1, col2, cor0.col1
----
180
284
32

query I rowsort
SELECT + 16 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col1
----
16
16
16

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( + 55, - tab0.col1, - tab0.col1, tab0.col0 ) AS col0 FROM tab0 GROUP BY tab0.col1
----
55
55

query I rowsort

query I rowsort
SELECT 83 AS col1 FROM tab1 cor0 GROUP BY cor0.col0
----
83
83
83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + COALESCE ( 99, cor0.col2, cor0.col2 ) AS col1 FROM tab2 AS cor0 GROUP BY cor0.col1, cor0.col0
----
99
99
99

query I rowsort
SELECT ALL cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col2, cor0.col0
----
24
38
79

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( - 26, cor0.col2 ) AS col1 FROM tab0 AS cor0 GROUP BY cor0.col1
----
-26

query I rowsort
SELECT ALL + cor0.col0 FROM tab0 AS cor0 GROUP BY col0, cor0.col2, cor0.col2

SELECT - 38 + - tab1.col1 - tab1.col1 DIV COALESCE ( + 20, - tab1.col0 ) FROM tab1 GROUP BY tab1.col1
----
-44
-84
-97

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-5123
SELECT - 38 + - tab1.col1 - tab1.col1 / COALESCE ( + 20, - tab1.col0 ) FROM tab1 GROUP BY tab1.col1
----
-44
-84
-97

query I rowsort
SELECT - 46 AS col0 FROM tab1, tab0 AS cor0 GROUP BY tab1.col1
----
-46
-46
-46

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - COALESCE ( - 11, cor0.col0, + cor0.col0 ) FROM tab1, tab0 AS cor0 GROUP BY tab1.col1
----
11
11
11

query I rowsort
SELECT 10 * - 57 AS col2 FROM tab2 cor0 GROUP BY cor0.col0
----
-570
-570
-570

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( + 93, cor0.col0 ) AS col0 FROM tab1 AS cor0 GROUP BY col2
----
93

query I rowsort
SELECT DISTINCT - 30 FROM tab0 AS cor0 GROUP BY cor0.col0

query I rowsort label-5683
SELECT DISTINCT - cor0.col0 DIV - 73 + COALESCE ( 83, cor0.col1 ) FROM tab1 cor0 GROUP BY cor0.col0
----
83
84

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-5683
SELECT DISTINCT - cor0.col0 / - 73 + COALESCE ( 83, cor0.col1 ) FROM tab1 cor0 GROUP BY cor0.col0
----
83
84

skipif postgresql # PostgreSQL requires AS when renaming output columns

query I rowsort
SELECT cor0.col2 AS col0 FROM tab2, tab2 AS cor0 GROUP BY cor0.col2
----
58
79
87

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + COALESCE ( + 98, cor0.col2, + col1 ) FROM tab2 AS cor0 GROUP BY cor0.col1
----
98

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort

query I rowsort
SELECT cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col2, cor0.col1
----
24
38
79

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( 85, + cor0.col2, - cor0.col2, cor0.col1 ) * + col2 FROM tab0 cor0 GROUP BY cor0.col2
----
2040
3230
6715

query I rowsort
SELECT ALL 17 + 3 AS col1 FROM tab0 AS cor0 GROUP BY col2
----
20
20
20

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( + 75, cor0.col0 ) AS col2 FROM tab2 AS cor0 GROUP BY cor0.col1, cor0.col2
----
75

query I rowsort
SELECT 22 * col1 FROM tab0 AS cor0 GROUP BY cor0.col1

query I rowsort
SELECT ALL - 14 * - cor0.col0 FROM tab1 cor0 GROUP BY cor0.col0, col2
----
1148
308
392

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + COALESCE ( 29, + cor0.col0 ) FROM tab2 AS cor0 GROUP BY cor0.col2
----
29
29
29

-86

query I rowsort
SELECT DISTINCT 56 FROM tab0 AS cor0 GROUP BY cor0.col0, col1
----
56

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL CASE + 8 WHEN 76 THEN - cor0.col1 * + 8 WHEN 9 THEN NULL ELSE NULL END FROM tab0 AS cor0 GROUP BY cor0.col2, col0
----
NULL
NULL
NULL

query I rowsort
SELECT ALL col1 col0 FROM tab1 AS cor0 GROUP BY cor0.col0, cor0.col1
----
44
57
6

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( 5, - 11, cor0.col0 ) FROM tab1 AS cor0 GROUP BY cor0.col1
----
5
5
5

query I rowsort
SELECT + cor0.col0 FROM tab0 AS cor0 GROUP BY col2, cor0.col0
----
26
43
83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( + 6, cor0.col2 * - ( cor0.col0 ) ) FROM tab2 AS cor0 GROUP BY cor0.col2
----
6
6
6

query I rowsort
SELECT cor0.col1 col0 FROM tab2 AS cor0 GROUP BY cor0.col2, cor0.col1
----
41
59
61

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( 30, cor0.col1 ) AS col2 FROM tab1 cor0 GROUP BY cor0.col2, cor0.col0
----
30
30
30

32

query I rowsort
SELECT DISTINCT + - 95 FROM tab2, tab0 AS cor0 GROUP BY cor0.col0
----
-95

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT 16 + + cor0.col1 - COALESCE ( 88, - col0 ) * + 76 FROM tab0 AS cor0 GROUP BY col1
----
-6591
-6672

query I rowsort

query I rowsort
SELECT ALL + cor0.col0 col1 FROM tab0 cor0 GROUP BY col0
----
26
43
83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - COALESCE ( 99, - cor0.col2 + + cor0.col1 ) FROM tab0 AS cor0 GROUP BY cor0.col0
----
-99
-99
-99

query I rowsort
SELECT - 50 AS col2 FROM tab0, tab0 cor0 GROUP BY cor0.col1
----
-50
-50

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT cor0.col0 * COALESCE ( + 81, + cor0.col2 ) + 66 FROM tab2 AS cor0 GROUP BY cor0.col0
----
1281
7437
7518

skipif mysql # not compatible
query I rowsort label-7316
SELECT DISTINCT CAST ( NULL AS INTEGER ) AS col2 FROM tab1 AS cor0 GROUP BY cor0.col1
----
NULL

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( + 12, + cor0.col0 * + cor0.col1 ) AS col1 FROM tab0 AS cor0 GROUP BY col1
----
12

query I rowsort
SELECT DISTINCT + 92 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col0

query I rowsort
SELECT 35 FROM tab2 cor0 GROUP BY cor0.col0, cor0.col2
----
35
35
35

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + COALESCE ( + 49, cor0.col1 ) + + cor0.col0 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col0
----
132
75
92

query I rowsort
SELECT DISTINCT col0 AS col0 FROM tab1 cor0 GROUP BY cor0.col0
----
22
28
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( + 5, cor0.col2, + col0 ) AS col0 FROM tab0 AS cor0 GROUP BY cor0.col0
----
5

query I rowsort
SELECT - col1 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col1

query I rowsort
SELECT + cor0.col1 + 43 FROM tab2 cor0 GROUP BY cor0.col1
----
102
104
84

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( 3, - cor0.col1 * + cor0.col1, 76, + cor0.col0 ) FROM tab1 AS cor0 GROUP BY cor0.col2
----
3
3
3

query I rowsort
SELECT ALL 28 + cor0.col2 AS col2 FROM tab2, tab1 AS cor0 GROUP BY cor0.col2
----
36
73
99

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + COALESCE ( + 83, cor0.col2, cor0.col1, - cor0.col0 * - col2 + + cor0.col0 ) FROM tab1 AS cor0 GROUP BY cor0.col0
----
83
83
83

query I rowsort
SELECT - 57 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col1
----
-57
-57

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - cor0.col1 + COALESCE ( 61, cor0.col2 ) * 90 AS col1 FROM tab0 cor0 GROUP BY cor0.col1, cor0.col0, cor0.col1
----
5409
5490
5490

756

query I rowsort
SELECT DISTINCT - 38 * 15 FROM tab1 AS cor0 GROUP BY cor0.col1
----
-570

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + COALESCE ( 76, cor0.col0 ) FROM tab2 cor0 GROUP BY cor0.col1
----
76

query I rowsort
SELECT + 68 * - cor0.col1 + + 52 FROM tab0, tab2 AS cor0 GROUP BY cor0.col1

query I rowsort
SELECT cor0.col1 - 38 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col1
----
21
23
3

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + COALESCE ( 75, cor0.col2, cor0.col0 * + cor0.col1 ) + + cor0.col1 FROM tab2 AS cor0 GROUP BY cor0.col1
----
116
134
136

query I rowsort
SELECT cor0.col0 AS col1 FROM tab2, tab0 AS cor0 GROUP BY cor0.col0
----
26
43
83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - COALESCE ( + 60, + cor0.col2 ) AS col2 FROM tab0 AS cor0 GROUP BY cor0.col0
----
-60

query I rowsort
SELECT 79 FROM tab2 AS cor0 GROUP BY cor0.col2

query I rowsort
SELECT - cor0.col0 col2 FROM tab0, tab0 cor0 GROUP BY cor0.col0
----
-26
-43
-83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( - 98, col0, cor0.col1 + - 23 ) FROM tab2 AS cor0 GROUP BY cor0.col0
----
-98

query I rowsort
SELECT DISTINCT - 50 FROM tab2 AS cor0 GROUP BY cor0.col0

query I rowsort
SELECT DISTINCT - + 40 + + cor0.col1 AS col1 FROM tab1, tab1 AS cor0 GROUP BY cor0.col1
----
-34
17
4

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - COALESCE ( 22, - tab0.col0, - cor0.col1 ) FROM tab0, tab2 AS cor0 GROUP BY tab0.col1
----
-22
-22

query I rowsort

query I rowsort
SELECT ALL - 22 + - col1 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col1
----
-63
-81
-83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT cor0.col2 * COALESCE ( + 40, col1 ) FROM tab2 AS cor0 GROUP BY cor0.col2
----
2320
3160
3480

onlyif mysql # CAST syntax: SIGNED type: DIV for integer division: 
query I rowsort label-9102
SELECT DISTINCT COALESCE ( - 82, - cor0.col0, - CAST( NULL AS SIGNED ) ) DIV - 70 FROM tab0 AS cor0 GROUP BY cor0.col2
----
1

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-9102
SELECT DISTINCT COALESCE ( - 82, - cor0.col0, - CAST ( NULL AS INTEGER ) ) / - 70 FROM tab0 AS cor0 GROUP BY cor0.col2
----
1

query I rowsort
SELECT COALESCE ( - cor0.col1, cor0.col1 ) * + 31 FROM tab1 AS cor0 GROUP BY cor0.col1

query I rowsort
SELECT ALL ( + cor0.col0 ) * - 49 FROM tab1 AS cor0 GROUP BY col1, cor0.col0
----
-1078
-1372
-4018

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + COALESCE ( 50, - cor0.col0 ) FROM tab0 AS cor0 GROUP BY cor0.col1
----
50

query I rowsort
SELECT DISTINCT 82 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col2

query I rowsort
SELECT 48 + + cor0.col1 FROM tab1 AS cor0 GROUP BY cor0.col1
----
105
54
92

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + ( + COALESCE ( 27, - cor0.col0 ) ) FROM tab2 AS cor0 GROUP BY cor0.col1
----
27
27
27

query I rowsort
SELECT cor0.col0 * + cor0.col2 * 3 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col0
----
17466
3780
528

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( + cor0.col0, 72, + 29 * cor0.col2 ) AS col0 FROM tab0 AS cor0 GROUP BY cor0.col0
----
26
43
83

query I rowsort
SELECT 38 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
----
38
38
38

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT cor0.col2 * COALESCE ( 65, cor0.col0 + + cor0.col1 ) FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col2
----
1560
2470
5135

query I rowsort
SELECT DISTINCT - cor0.col0 AS col2 FROM tab1 AS cor0 GROUP BY col0, cor0.col1
----
-22
-28
-82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + COALESCE ( 74, - cor0.col2, NULLIF ( cor0.col1, cor0.col0 ) ) FROM tab2 AS cor0 GROUP BY cor0.col2
----
74
74
74

58

query I rowsort
SELECT DISTINCT 20 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col2
----
20

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + COALESCE ( + 3, 40 * cor0.col0 ) AS col1 FROM tab1 AS cor0 GROUP BY cor0.col2
----
3
3
3

query I rowsort
SELECT 67 AS col0 FROM tab1 cor0 CROSS JOIN tab1 AS cor1 GROUP BY cor0.col0
----
67
67
67

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + COALESCE ( 29, + tab1.col1 ) AS col0 FROM tab1, tab0 AS cor0, tab2 AS cor1 GROUP BY cor1.col2
----
29

query I rowsort
SELECT ALL cor0.col0 FROM tab2 cor0 GROUP BY cor0.col0, cor0.col1

query I rowsort
SELECT cor0.col0 FROM tab2 AS cor0 GROUP BY col1, col0, cor0.col0
----
15
91
92

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + COALESCE ( - 85, + cor0.col2 + 58 ) FROM tab2 AS cor0 GROUP BY cor0.col1
----
-85

query I rowsort
SELECT cor1.col0 AS col2 FROM tab2 AS cor0 CROSS JOIN tab1 cor1 GROUP BY cor1.col0, cor1.col1

query I rowsort
SELECT ALL - cor0.col1 AS col1 FROM tab2 AS cor0 GROUP BY col1 HAVING NOT ( cor0.col1 ) IS NULL
----
-41
-59
-61

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - + COALESCE ( - 95, + tab0.col0 ) AS col1 FROM tab0 GROUP BY tab0.col2
----
95

query I rowsort
SELECT DISTINCT + 4 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col0

query I rowsort label-549
SELECT COALESCE ( + 1, cor0.col0 ) + - CAST( NULL AS DECIMAL ) FROM tab1, tab0 AS cor0, tab1 AS cor1 GROUP BY cor0.col1
----
NULL
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-549
SELECT COALESCE ( + 1, cor0.col0 ) + - CAST ( NULL AS REAL ) FROM tab1, tab0 AS cor0, tab1 AS cor1 GROUP BY cor0.col1
----
NULL
NULL

query I rowsort

query I rowsort
SELECT ALL 47 FROM tab2, tab2 AS cor0 GROUP BY cor0.col0
----
47
47
47

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + COALESCE ( 89, cor0.col1 * + cor0.col1 ) FROM tab0 cor0 GROUP BY cor0.col2, cor0.col2, cor0.col0
----
89
89
89

query I rowsort
SELECT DISTINCT + cor0.col0 * - 69 col0 FROM tab2, tab1 AS cor0, tab0 AS cor1 GROUP BY cor0.col0
----
-1518
-1932
-5658

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - COALESCE ( - COALESCE ( + col0, tab1.col0 ), 76, + col1 ) AS col1 FROM tab1 GROUP BY col0
----
22
28
82

query I rowsort
SELECT + - 27 AS col1 FROM tab2 GROUP BY tab2.col1
----
-27
-27
-27

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - NULLIF ( + col2, cor0.col2 ) * - COALESCE ( 78, + cor0.col1 ) FROM tab0 AS cor0 GROUP BY cor0.col2
----
NULL
NULL
NULL

query I rowsort label-932
SELECT ALL col1 / 39 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col1
----
0
1
1

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - CASE - cor0.col2 WHEN cor0.col2 THEN col2 ELSE cor0.col2 END col2 FROM tab1 cor0 GROUP BY cor0.col2
----
-45
-71
-8

query I rowsort
SELECT DISTINCT cor0.col1 + cor0.col1 FROM tab2 cor0 GROUP BY col2, col0, cor0.col1
----
118
122
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - COALESCE ( - COALESCE ( 69, col2, + 41, cor0.col1 ), - cor0.col2, 80 ) * cor0.col0 + 76 FROM tab0 cor0 GROUP BY cor0.col2, cor0.col0
----
1870
3043
5803

query I rowsort
SELECT DISTINCT - 94 + - tab0.col2 FROM tab0 GROUP BY tab0.col2
----
-118
-132
-173

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - COALESCE ( + COALESCE ( - 21, tab1.col0 ), + cor0.col0 ) * - cor0.col2 FROM tab1, tab2 AS cor0 GROUP BY cor0.col2
----
-1218
-1659
-1827

query I rowsort
SELECT ALL 14 * - COALESCE ( - 87, tab0.col2 ) AS col2 FROM tab0 GROUP BY tab0.col2
----
1218
1218
1218

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT CASE - 75 WHEN - 96 THEN - cor0.col1 * - ( cor0.col0 ) WHEN cor0.col0 THEN NULL END FROM tab1 AS cor0 GROUP BY cor0.col0
----
NULL
NULL
NULL

query I rowsort
SELECT ALL - 42 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col1
----
-42
-42

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL COALESCE ( 72, + cor0.col2 + - 8 ) FROM tab1 cor0 CROSS JOIN tab0 AS cor1 GROUP BY cor0.col0
----
72
72
72

query I rowsort
SELECT ( - cor0.col1 ) + + 59 * + cor0.col1 + 1 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col1
----
2553
3307
349

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( + cor0.col1, 84, cor0.col0 + cor0.col2 ) * - 62 AS col0 FROM tab2 cor0 GROUP BY cor0.col1
----
-2542
-3658
-3782

query I rowsort
SELECT ALL 35 AS col0 FROM tab1 AS cor0 GROUP BY col2
----
35
35
35

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - + COALESCE ( + 64, + col2 ) + + tab0.col0 FROM tab0 GROUP BY tab0.col0
----
-21
-38
19

query I rowsort
SELECT + 3 FROM tab2, tab1 AS cor0 GROUP BY tab2.col0
----
3
3
3

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( + 55, - tab0.col2 + + tab0.col2 ) FROM tab0 GROUP BY tab0.col1
----
55
55

query I rowsort

query I rowsort
SELECT + cor0.col2 FROM tab1, tab1 AS cor0, tab1 AS cor1 GROUP BY cor0.col2
----
45
71
8

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - COALESCE ( + 57, + cor0.col2 * cor0.col1 ) FROM tab0 AS cor0 GROUP BY cor0.col1
----
-57
-57

query I rowsort

query I rowsort
SELECT + + cor0.col2 * cor0.col2 + - 4 FROM tab1, tab0 cor0 GROUP BY cor0.col2
----
1440
572
6237

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + COALESCE ( 47, - 49 * cor0.col1, col0 * cor0.col1, + col2 + cor0.col0 * - cor0.col1 ) FROM tab0 AS cor0 GROUP BY cor0.col0
----
47
47
47

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT - - 7 col2 FROM tab0 GROUP BY col1
----
7
7

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( - 22, col2 ) FROM tab2 GROUP BY col1
----
-22
-22
-22

query I rowsort
SELECT + 80 FROM tab1 AS cor0 CROSS JOIN tab1 AS cor1 GROUP BY cor1.col2
----
80
80
80

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - CASE - cor0.col1 WHEN COALESCE ( + 63, cor0.col2 * col2 ) + cor0.col1 THEN cor0.col1 END AS col1 FROM tab1 AS cor0 GROUP BY cor0.col1
----
NULL

query I rowsort
SELECT - 40 FROM tab1 AS cor0 CROSS JOIN tab0 AS cor1 GROUP BY cor0.col1

SELECT ALL COALESCE ( 57, - col2 DIV col0 + + ( 49 ) * cor0.col1 ) AS col0 FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col0
----
57
57
57

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-2339
SELECT ALL COALESCE ( 57, - col2 / col0 + + ( 49 ) * cor0.col1 ) AS col0 FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col0
----
57
57
57

query I rowsort label-2404
SELECT DISTINCT - cor0.col0 DIV - 73 + COALESCE ( 83, + cor0.col0 + + cor0.col2, cor0.col2 * - cor0.col0 - - cor0.col2 ) FROM tab1 cor0 GROUP BY cor0.col0
----
83
84

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-2404
SELECT DISTINCT - cor0.col0 / - 73 + COALESCE ( 83, + cor0.col0 + + cor0.col2, cor0.col2 * - cor0.col0 - - cor0.col2 ) FROM tab1 cor0 GROUP BY cor0.col0
----
83
84

query I rowsort

query I rowsort label-2446
SELECT - 91 / 55 + + cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col0
----
25
42
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL COALESCE ( - 13, + cor1.col2, - cor1.col2 ) FROM tab0 AS cor0 CROSS JOIN tab0 AS cor1 GROUP BY cor1.col1
----
-13
-13

query I rowsort

onlyif mysql # DIV for integer division: 
query I rowsort label-2470
SELECT DISTINCT + COALESCE ( + 98, cor0.col2, + cor0.col2 DIV 71 + col1 * - cor0.col2 ) FROM tab2 AS cor0 GROUP BY cor0.col1
----
98

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-2470
SELECT DISTINCT + COALESCE ( + 98, cor0.col2, + cor0.col2 / 71 + col1 * - cor0.col2 ) FROM tab2 AS cor0 GROUP BY cor0.col1
----
98

query I rowsort
SELECT DISTINCT 73 * - cor0.col0 AS col0 FROM tab1 AS cor0 CROSS JOIN tab2 AS cor1 GROUP BY cor0.col0, cor1.col1, cor1.col0

-700

query I rowsort
SELECT DISTINCT + 3 AS col2 FROM tab0 GROUP BY col0
----
3

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( + 75, - cor0.col2 + - cor0.col0, + cor0.col2 ) AS col2 FROM tab2 AS cor0 GROUP BY cor0.col1, cor0.col2
----
75

query I rowsort
SELECT - 65 * 90 AS col1 FROM tab1 cor0 GROUP BY cor0.col1

query I rowsort
SELECT ALL - COALESCE ( tab0.col0, tab0.col0 * tab0.col0 ) FROM tab0 GROUP BY tab0.col0
----
-26
-43
-83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( 30, cor0.col1 * - cor0.col1, NULLIF ( - cor0.col2, - cor0.col1 * - CASE - col0 WHEN cor0.col2 THEN cor0.col2 WHEN - ( 78 ) THEN cor0.col0 * - cor0.col0 ELSE NULL END + cor0.col0 * cor0.col2 ) ) AS col1 FROM tab1 cor0 GROUP BY cor0.col2, cor0.col0
----
30
30
30

query I rowsort
SELECT tab1.col0 col1 FROM tab1 GROUP BY col0
----
22
28
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + COALESCE ( - 43, + cor0.col1 - + cor0.col2, + 80 + + cor0.col1 ) AS col1 FROM tab2 AS cor0 GROUP BY cor0.col2
----
-43

query I rowsort
SELECT DISTINCT ( 10 ) AS col2 FROM tab2 AS cor0 GROUP BY cor0.col1

query I rowsort
SELECT ALL + tab2.col0 * + 25 FROM tab2 GROUP BY tab2.col0
----
2275
2300
375

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col2 * COALESCE ( - 62 * - 77, col0 + NULLIF ( cor0.col1 - cor0.col0, - col0 - - cor0.col1 ) ) AS col1 FROM tab2 AS cor0 GROUP BY cor0.col2
----
276892
377146
415338

onlyif mysql # DIV for integer division: 
query I rowsort label-3085
SELECT DISTINCT COALESCE ( + 5, cor0.col2 + - col2, cor0.col0 * - cor0.col0, cor0.col0 DIV 56 ) AS col2 FROM tab0 AS cor0 GROUP BY cor0.col0
----
5

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-3085
SELECT DISTINCT COALESCE ( + 5, cor0.col2 + - col2, cor0.col0 * - cor0.col0, cor0.col0 / 56 ) AS col2 FROM tab0 AS cor0 GROUP BY cor0.col0
----
5

query I rowsort
SELECT DISTINCT + + 73 FROM tab1 GROUP BY tab1.col0

query I rowsort
SELECT + 30 * cor0.col2 + cor0.col1 * NULLIF ( + cor0.col2, cor0.col2 * 58 ) FROM tab0 AS cor0 GROUP BY col1, cor0.col2
----
1140
2370
2664

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( 3, - cor0.col1 * + cor0.col1, 76, + cor0.col0 * 65 ) FROM tab1 AS cor0 GROUP BY cor0.col2
----
3
3
3

query I rowsort
SELECT ALL + col1 AS col1 FROM tab0 GROUP BY col1
----
0
81

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT cor0.col2 + - cor0.col0 * + NULLIF ( COALESCE ( cor0.col2, - 37, + ( - cor0.col0 ) + cor0.col1 ) - + 9, - 15 ) AS col0 FROM tab0 cor0 GROUP BY cor0.col0, cor0.col2
----
-1741
-2369
-621

query I rowsort
SELECT ALL + 57 FROM tab1 GROUP BY tab1.col0
----
57
57
57

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( - 98, + cor0.col2 + cor0.col1, col1 + + cor0.col2, - cor0.col1 ) AS col1 FROM tab2 AS cor0 GROUP BY cor0.col0
----
-98

query I rowsort
SELECT DISTINCT + 57 FROM tab0 GROUP BY tab0.col1

query I rowsort
SELECT ALL + 43 FROM tab2 AS cor0 CROSS JOIN tab1 AS cor1 GROUP BY cor0.col2, cor0.col0
----
43
43
43

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT cor0.col2 * COALESCE ( + 40, + cor0.col0 + cor0.col0 ) FROM tab2 AS cor0 GROUP BY cor0.col2
----
2320
3160
3480

SELECT ALL + ( + COALESCE ( 27, cor0.col2 DIV cor0.col1, - 39 + cor0.col0 ) ) AS col1 FROM tab2 AS cor0 GROUP BY cor0.col1
----
27
27
27

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-3616
SELECT ALL + ( + COALESCE ( 27, cor0.col2 / cor0.col1, - 39 + cor0.col0 ) ) AS col1 FROM tab2 AS cor0 GROUP BY cor0.col1
----
27
27
27

query I rowsort
SELECT ALL tab2.col2 FROM tab2 GROUP BY col2
----
58
79
87

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + COALESCE ( 74, - cor0.col2, - cor0.col0 * cor0.col2 ) AS col0 FROM tab2 AS cor0 GROUP BY cor0.col2
----
74
74
74

SELECT COALESCE ( 51, - col0 + - cor0.col1, - CASE - cor0.col1 WHEN + cor0.col1 + - 44 THEN NULL WHEN cor0.col2 THEN + cor0.col1 + - CASE + COALESCE ( + col0, - col1 ) WHEN COALESCE ( + cor0.col1, cor0.col0 / CAST( 7 AS SIGNED ) ) * + cor0.col1 THEN + cor0.col0 END * - cor0.col0 WHEN cor0.col1 THEN NULL WHEN cor0.col0 THEN NULL END ) * 78 FROM tab2 cor0 GROUP BY cor0.col2
----
3978
3978
3978

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-3865
SELECT COALESCE ( 51, - col0 + - cor0.col1, - CASE - cor0.col1 WHEN + cor0.col1 + - 44 THEN NULL WHEN cor0.col2 THEN + cor0.col1 + - CASE + COALESCE ( + col0, - col1 ) WHEN COALESCE ( + cor0.col1, cor0.col0 / CAST ( 7 AS INTEGER ) ) * + cor0.col1 THEN + cor0.col0 END * - cor0.col0 WHEN cor0.col1 THEN NULL WHEN cor0.col0 THEN NULL END ) * 78 FROM tab2 cor0 GROUP BY cor0.col2
----
3978
3978
3978

query I rowsort
SELECT DISTINCT - col1 - col2 AS col0 FROM tab0 cor0 GROUP BY cor0.col1, cor0.col2
----
-105
-38
-79

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + COALESCE ( - 38, cor0.col2, col1 + 90 * + cor0.col1 ) FROM tab1 AS cor0 GROUP BY cor0.col0
----
-38
-38
-38

query I rowsort
SELECT + 55 AS col0 FROM tab2 GROUP BY tab2.col0
----
55
55
55

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + COALESCE ( - 85, + cor0.col2 + + 3 * + cor0.col0, 58, + cor0.col1 + ( cor0.col2 - cor0.col0 ) ) FROM tab2 AS cor0 GROUP BY cor0.col1
----
-85

query I rowsort
SELECT DISTINCT - cor1.col1 FROM tab2 AS cor0 CROSS JOIN tab2 AS cor1 GROUP BY cor0.col1, cor1.col1

SELECT COALESCE ( 76, - tab1.col1 DIV - col0 ) FROM tab1 GROUP BY tab1.col1
----
76
76
76

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-4068
SELECT COALESCE ( 76, - tab1.col1 / - col0 ) FROM tab1 GROUP BY tab1.col1
----
76
76
76

onlyif mysql # DIV for integer division: 
query I rowsort label-4069
SELECT + cor0.col0 DIV + COALESCE ( - 39, cor0.col2 ) AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
----
-2
0
0

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-4069
SELECT + cor0.col0 / + COALESCE ( - 39, cor0.col2 ) AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
----
-2
0
0

query I rowsort
SELECT DISTINCT NULLIF ( - col2, cor0.col1 ) col1 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col1
----
-24
-38
-79

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT CASE col2 WHEN + 52 THEN - 52 * cor0.col2 END col0 FROM tab1 cor0 GROUP BY col2, cor0.col2
----
NULL
NULL
NULL

query I rowsort
SELECT ALL - cor0.col0 FROM tab0 AS cor0 CROSS JOIN tab2 AS cor1 GROUP BY cor0.col0
----
-26
-43
-83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT ( - COALESCE ( + 12, - tab2.col1 ) ) FROM tab2 GROUP BY col2
----
-12

query I rowsort
SELECT - 65 AS col0 FROM tab2 GROUP BY tab2.col0

83

query I rowsort
SELECT cor0.col2 AS col2 FROM tab1 AS cor0 CROSS JOIN tab2 cor1 GROUP BY cor1.col0, cor0.col2
----
9 values hashing to 66267ca705f58a4488972e09499aeb2b

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - CASE cor0.col2 WHEN cor0.col2 THEN col2 ELSE cor0.col2 END col2 FROM tab1 cor0 GROUP BY cor0.col2
----
-45
-71
-8

-64

query I rowsort
SELECT DISTINCT + 10 FROM tab1 GROUP BY tab1.col1
----
10

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + COALESCE ( 32, - cor0.col2 * cor0.col1, + cor0.col0 ) FROM tab1 AS cor0 GROUP BY col0
----
32
32
32

query I rowsort
SELECT - 93 + 49 FROM tab2 GROUP BY tab2.col2
----
-44
-44
-44

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( 62, cor0.col1 ) AS col2 FROM tab0 cor0 CROSS JOIN tab2 AS cor1 GROUP BY cor1.col0
----
62
62
62

query I rowsort
SELECT ALL - 78 FROM tab0 AS cor0 CROSS JOIN tab1 AS cor1 GROUP BY cor1.col0
----
-78
-78
-78

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( 29, - col1 + NULLIF ( + cor0.col0 + - 92, - cor0.col1 ) * 75, + 9, + cor0.col1 + + cor0.col0 ) + + cor0.col1 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col1
----
110
29

skipif postgresql # PostgreSQL requires AS when renaming output columns

query I rowsort
SELECT ALL 57 * - 24 FROM tab1 AS cor0 GROUP BY cor0.col0
----
-1368
-1368
-1368

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( - 54, cor0.col0 + - cor0.col1 ) AS col1 FROM tab0 AS cor0 GROUP BY cor0.col0
----
-54
-54
-54

SELECT DISTINCT - cor0.col2 * CASE 41 WHEN + 82 THEN col1 DIV 13 ELSE 38 END AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2
----
-1710
-2698
-304

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-4254
SELECT DISTINCT - cor0.col2 * CASE 41 WHEN + 82 THEN col1 / 13 ELSE 38 END AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2
----
-1710
-2698
-304

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-4268
SELECT DISTINCT COALESCE ( - 46, cor0.col1, + cor0.col2, cor0.col2 * cor0.col1 - + col0 ) * + CAST( NULL AS SIGNED ) AS col0 FROM tab0 AS cor0 GROUP BY cor0.col1
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-4268
SELECT DISTINCT COALESCE ( - 46, cor0.col1, + cor0.col2, cor0.col2 * cor0.col1 - + col0 ) * + CAST ( NULL AS INTEGER ) AS col0 FROM tab0 AS cor0 GROUP BY cor0.col1
----
NULL

query I rowsort
SELECT ALL + cor0.col0 AS col0 FROM tab1, tab2 AS cor0 GROUP BY cor0.col0

query I rowsort
SELECT - 13 FROM tab0 GROUP BY tab0.col2
----
-13
-13
-13

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT CASE 75 WHEN - 96 THEN - cor0.col1 * - ( cor0.col0 ) WHEN cor0.col0 THEN NULL END FROM tab1 AS cor0 GROUP BY cor0.col0
----
NULL
NULL
NULL

query I rowsort
SELECT 63 * col0 FROM tab1 GROUP BY col0
----
1386
1764
5166

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( + 47, col2 ) AS col2 FROM tab0 GROUP BY tab0.col1
----
47
47

query I rowsort

query I rowsort
SELECT ALL cor0.col0 + 76 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
----
104
158
98

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - COALESCE ( 11, + cor0.col0 * cor0.col2 ) FROM tab1 AS cor0 GROUP BY col2
----
-11

query I rowsort
SELECT cor0.col1 * - cor0.col0 FROM tab0 cor0 GROUP BY cor0.col0, cor0.col1

query I rowsort
SELECT col1 AS col2 FROM tab0 cor0 GROUP BY col1
----
0
81

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( 96, - cor0.col2 ) AS col2 FROM tab0 AS cor0 GROUP BY cor0.col1
----
96
96

query I rowsort

query I rowsort
SELECT ALL 52 AS col2 FROM tab2 GROUP BY tab2.col2
----
52
52
52

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL COALESCE ( 63, col2, cor0.col2 * + cor0.col0 + cor0.col0 * cor0.col1 ) AS col1 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col0
----
63
63
63

query I rowsort
SELECT - cor0.col2 * + cor0.col2 AS col1 FROM tab2 AS cor0 GROUP BY col2
----
-3364
-6241
-7569

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT tab1.col1 AS col2 FROM tab1 GROUP BY tab1.col1 HAVING NULL NOT IN ( col2 )
----

query I rowsort
SELECT DISTINCT col1 FROM tab0 GROUP BY tab0.col1 HAVING NOT ( NULL ) IS NULL
----

-87

query I rowsort
SELECT DISTINCT 65 AS col2 FROM tab2 GROUP BY tab2.col0
----
65

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT + CASE col2 WHEN + cor0.col1 + - 18 THEN NULL ELSE col1 END col0 FROM tab1 cor0 GROUP BY cor0.col1, cor0.col2
----
44
57
6

query I rowsort
SELECT - 7 * 50 FROM tab0 AS cor0 GROUP BY cor0.col0
----
-350
-350
-350

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( - 60, - cor0.col2 ) + - 72 * 82 AS col2 FROM tab2 AS cor0 GROUP BY col0
----
-5964
-5964
-5964

query I rowsort
SELECT 16 FROM tab0 cor0 GROUP BY cor0.col2, cor0.col2
----
16
16
16

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - COALESCE ( 19, cor0.col1 ) FROM tab1 AS cor0 GROUP BY cor0.col2
----
-19
-19
-19

query I rowsort
SELECT ALL - col0 * ( - 87 ) + + 89 col2 FROM tab2 cor0 GROUP BY cor0.col0
----
1394
8006
8093

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - COALESCE ( 90, cor1.col1 + 31 ) FROM tab2 AS cor0 CROSS JOIN tab2 cor1 GROUP BY cor1.col0, cor0.col1
----
9 values hashing to f6f26b9a04da14807208b93d507095c5

query I rowsort
SELECT DISTINCT - 52 - cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col2, col1, col0

51

query I rowsort
SELECT DISTINCT 69 + 36 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col2
----
105

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - COALESCE ( + 39, col1 + - 65 ) FROM tab2 AS cor0 GROUP BY col2, cor0.col2
----
-39
-39
-39

-79

query I rowsort
SELECT DISTINCT 36 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col0
----
36

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + NULLIF ( COALESCE ( cor0.col0, 94, cor0.col1 * cor0.col0 + + cor0.col0 * 33 ), + 90 ) FROM tab2 AS cor0 GROUP BY cor0.col0, col0
----
15
91
92

query I rowsort
SELECT + 13 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col0
----
13
13
13

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + COALESCE ( + 26, + cor0.col1, + 66, + col2 ) FROM tab2 AS cor0 GROUP BY col1
----
26
26
26

query I rowsort
SELECT ALL 84 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col2
----
84
84
84

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - COALESCE ( + 11, cor0.col1 + + cor0.col2, 62 ) FROM tab2 AS cor0 GROUP BY cor0.col2
----
-11
-11
-11

query I rowsort
SELECT ALL 85 FROM tab1 AS cor0 GROUP BY cor0.col2
----
85
85
85

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT 66 + COALESCE ( + 68, + cor0.col2 * + 81 ) FROM tab1 AS cor0 GROUP BY col1
----
134
134
134

onlyif mysql # DIV for integer division: 
query I rowsort label-6014
SELECT DISTINCT + COALESCE ( 96, col0, cor0.col1 + cor0.col2 DIV - cor0.col0 ) AS col0 FROM tab0 AS cor0 GROUP BY cor0.col1
----
96

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-6014
SELECT DISTINCT + COALESCE ( 96, col0, cor0.col1 + cor0.col2 / - cor0.col0 ) AS col0 FROM tab0 AS cor0 GROUP BY cor0.col1
----
96

query I rowsort
SELECT + 79 FROM tab2 cor0 GROUP BY cor0.col1

query I rowsort
SELECT 91 - cor0.col0 FROM tab0 cor0 GROUP BY cor0.col0
----
48
65
8

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + COALESCE ( - 71, cor0.col2 ) AS col2 FROM tab2 AS cor0 GROUP BY cor0.col0
----
-71
-71
-71

query I rowsort
SELECT DISTINCT - cor0.col0 * + COALESCE ( 19, - col0 * + cor0.col0 + cor0.col1, cor0.col1 ) FROM tab0 AS cor0 GROUP BY col0, cor0.col1
----
-1577
-494
-817

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + COALESCE ( - 92, - cor0.col2 ) FROM tab0 AS cor0 GROUP BY cor0.col1
----
-92
-92

query I rowsort

query I rowsort
SELECT ( COALESCE ( - cor0.col0, 56 + + cor0.col0 ) ) FROM tab2 AS cor0 GROUP BY cor0.col0
----
-15
-91
-92

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( + 98, cor0.col1, cor0.col2 * - 54, 94 - - cor0.col1 ) FROM tab2 AS cor0 GROUP BY cor0.col0, cor0.col1, col0
----
98

query I rowsort
SELECT DISTINCT - cor0.col2 + cor0.col2 FROM tab2 AS cor0 GROUP BY cor0.col2

query I rowsort
SELECT cor0.col1 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col1, cor0.col1, cor0.col2
----
44
57
6

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + COALESCE ( - 20, cor0.col2 ) FROM tab0 AS cor0 GROUP BY cor0.col1
----
-20
-20

query I rowsort

0

query I rowsort
SELECT DISTINCT 89 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col1
----
89

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - + COALESCE ( 91, tab0.col2 ) * 85 FROM tab0 GROUP BY tab0.col0
----
-7735

query I rowsort
SELECT ALL + 7 + cor0.col1 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col1

query I rowsort label-6590
SELECT ALL + 65 / - 76 AS col2 FROM tab0, tab2 cor0 GROUP BY cor0.col2
----
0
0
0

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT cor0.col0 + COALESCE ( + ( 74 ), - cor0.col0 * 18, + cor0.col0 + + cor0.col1 ) FROM tab2 AS cor0 GROUP BY cor0.col0
----
165
166
89

query I rowsort label-6699
SELECT DISTINCT - - COALESCE ( col1, CAST( + 52 AS SIGNED ) + 63, + tab0.col0 * tab0.col0 ) FROM tab0 GROUP BY col1
----
0
81

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-6699
SELECT DISTINCT - - COALESCE ( col1, CAST ( + 52 AS INTEGER ) + 63, + tab0.col0 * tab0.col0 ) FROM tab0 GROUP BY col1
----
0
81

onlyif mysql # DIV for integer division: 

query I rowsort label-6852
SELECT ALL + cor0.col2 / cor0.col2 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col2
----
1
1
1

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL COALESCE ( 94, col0 * - CASE - cor0.col2 WHEN col2 + cor0.col2 * cor0.col1 THEN NULL WHEN + col2 THEN NULL ELSE - cor0.col2 END - col2 ) * cor0.col2 + cor0.col2 * cor0.col2 FROM tab2 AS cor0 GROUP BY cor0.col2
----
13667
15747
8816

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT + - 12 col1 FROM tab1 GROUP BY tab1.col0
----
-12

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL COALESCE ( - 16, cor0.col1 * cor0.col2 ) AS col0 FROM tab1 AS cor0 GROUP BY cor0.col1
----
-16
-16
-16

query I rowsort
SELECT + cor0.col0 FROM tab1 AS cor0 GROUP BY cor0.col0, cor0.col1
----
22
28
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL COALESCE ( + 24, col0 * cor0.col2 ) AS col1 FROM tab0 AS cor0 GROUP BY cor0.col0
----
24
24
24

query I rowsort
SELECT 26 FROM tab0 GROUP BY col1
----
26
26

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + COALESCE ( - 67, + cor0.col1 * col0 ) FROM tab0 AS cor0 GROUP BY cor0.col2
----
-67
-67
-67

query I rowsort
SELECT DISTINCT + cor0.col0 * 33 - cor0.col0 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col0
----
1376
2656
832

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - COALESCE ( 40, - cor0.col1 ) AS col1 FROM tab2 AS cor0 GROUP BY cor0.col2
----
-40
-40
-40

query I rowsort
SELECT DISTINCT col2 * + 77 FROM tab2 GROUP BY col2
----
4466
6083
6699

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( - 94, - cor0.col1 * cor0.col2 ) FROM tab2 AS cor0 GROUP BY cor0.col2, col0
----
-94
-94
-94

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-8479
SELECT ALL - 25 / 28 col1 FROM tab0 GROUP BY tab0.col1
----
0
0

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - COALESCE ( 93, cor0.col1, 38 ) AS col1 FROM tab2 AS cor0 GROUP BY cor0.col0
----
-93
-93
-93

query I rowsort
SELECT ALL + - tab0.col0 AS col1 FROM tab0 GROUP BY tab0.col0
----
-26
-43
-83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - COALESCE ( - 22, - tab1.col0 * 21 ) * 21 FROM tab1 GROUP BY tab1.col1
----
462
462
462

query I rowsort
SELECT + - tab0.col2 AS col0 FROM tab0 GROUP BY col2
----
-24
-38
-79

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( + 29, cor0.col0, + cor0.col2 * cor0.col1 - + cor0.col1 ) FROM tab0 AS cor0 GROUP BY cor0.col0
----
29
29
29

query I rowsort
SELECT ALL - 87 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col1
----
-87
-87
-87

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( + 42, col2 + cor0.col2 * col0 ) AS col2 FROM tab1 AS cor0 GROUP BY cor0.col1
----
42
42
42

query I rowsort
SELECT 32 AS col0 FROM tab2 cor0 GROUP BY cor0.col1
----
32
32
32

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - COALESCE ( 57, cor0.col0, COALESCE ( CASE col0 WHEN - col0 THEN NULL WHEN cor0.col0 * cor0.col2 THEN NULL WHEN + col0 THEN - cor0.col1 END, - 93, cor0.col2 ) ) + + col2 * - cor0.col2 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col2
----
-121
-2082
-5098

81

query I rowsort
SELECT DISTINCT 98 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col1
----
98

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT COALESCE ( 71, cor0.col2 + - cor0.col2 ) FROM tab2 AS cor0 GROUP BY cor0.col1
----
71

query I rowsort
SELECT ALL + col0 AS col0 FROM tab1 GROUP BY col0

SELECT + COALESCE ( 21, + cor0.col0, - CAST( NULL AS SIGNED ), cor0.col2 + cor0.col1 ) FROM tab2 AS cor0 GROUP BY cor0.col0
----
21
21
21

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-9945
SELECT + COALESCE ( 21, + cor0.col0, - CAST ( NULL AS INTEGER ), cor0.col2 + cor0.col1 ) FROM tab2 AS cor0 GROUP BY cor0.col0
----
21
21
21

SELECT ALL - AVG ( DISTINCT col0 ) FROM tab2 GROUP BY col2, col0 HAVING NULL IS NOT NULL
----

query I rowsort
SELECT col0 AS col1 FROM tab2 WHERE NOT NULL BETWEEN NULL AND NULL GROUP BY col0
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - col2 AS col1 FROM tab1 GROUP BY col2 HAVING NOT NULL BETWEEN + col2 AND AVG ( ALL col1 ) + - col1
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT - col0 col0 FROM tab0 GROUP BY col0, col1

query I rowsort
SELECT ALL col1 + + col1 AS col0 FROM tab1 GROUP BY col1 HAVING NULL IS NULL
----
114
12
88

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL col0 col0, col0 FROM tab2 GROUP BY col1, col0
----
15
15
91
91

query I rowsort
SELECT DISTINCT + + col0 AS col1 FROM tab0 AS cor0 GROUP BY col0
----
26
43
83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL col1 AS col2 FROM tab1 GROUP BY col1 HAVING NULL NOT BETWEEN ( + col1 + + col1 ) AND ( + col2 )
----

query II rowsort
SELECT + col2, - col2 AS col1 FROM tab1 GROUP BY col2 HAVING NOT NULL = ( NULL )
----

query I rowsort
SELECT + col2 col1 FROM tab1 AS cor0 GROUP BY col2, col2
----
45
71
8

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col1 AS col2 FROM tab1 AS cor0 GROUP BY col1 HAVING NULL BETWEEN + col2 AND NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT col0 col0 FROM tab0 GROUP BY col0, col0

SELECT ALL col0 / col0 AS col1 FROM tab0 AS cor0 GROUP BY col0 HAVING NULL <> NULL
----

query I rowsort
SELECT DISTINCT + col2 + col2 * col2 FROM tab1 GROUP BY col2 HAVING ( NULL ) IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL col2 col2, col2 AS col1 FROM tab0 GROUP BY col2
----
24
24
38
38

query I rowsort
SELECT ALL + - col0 AS col2 FROM tab2 AS cor0 GROUP BY col0
----
-15
-91
-92

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL col2 AS col0 FROM tab2 cor0 GROUP BY col2 HAVING NULL < - col0
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT col2 - + col2 col0 FROM tab1 GROUP BY col2

query I rowsort
SELECT DISTINCT + col2 AS col2 FROM tab2 GROUP BY col1, col2
----
58
79
87

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT - col1 col0, col1 FROM tab2 AS cor0 GROUP BY col1 HAVING NULL = NULL
----

query I rowsort
SELECT col0 AS col0 FROM tab0 AS cor0 WHERE NOT NULL IS NULL GROUP BY col0
----

query I rowsort
SELECT DISTINCT - - col0 AS col2 FROM tab0 AS cor0 GROUP BY col0
----
26
43
83

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col0 col0, - col0 FROM tab2 AS cor0 GROUP BY col1, col0
----
15
-15
91
-91

query I rowsort
SELECT col0 AS col0 FROM tab2 GROUP BY col2, col1, col0
----
15
91
92

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + col2 + + col2 col2, col2 FROM tab2 AS cor0 GROUP BY col2
----
116
58
158
79

query I rowsort
SELECT ALL + col2 AS col0 FROM tab2 GROUP BY col2 HAVING NOT NULL IS NOT NULL
----
58
79
87

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + - col2 AS col0 FROM tab0 cor0 GROUP BY col2, col2 HAVING NOT NULL NOT BETWEEN - col0 AND NULL
----

query I rowsort
SELECT DISTINCT - col1 AS col1 FROM tab1 WHERE NULL < - col1 * - col1 GROUP BY col1
----

query I rowsort
SELECT - col0 + - - col0 AS col1 FROM tab0 GROUP BY col0, col0
----
0
0
0

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - col1 + col1 col2, col1 * AVG ( ALL + col1 ) FROM tab1 GROUP BY col1, col1 HAVING NOT NULL BETWEEN NULL AND NULL
----

query I rowsort
SELECT - col0 FROM tab2 AS cor0 GROUP BY col0, col2, col0
----

query I rowsort
SELECT + col2 - - col2 + - col1 FROM tab1 GROUP BY col2, col1
----
10
33
98

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col2 AS col1 FROM tab1 AS cor0 GROUP BY col0, col2, col0 HAVING NOT NULL BETWEEN NULL AND + col0 - col1
----

query I rowsort
SELECT + col2 * + col2 AS col2 FROM tab1 AS cor0 GROUP BY col2, col2 HAVING NOT + + col2 IS NULL
----

query I rowsort
SELECT col2 + - col2 col1 FROM tab2 GROUP BY col2, col1
----
0
0
0

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col2 col0, + col2 FROM tab2 GROUP BY col2
----
58
58
79
79

query I rowsort
SELECT + col2 AS col1 FROM tab2 GROUP BY col0, col2 HAVING NOT NULL IS NOT NULL
----
58
79
87

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col0 col2, col0 + - col0 AS col1 FROM tab1 GROUP BY col0
----
22
0
28
0

query I rowsort
SELECT - col1 * + - col1 + + col1 FROM tab2 GROUP BY col1
----
1722
3540
3782

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col2 AS col1 FROM tab1 GROUP BY col2 HAVING + col1 > NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT col1 col0 FROM tab1 cor0 GROUP BY col1 HAVING NOT NULL IS NULL

5
56

query I rowsort
SELECT - col2 AS col0 FROM tab0 GROUP BY col2, col1 HAVING NULL <= NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT col2 col1, - col2 FROM tab0 AS cor0 GROUP BY col2
----
24
-24
38
-38

query I rowsort label-1307
SELECT - - col1 / + col1 AS col0 FROM tab1 AS cor0 GROUP BY col1
----
1
1
1

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT col1 col0, col2 FROM tab1 GROUP BY col1, col2
----
44
71
57
45

79
87

query I rowsort
SELECT DISTINCT + col1 FROM tab1 GROUP BY col1, col2 HAVING NOT NULL >= NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + col2 col2, col2 AS col0 FROM tab1 GROUP BY col2
----
45
45
71
71

query I rowsort
SELECT col1 FROM tab1 AS cor0 GROUP BY col1, col1, col1
----
44
57
6

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - - col2 col1, col2 FROM tab2 AS cor0 GROUP BY col2
----
58
58
79
79
87
87

query I rowsort
SELECT + col1 AS col1 FROM tab0 cor0 WHERE ( NOT NULL <> NULL ) OR ( NULL ) > NULL GROUP BY col1, col0 HAVING NOT ( - col1 ) IS NOT NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - col2 AS col0 FROM tab2 GROUP BY col2 HAVING + - col0 < NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT col1 col0 FROM tab2 GROUP BY col1, col0 HAVING ( NULL ) IS NOT NULL

query I rowsort
SELECT col0 AS col1 FROM tab0 AS cor0 WHERE NOT + col1 IS NULL GROUP BY col0
----
26
43
83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - col0 AS col2 FROM tab1 GROUP BY col0 HAVING NOT + - col2 <> NULL
----

query I rowsort
SELECT + col0 AS col2 FROM tab0 AS cor0 GROUP BY col0 HAVING NOT AVG ( DISTINCT - col2 ) IS NULL
----

query I rowsort
SELECT + col0 * col0 FROM tab1 GROUP BY col0
----
484
6724
784

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + + col2 AS col1 FROM tab2 WHERE - + col1 IS NOT NULL GROUP BY col2 HAVING ( NULL ) <> col1
----

query II rowsort
SELECT col0 AS col1, col0 FROM tab2 AS cor0 GROUP BY col2, col0, col1
----

-38
-79

query I rowsort
SELECT DISTINCT + col0 FROM tab2 AS cor0 WHERE NOT ( NULL ) >= NULL GROUP BY col0
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col1 col1, col0 FROM tab2 GROUP BY col0, col2, col1
----
41
92
59
91

query I rowsort
SELECT ALL col0 * + col0 FROM tab1 GROUP BY col0
----
484
6724
784

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + + col1 AS col2 FROM tab1 AS cor0 GROUP BY col1 HAVING NOT + col2 < NULL
----

query I rowsort
SELECT col2 FROM tab0 cor0 WHERE NOT NULL IS NULL GROUP BY col2
----

query I rowsort
SELECT col0 FROM tab1 GROUP BY col1, col1, col0
----
22
28
82

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT col0 col0, + col0 FROM tab0 GROUP BY col0 HAVING NULL IS NOT NULL
----

query II rowsort
SELECT col0, - col0 FROM tab2 GROUP BY col0
----

query I rowsort
SELECT DISTINCT col0 * col0 col0 FROM tab0 GROUP BY col0
----
1849
676
6889

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col0 AS col1 FROM tab2 GROUP BY col0 HAVING NOT ( ( NOT NULL <> + col1 ) )
----

query I rowsort
SELECT ALL + col0 - - col0 AS col2 FROM tab2 AS cor0 GROUP BY col0, col0 HAVING NULL IS NULL
----

SELECT col0 FROM tab0 GROUP BY col0 HAVING - col0 <> NULL
----

query I rowsort
SELECT ALL - col1 FROM tab0 GROUP BY col1 HAVING NULL IS NOT NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - col1 AS col0 FROM tab0 GROUP BY col1 HAVING NOT ( NOT col0 BETWEEN NULL AND NULL )
----

query I rowsort
SELECT col0 * + col0 FROM tab2 GROUP BY col0, col2, col0
----

query I rowsort
SELECT ALL + col1 * col2 FROM tab2 AS cor0 GROUP BY col1, col2
----
2378
4661
5307

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT + col1 AS col1, col1 AS col2 FROM tab1 GROUP BY col1 HAVING ( NULL ) = col2
----

query I rowsort
SELECT DISTINCT - + col2 * - col2 + + col2 AS col2 FROM tab0 AS cor0 GROUP BY col2
----

-43
-83

query I rowsort
SELECT - col1 * - + col1 FROM tab0 GROUP BY col1, col0 HAVING ( - col1 ) > NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col1 col1, - col1 AS col0 FROM tab1 AS cor0 GROUP BY col1
----
44
-44
57
-57

query I rowsort
SELECT col0 FROM tab2 AS cor0 GROUP BY col1, col0, col0
----
15
91
92

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - col1 AS col0 FROM tab1 GROUP BY col1 HAVING - col0 <= NULL
----

query I rowsort
SELECT DISTINCT col1 FROM tab1 GROUP BY col1 HAVING NULL <> NULL
----

skipif mysql # not compatible
query I rowsort label-3010
SELECT DISTINCT + col1 / - col2 FROM tab2 AS cor0 GROUP BY col2, col1
----
0

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + col1 AS col2 FROM tab1 AS cor0 GROUP BY col1 HAVING NOT col2 < NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL + col2 col2 FROM tab1 cor0 GROUP BY col2

query I rowsort
SELECT - col2 AS col1 FROM tab2 GROUP BY col2, col2, col0
----
-58
-79
-87

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + col1 col1, + col2 FROM tab1 AS cor0 WHERE NULL IS NULL GROUP BY col1, col2
----
44
71
57
45

query I rowsort
SELECT DISTINCT - col2 * col2 FROM tab2 AS cor0 GROUP BY col2, col1
----
-3364
-6241
-7569

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + col0 AS col2 FROM tab0 WHERE NULL IS NOT NULL GROUP BY col0 HAVING NULL > + col2
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT + col0 col0 FROM tab2 GROUP BY col0, col2

query I rowsort
SELECT - col0 AS col2 FROM tab2 GROUP BY col0, col0
----
-15
-91
-92

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - col2 * + - col1 AS col0 FROM tab0 GROUP BY col2, col1 HAVING NULL NOT BETWEEN col0 AND - col0
----

query I rowsort
SELECT + - col1 - col0 AS col1 FROM tab2 AS cor0 GROUP BY col1, col0
----

query I rowsort
SELECT ALL - - col2 AS col2 FROM tab1 AS cor0 GROUP BY col2, col2, col2
----
45
71
8

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col1 AS col0 FROM tab1 AS cor0 GROUP BY col1, col1 HAVING + col0 = NULL
----

query I rowsort
SELECT - col0 * + + col0 AS col2 FROM tab0 cor0 GROUP BY col0
----

query I rowsort
SELECT - col2 + - col2 FROM tab2 GROUP BY col2, col0 HAVING NOT - col0 IS NULL
----
-116
-158
-174

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + + col0 + - - col0 col2, - col0 FROM tab0 AS cor0 GROUP BY col0
----
166
-83
52
-26

query I rowsort
SELECT + - col2 col0 FROM tab0 AS cor0 GROUP BY col2 HAVING ( NULL ) IS NULL
----
-24
-38
-79

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT col0 col2, + col0 AS col0 FROM tab2 GROUP BY col0, col0
----
15
15
91
91

SELECT ALL - col0 AS col1 FROM tab1 AS cor0 GROUP BY col0, col2, col2 HAVING NULL = - col0
----

query I rowsort
SELECT DISTINCT - + col2 FROM tab0 AS cor0 GROUP BY col2 HAVING NOT AVG ( col0 ) < NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL col0 AS col1 FROM tab1 GROUP BY col0 HAVING NULL BETWEEN ( - + col0 ) AND + col1
----

query I rowsort
SELECT col2 FROM tab2 GROUP BY col2 HAVING + col2 IS NULL
----

3249
36

query I rowsort
SELECT ALL + col2 FROM tab0 GROUP BY col2 HAVING NOT NULL BETWEEN NULL AND ( col2 )
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col0 AS col2 FROM tab2 GROUP BY col0, col0 HAVING NOT NULL < col2 + col0
----

query I rowsort
SELECT ALL + col1 + + col1 FROM tab2 GROUP BY col0, col1
----

59
61

query I rowsort
SELECT DISTINCT AVG ( col2 ) AS col1 FROM tab0 AS cor0 WHERE NOT col1 <= ( NULL ) GROUP BY col2
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col2 AS col0 FROM tab1 GROUP BY col2 HAVING NULL <= - col0
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT - col1 col0 FROM tab0 AS cor0 GROUP BY col1

query I rowsort
SELECT + col2 * col0 AS col1 FROM tab2 GROUP BY col2, col0
----
1305
5336
7189

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL col0 col2, - col0 AS col1 FROM tab0 AS cor0 GROUP BY col0, col0 HAVING NOT NULL >= NULL
----

query I rowsort
SELECT DISTINCT - + col1 FROM tab1 AS cor0 GROUP BY col1, col0 HAVING NULL IS NOT NULL
----

query I rowsort
SELECT ALL + col1 FROM tab0 GROUP BY col1, col2 HAVING NOT NULL IS NOT NULL
----
0
0
81

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT col0 col1, + col2 FROM tab1 GROUP BY col0, col2
----
22
8
28
45

query I rowsort
SELECT ALL - col2 AS col0 FROM tab0 WHERE NOT NULL IS NOT NULL GROUP BY col0, col2
----
-24
-38
-79

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col2 AS col0 FROM tab1 GROUP BY col2 HAVING NOT NULL BETWEEN ( - col2 ) AND ( col0 )
----

query I rowsort
SELECT DISTINCT col0 FROM tab1 cor0 GROUP BY col0, col1 HAVING NOT NULL NOT BETWEEN NULL AND - AVG ( DISTINCT - col1 )
----

query I rowsort
SELECT ALL - col1 * - col1 AS col2 FROM tab1 GROUP BY col1
----
1936
3249
36

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col0 AS col2 FROM tab0 GROUP BY col0 HAVING NULL >= col2
----

query I rowsort
SELECT DISTINCT col0 FROM tab2 GROUP BY col0, col2 HAVING NULL IS NOT NULL
----

query I rowsort
SELECT - + col0 - + col0 FROM tab0 AS cor0 GROUP BY col0
----
-166
-52
-86

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col2 col1, col2 FROM tab0 AS cor0 WHERE NOT - col0 IS NULL GROUP BY col2
----
24
24
38
38

query I rowsort
SELECT col0 + - col0 AS col1 FROM tab2 AS cor0 GROUP BY col0
----
0
0
0

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + col1 col1, col1 AS col0 FROM tab0 AS cor0 GROUP BY col1
----
0
0
81
81

query I rowsort
SELECT ALL + + col0 FROM tab0 AS cor0 GROUP BY col0, col0
----
26
43
83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL AVG ( ALL - col2 ) AS col0 FROM tab0 WHERE NOT ( - col2 ) BETWEEN ( NULL ) AND NULL GROUP BY col2 HAVING NULL BETWEEN + col0 AND ( NULL )
----

query I rowsort
SELECT ALL - col2 FROM tab2 AS cor0 GROUP BY col2 HAVING NULL IS NOT NULL
----

SELECT - col1 FROM tab0 AS cor0 GROUP BY col0, col1, col0 HAVING NOT NULL IS NULL
----

query I rowsort
SELECT col1 FROM tab2 AS cor0 GROUP BY col1, col2, col1 HAVING NOT + col2 IS NOT NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - col2 AS col0 FROM tab1 AS cor0 GROUP BY col1, col2 HAVING NOT NULL <= - - col0
----

query I rowsort
SELECT + col0 AS col0 FROM tab2 AS cor0 WHERE ( NULL ) IS NOT NULL GROUP BY col0
----

59
61

query I rowsort
SELECT col2 AS col1 FROM tab0 AS cor0 GROUP BY col2 HAVING NOT - col2 IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT + col0 col0, col0 AS col2 FROM tab2 AS cor0 GROUP BY col0, col1
----
15
15
91
91

query I rowsort
SELECT ALL col2 col0 FROM tab2 cor0 GROUP BY col2 HAVING NULL IS NULL
----
58
79
87

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col2 col2, col2 AS col2 FROM tab2 GROUP BY col2
----
58
58
79
79

query I rowsort
SELECT DISTINCT - - col0 AS col1 FROM tab1 cor0 GROUP BY col0
----
22
28
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col0 AS col2 FROM tab2 cor0 GROUP BY col0 HAVING NULL <> ( + col2 )
----

query I rowsort
SELECT ALL - col1 * - + col1 AS col1 FROM tab1 GROUP BY col1, col1
----

-43
-83

query I rowsort
SELECT ALL + col0 FROM tab0 cor0 WHERE NOT NULL >= NULL GROUP BY col1, col0, col1
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT + col1 col1, col1 AS col0 FROM tab2 AS cor0 GROUP BY col1
----
41
41
59
59

query I rowsort
SELECT col1 AS col2 FROM tab1 GROUP BY col1, col2, col2
----
44
57
6

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - col0 AS col2 FROM tab2 AS cor0 GROUP BY col0, col0 HAVING NOT - col2 <= NULL
----

query I rowsort
SELECT DISTINCT + col2 * + col2 * + col2 FROM tab0 GROUP BY col2
----

SELECT ALL - col1 + - col1 FROM tab1 WHERE NULL IS NOT NULL GROUP BY col2, col1
----

query I rowsort
SELECT - col0 AS col2 FROM tab2 GROUP BY col0, col1 HAVING NULL IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + col2 col1, col2 AS col1 FROM tab2 AS cor0 GROUP BY col0, col2
----
58
58
79
79

----

query I rowsort
SELECT DISTINCT - col1 * - col1 + - col1 * - - col1 AS col0 FROM tab1 AS cor0 GROUP BY col1, col1
----
0

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + col1 AS col2 FROM tab1 AS cor0 GROUP BY col1 HAVING + col2 > NULL
----

query I rowsort
SELECT ALL col2 FROM tab1 AS cor0 GROUP BY col2 HAVING NULL NOT IN ( - AVG ( - col2 ) )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - + col2 col2 FROM tab1 AS cor0 GROUP BY col2, col2
----
-45
-71
-8

query I rowsort
SELECT - col2 FROM tab2 GROUP BY col0, col2 HAVING NULL IS NOT NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + - col0 AS col1 FROM tab2 AS cor0 GROUP BY col0, col0 HAVING NULL > ( col1 )
----

query I rowsort
SELECT col0 FROM tab0 GROUP BY col1, col0, col2
----

query I rowsort
SELECT DISTINCT col1 - col1 - col1 FROM tab0 AS cor0 GROUP BY col1, col1
----
-81
0

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL col0 AS col2 FROM tab0 AS cor0 GROUP BY col0 HAVING NOT col2 / - col2 + + col0 <> NULL
----

query I rowsort
SELECT ALL + col1 FROM tab2 AS cor0 GROUP BY col1, col2 HAVING ( NOT NULL IS NOT NULL )
----

query I rowsort
SELECT col2 AS col2 FROM tab2 GROUP BY col1, col0, col2
----
58
79
87

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - AVG ( ALL col2 ) AS col1 FROM tab1 GROUP BY col2, col2 HAVING ( NULL ) BETWEEN NULL AND ( col1 )
----

query I rowsort
SELECT ALL + col2 AS col1 FROM tab0 GROUP BY col2, col2 HAVING NULL IS NULL
----

22
22
28
28
82
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + col1 * col2 + - - col1 + - + col2 AS col0 FROM tab2 AS cor0 GROUP BY col1, col2 HAVING - + col0 <> NULL
----

query I rowsort
SELECT DISTINCT - col1 + - col2 AS col0 FROM tab0 GROUP BY col1, col2, col2
----

SELECT ALL - col1 AS col0 FROM tab2 WHERE NULL IS NOT NULL GROUP BY col1
----

query I rowsort
SELECT DISTINCT - col0 FROM tab0 AS cor0 GROUP BY col0, col0 HAVING NOT + col0 IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT + + col0 * + - col0 col1, - col0 FROM tab1 AS cor0 GROUP BY col0
----
-484
-22
-6724
-82

SELECT - + col0 FROM tab0 WHERE NOT NULL > NULL GROUP BY col0, col2 HAVING NULL IS NOT NULL
----

query I rowsort
SELECT - col0 AS col2 FROM tab2 AS cor0 WHERE NOT + col1 IS NOT NULL GROUP BY col0
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + AVG ( - + col0 ) * col0 AS col1 FROM tab2 GROUP BY col0 HAVING NOT NULL = - - col1 + - AVG ( ALL col0 )
----

query II rowsort
SELECT DISTINCT + col2 AS col2, - col2 AS col1 FROM tab0 GROUP BY col2
----

query I rowsort
SELECT ALL col0 AS col1 FROM tab1 cor0 GROUP BY col0, col0, col0
----
22
28
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col0 AS col1 FROM tab0 AS cor0 GROUP BY col0, col0 HAVING - col1 * col1 * - col0 = NULL
----

query I rowsort
SELECT DISTINCT col1 AS col0 FROM tab2 AS cor0 GROUP BY col2, col1
----

query I rowsort
SELECT ALL - col2 * + - col2 AS col0 FROM tab2 GROUP BY col2 HAVING NULL IS NULL
----
3364
6241
7569

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL col2 col2, col2 AS col0 FROM tab0 AS cor0 WHERE NOT NULL IS NOT NULL GROUP BY col2
----
24
24
38
38

query I rowsort
SELECT DISTINCT col1 + + col1 FROM tab0 cor0 GROUP BY col1
----
0
162

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + col1 AS col0 FROM tab1 AS cor0 GROUP BY col1 HAVING NOT col0 <= NULL
----

query I rowsort
SELECT ALL + col2 AS col2 FROM tab2 GROUP BY col2 HAVING NOT + col2 IS NOT NULL
----

query I rowsort
SELECT ALL - + col2 FROM tab2 cor0 GROUP BY col0, col2
----
-58
-79
-87

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL col2 AS col1 FROM tab2 GROUP BY col2, col0 HAVING NULL NOT BETWEEN NULL AND + col1
----

query I rowsort
SELECT ALL col1 - + col2 FROM tab0 GROUP BY col2, col1
----

query I rowsort
SELECT DISTINCT + col1 FROM tab2 GROUP BY col1 HAVING NULL IS NULL
----
41
59
61

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL col2 col2, + col2 * + + col2 AS col0 FROM tab1 AS cor0 GROUP BY col2, col2 HAVING + col0 < NULL
----

query I rowsort
SELECT ALL + col2 * + col0 AS col0 FROM tab1 GROUP BY col0, col2
----

6972
702

query I rowsort
SELECT - - col1 AS col0 FROM tab2 AS cor0 WHERE col1 NOT BETWEEN NULL AND NULL GROUP BY col1
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col2 col2, col2 AS col2 FROM tab2 AS cor0 GROUP BY col2, col1
----
58
58
79
79

-79
-87

query I rowsort
SELECT - col0 - - col0 FROM tab2 GROUP BY col0 HAVING NOT NULL <= NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col1 col2, - col1 AS col2 FROM tab0 AS cor0 GROUP BY col1
----
0
0
81
-81

query I rowsort
SELECT - col2 FROM tab0 AS cor0 GROUP BY col2, col2 HAVING NULL IS NOT NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT AVG ( ALL + col0 ) * - AVG ( DISTINCT col0 ) AS col1 FROM tab1 GROUP BY col0 HAVING ( col1 ) <> NULL
----

query I rowsort
SELECT ALL - col0 FROM tab1 GROUP BY col0, col2 HAVING NOT ( NULL ) IS NULL
----

43
83

query I rowsort
SELECT ALL + col0 FROM tab1 GROUP BY col0, col0, col2 HAVING NOT NULL IS NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - col2 - col2 * - col0 AS col1 FROM tab2 AS cor0 GROUP BY col2, col0 HAVING NOT + + col1 >= NULL
----

query I rowsort
SELECT - col0 AS col0 FROM tab0 AS cor0 WHERE NULL IS NOT NULL GROUP BY col0, col2
----

22
-22
28
-28
82
-82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - + col2 AS col1 FROM tab2 AS cor0 GROUP BY col2 HAVING NULL >= - col1
----

query I rowsort
SELECT - col1 AS col2 FROM tab0 AS cor0 GROUP BY col2, col2, col1 HAVING NOT NULL IS NULL
----

query I rowsort
SELECT + col1 col0 FROM tab1 GROUP BY col2, col1
----
44
57
6

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + col2 AS col0 FROM tab0 GROUP BY col2, col2, col2 HAVING NULL < col0
----

query I rowsort
SELECT - col2 AS col1 FROM tab1 GROUP BY col1, col2 HAVING NOT - col2 IS NOT NULL
----

0

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT - + col2 col1 FROM tab1 AS cor0 GROUP BY col2 HAVING NOT NULL <> NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col0 col1, col0 AS col1 FROM tab2 AS cor0 GROUP BY col0
----
15
15
91
91

SELECT + col0 FROM tab2 AS cor0 GROUP BY col1, col0 HAVING NOT NULL IS NULL
----

query I rowsort
SELECT ALL + col2 AS col0 FROM tab2 WHERE NOT ( ( NOT col1 * - col0 IS NULL ) ) GROUP BY col2, col1
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL + col2 col1, - col1 AS col0 FROM tab1 GROUP BY col2, col1
----
45
-57
71
-44

query I rowsort
SELECT DISTINCT col0 * col0 FROM tab2 GROUP BY col0
----
225
8281
8464

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT col0 col1, col0 FROM tab2 AS cor0 GROUP BY col0, col0
----
15
15
91
91

query I rowsort
SELECT ALL - col0 col0 FROM tab2 GROUP BY col2, col0
----
-15
-91
-92

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col1 AS col2 FROM tab1 cor0 GROUP BY col1, col1 HAVING - col2 < NULL
----

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

query I rowsort
SELECT - + col1 AS col0 FROM tab2 WHERE NOT - col1 IS NULL GROUP BY col1, col1
----
-41
-59
-61

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT col1 col2, - col1 AS col0 FROM tab2 GROUP BY col1
----
41
-41
59
-59

query I rowsort
SELECT DISTINCT + col0 col0 FROM tab1 AS cor0 WHERE - col2 IS NOT NULL GROUP BY col0
----
22
28
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - col2 AS col1 FROM tab0 GROUP BY col2, col2 HAVING NOT NULL BETWEEN NULL AND - - col2 / - col1
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT - col0 col0 FROM tab2 cor0 GROUP BY col0 HAVING NULL IS NULL

24
43
38
83
79
26

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL + col0 col2, col1 * - col1 AS col0 FROM tab2 GROUP BY col0, col1
----
15
-3721
91
-3481

0
81

query I rowsort
SELECT ALL col0 / + col0 AS col0 FROM tab2 GROUP BY col2, col0 HAVING NOT NULL IS NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT ALL + col0 AS col1, col0 AS col2 FROM tab1 GROUP BY col0 HAVING NOT + col2 BETWEEN NULL AND NULL
----

query I rowsort
SELECT DISTINCT - + col2 FROM tab2 AS cor0 GROUP BY col2, col1
----

query I rowsort
SELECT ALL + col2 - - + col2 + - - col2 FROM tab2 AS cor0 GROUP BY col2
----
174
237
261

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + col1 AS col2 FROM tab1 GROUP BY col1 HAVING NOT NULL <> - col2
----

query I rowsort
SELECT ALL + col0 FROM tab2 cor0 GROUP BY col0 HAVING NOT NULL > NULL
----

92

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - col2 col2 FROM tab2 WHERE ( NULL ) NOT IN ( col1 ) GROUP BY col2
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query III rowsort
SELECT - col2 col2, col2, col2 AS col1 FROM tab2 GROUP BY col2
----
9 values hashing to 0b557cf9945bfac98ef8ff910306a370

query I rowsort
SELECT + col0 * + - col0 + + col0 FROM tab1 GROUP BY col0

SELECT ALL - + col2 AS col0 FROM tab2 AS cor0 GROUP BY col2 HAVING ( col2 ) IS NULL
----

query I rowsort
SELECT DISTINCT - + col1 FROM tab1 AS cor0 GROUP BY col1 HAVING NULL IS NOT NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + col0 AS col2 FROM tab0 AS cor0 WHERE - col2 >= + col0 GROUP BY col0 HAVING + col2 > NULL
----

query I rowsort
SELECT col2 + + + col2 AS col2 FROM tab0 AS cor0 GROUP BY col2
----

query I rowsort
SELECT col2 + col2 AS col0 FROM tab1 GROUP BY col1, col2
----
142
16
90

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT AVG ( + - col0 ) AS col1 FROM tab0 cor0 GROUP BY col2, col0 HAVING + col1 + col2 BETWEEN NULL AND NULL
----

query I rowsort
SELECT col2 + - col2 AS col1 FROM tab1 AS cor0 GROUP BY col2, col2
----

43
83

query I rowsort
SELECT + col2 FROM tab0 AS cor0 WHERE ( NULL ) >= NULL GROUP BY col2
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT - col1 col1, col1 + col1 * + col1 AS col0 FROM tab1 GROUP BY col2, col1
----
-44
1980
-57
3306

SELECT ALL col2 FROM tab0 AS cor0 GROUP BY col0, col2 HAVING + col2 < NULL
----

query I rowsort
SELECT ALL + col2 FROM tab0 AS cor0 WHERE NULL IS NOT NULL GROUP BY col2
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT col0 col2, col0 FROM tab2 GROUP BY col0, col1
----
15
15
91
91

query I rowsort
SELECT ALL + - col1 - - + col1 AS col0 FROM tab2 AS cor0 GROUP BY col1 HAVING ( NULL IS NULL )
----
0
0
0

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - col0 AS col2 FROM tab1 AS cor0 GROUP BY col0 HAVING col2 * col0 <> ( NULL )
----

query I rowsort
SELECT + - col1 AS col0 FROM tab2 cor0 GROUP BY col1 HAVING NULL IS NULL
----

query I rowsort
SELECT DISTINCT + - col1 FROM tab2 WHERE NULL IS NULL GROUP BY col1, col1
----
-41
-59
-61

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col1 AS col2 FROM tab2 GROUP BY col1 HAVING NOT ( col2 ) BETWEEN NULL AND NULL
----

query I rowsort
SELECT - col0 AS col2 FROM tab0 AS cor0 GROUP BY col0, col0
----

SELECT DISTINCT col1, + col1 FROM tab0 GROUP BY col1
----
0
0
81
81

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL - col2 col2, col2 AS col0 FROM tab2 GROUP BY col2
----
-58
58
-79
79

-3306
-42

query I rowsort
SELECT DISTINCT col2 AS col2 FROM tab2 GROUP BY col2 HAVING NULL IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL col1 col2, col1 AS col1 FROM tab1 AS cor0 GROUP BY col1
----
44
44
57
57

query I rowsort
SELECT DISTINCT - col2 AS col0 FROM tab1 cor0 GROUP BY col0, col2
----
-45
-71
-8

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - col1 col2, col1 AS col1 FROM tab2 WHERE NOT ( + col1 ) IS NOT NULL GROUP BY col1, col1
----

query I rowsort
SELECT DISTINCT col0 AS col1 FROM tab0 cor0 GROUP BY col0, col0 HAVING + col0 IS NOT NULL
----

query I rowsort
SELECT - col0 - col0 FROM tab1 AS cor0 GROUP BY col0
----
-164
-44
-56

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - col2 col1, col2 AS col1 FROM tab2 GROUP BY col2
----
-58
58
-79
79

query I rowsort
SELECT - col0 AS col2 FROM tab1 cor0 GROUP BY col0, col2
----
-22
-28
-82

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col2 + - col2 col1, col2 FROM tab1 GROUP BY col2 HAVING NOT ( NULL ) NOT BETWEEN NULL AND NULL
----

query I rowsort
SELECT ALL + col2 FROM tab0 GROUP BY col2, col2, col0
----

query I rowsort
SELECT col0 col0 FROM tab0 cor0 GROUP BY col0, col1
----
26
43
83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col1 AS col2 FROM tab2 GROUP BY col1 HAVING NULL >= + col2 + + - col1
----

query I rowsort
SELECT - col2 * + col2 + - col0 FROM tab1 cor0 GROUP BY col0, col2
----

SELECT DISTINCT - col0 FROM tab2 AS cor0 WHERE ( NULL ) IS NOT NULL GROUP BY col0
----

query II rowsort
SELECT ALL - + col0 AS col0, col0 AS col2 FROM tab1 AS cor0 WHERE NOT - col0 * - col2 IS NOT NULL GROUP BY col0, col2
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + col2 col0, + col2 FROM tab0 AS cor0 GROUP BY col2
----
24
24
38
38

query I rowsort
SELECT - col0 AS col1 FROM tab1 AS cor0 GROUP BY col2, col0, col0 HAVING NOT NULL IS NOT NULL
----
-22
-28
-82

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT - col1 col0, col1 FROM tab1 AS cor0 GROUP BY col1
----
-44
44
-57
57

0
0

query I rowsort
SELECT col2 AS col1 FROM tab1 AS cor0 GROUP BY col2, col2 HAVING NULL IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT + col1 col1, - col0 AS col0 FROM tab2 AS cor0 GROUP BY col0, col1, col0
----
41
-92
59
-91

query I rowsort
SELECT DISTINCT - col0 * + + col0 FROM tab1 GROUP BY col0
----
-484
-6724
-784

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - - col0 col2, col0 FROM tab2 AS cor0 GROUP BY col0
----
15
15
91
91

71
8

query I rowsort
SELECT DISTINCT col0 FROM tab1 cor0 WHERE NOT ( col0 ) <= NULL GROUP BY col2, col0, col1
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL col2 AS col0 FROM tab0 AS cor0 GROUP BY col2 HAVING NOT + col0 < NULL
----

query II rowsort
SELECT DISTINCT - col0 * + col0, + col0 FROM tab2 AS cor0 GROUP BY col0
----

query I rowsort
SELECT DISTINCT col2 * - col2 AS col1 FROM tab1 GROUP BY col1, col2
----
-2025
-5041
-64

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT ALL col2 AS col0, + col2 FROM tab2 GROUP BY col2, col2 HAVING col0 <> NULL
----

query I rowsort
SELECT DISTINCT - col0 * - col0 * col0 FROM tab2 GROUP BY col0
----

38
79

query I rowsort
SELECT - col1 AS col1 FROM tab2 GROUP BY col1 HAVING NULL IS NOT NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col1 AS col0 FROM tab2 AS cor0 GROUP BY col1, col1 HAVING NULL <= + col0
----

query I rowsort
SELECT ALL col1 AS col2 FROM tab0 AS cor0 WHERE ( NULL ) <= + - col1 GROUP BY col0, col1 HAVING + col1 IS NOT NULL
----

query I rowsort
SELECT col0 FROM tab1 AS cor0 GROUP BY col0, col0, col0
----
22
28
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - col0 * + col0 AS col1 FROM tab1 cor0 GROUP BY col0 HAVING NULL NOT BETWEEN + col1 AND NULL
----

query I rowsort
SELECT col0 / - col0 AS col2 FROM tab1 GROUP BY col0, col1 HAVING NULL IS NOT NULL
----

query I rowsort
SELECT ALL - col0 + - col0 FROM tab1 GROUP BY col0
----
-164
-44
-56

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL - col0 col2, - col0 FROM tab0 AS cor0 GROUP BY col0
----
-26
-26
-43
-43

57
6

query I rowsort
SELECT DISTINCT - + col1 FROM tab2 AS cor0 GROUP BY col1 HAVING NOT - + col1 < NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT col2 col2, - col2 * - col2 FROM tab0 GROUP BY col1, col2
----
24
576
38
1444

86

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT - col0 col1 FROM tab2 WHERE NULL > ( NULL ) GROUP BY col0
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + col2 AS col1 FROM tab2 GROUP BY col2 HAVING NOT NULL <> - col1
----

query I rowsort
SELECT - col1 AS col0 FROM tab1 WHERE NOT NULL IS NULL GROUP BY col2, col1, col1 HAVING NOT - + col2 IS NULL
----

-43
-83

query I rowsort
SELECT ALL - col2 / - col2 AS col2 FROM tab1 GROUP BY col2 HAVING col2 > NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - col2 AS col1 FROM tab0 GROUP BY col2 HAVING col1 > NULL
----

query I rowsort
SELECT DISTINCT - - col0 AS col2 FROM tab1 cor0 GROUP BY col0
----

query I rowsort
SELECT - - col2 + + col1 AS col1 FROM tab2 AS cor0 GROUP BY col1, col2
----
138
148
99

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT + col2 AS col1 FROM tab2 GROUP BY col0, col2 HAVING NOT ( NULL ) BETWEEN NULL AND ( col1 )
----

query I rowsort
SELECT ALL col0 AS col2 FROM tab2 cor0 GROUP BY col0
----

query I rowsort
SELECT - - col2 AS col1 FROM tab2 AS cor0 GROUP BY col2, col1, col2
----
58
79
87

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col2 AS col0 FROM tab0 AS cor0 GROUP BY col2 HAVING + col0 >= NULL
----

query II rowsort
SELECT DISTINCT + col2 AS col2, + col2 AS col2 FROM tab1 AS cor0 GROUP BY col2, col1, col2 HAVING NOT ( NULL ) IS NOT NULL
----

query I rowsort
SELECT ALL col1 FROM tab2 GROUP BY col1, col0 HAVING NULL IS NULL
----
41
59
61

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + col0 AS col1 FROM tab2 AS cor0 GROUP BY col2, col0 HAVING NULL <= - - col1
----

query I rowsort
SELECT + col0 - - col0 * + col0 FROM tab1 AS cor0 WHERE NOT ( NULL ) IS NULL GROUP BY col0, col2
----

query I rowsort
SELECT col0 * + + col2 FROM tab1 GROUP BY col0, col2
----
1260
176
5822

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col1 col1, + col1 FROM tab2 GROUP BY col1
----
41
41
59
59

57
6

query I rowsort
SELECT DISTINCT + col2 * - AVG ( ALL + col2 ) AS col0 FROM tab2 WHERE - + col2 IS NULL GROUP BY col2
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col2 AS col1 FROM tab2 GROUP BY col2, col2 HAVING - + col1 <= NULL
----

query I rowsort
SELECT ALL + col0 FROM tab0 cor0 GROUP BY col0 HAVING NOT ( + - col0 ) > NULL
----

query I rowsort
SELECT - - col1 FROM tab0 AS cor0 GROUP BY col1, col0, col2
----
0
0
81

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - col1 AS col0 FROM tab2 GROUP BY col1 HAVING NULL <> - col0
----

query I rowsort
SELECT ALL + col1 AS col0 FROM tab2 AS cor0 GROUP BY col1, col2, col2, col1
----
41
59
61

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - + col1 AS col2 FROM tab1 cor0 GROUP BY col1, col1 HAVING + + col2 <> NULL
----

query I rowsort
SELECT ALL - + col1 AS col1 FROM tab2 AS cor0 GROUP BY col2, col1
----

query I rowsort
SELECT DISTINCT col0 FROM tab0 AS cor0 GROUP BY col0 HAVING NULL IS NULL
----
26
43
83

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT col2 col2, + col2 FROM tab1 GROUP BY col2, col0
----
45
45
71
71

query I rowsort
SELECT ALL col0 AS col1 FROM tab2 AS cor0 GROUP BY col1, col0
----
15
91
92

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + col0 AS col2 FROM tab1 GROUP BY col0 HAVING NOT NULL = - col2
----

query I rowsort
SELECT DISTINCT col1 AS col1 FROM tab1 AS cor0 GROUP BY col1, col1, col0
----
44
57
6

query I rowsort
SELECT + col2 + - col2 FROM tab0 cor0 GROUP BY col2
----
0
0
0

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + col2 col0, col1 + + + col2 FROM tab1 AS cor0 GROUP BY col1, col2 HAVING NOT NULL NOT BETWEEN NULL AND NULL
----

query I rowsort
SELECT - col0 FROM tab2 AS cor0 GROUP BY col0, col2 HAVING NULL IS NOT NULL
----

query I rowsort
SELECT DISTINCT + col2 AS col0 FROM tab2 AS cor0 GROUP BY col0, col2, col2
----
58
79
87

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col1 AS col0 FROM tab0 GROUP BY col1, col1 HAVING NULL = - col0
----

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

SELECT - col0 * - - AVG ( ALL + col0 ) FROM tab1 cor0 GROUP BY col0 HAVING NOT ( ( NULL ) IS NULL )
----

query I rowsort
SELECT AVG ( ALL + col0 ) FROM tab2 GROUP BY col0, col0 HAVING NOT ( NULL ) IS NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT DISTINCT col2, AVG ( ALL - col2 ) * - - col2 AS col1 FROM tab1 AS cor0 GROUP BY col2, col2 HAVING NOT NULL <= col1
----

query I rowsort
SELECT - + col0 AS col2 FROM tab1 AS cor0 GROUP BY col0 HAVING NULL IS NULL
----

query I rowsort
SELECT DISTINCT + col1 col2 FROM tab2 cor0 GROUP BY col1, col0, col1
----
41
59
61

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + col1 + col1 * - col1 AS col2 FROM tab2 AS cor0 GROUP BY col0, col1 HAVING NOT NULL NOT BETWEEN col2 AND NULL
----

query I rowsort
SELECT ALL col1 * - + col1 AS col2 FROM tab2 AS cor0 WHERE NOT ( NULL ) >= NULL GROUP BY col1
----

-8
8

query I rowsort
SELECT ALL + col2 AS col1 FROM tab2 AS cor0 GROUP BY col2 HAVING NULL IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col2 col2, col2 FROM tab0 AS cor0 GROUP BY col0, col2
----
24
24
38
38

SELECT DISTINCT col1 + col1 col0 FROM tab1 AS cor0 WHERE NOT NULL IS NULL GROUP BY col1, col2
----

query I rowsort
SELECT + col2 FROM tab0 GROUP BY col0, col2, col2 HAVING NOT NULL >= NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - col0 col0, - col0 AS col0 FROM tab2 GROUP BY col0
----
-15
-15
-91
-91

query I rowsort
SELECT DISTINCT - col1 AS col2 FROM tab1 AS cor0 GROUP BY col1, col2 HAVING - + col2 IS NOT NULL
----
-44
-57
-6

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL col2 AS col0 FROM tab2 AS cor0 GROUP BY col2 HAVING ( - - col0 ) > NULL
----

query I rowsort
SELECT DISTINCT col0 + - + col0 FROM tab0 AS cor0 GROUP BY col0, col2
----

SELECT DISTINCT col0 FROM tab0 WHERE ( NULL ) IS NOT NULL GROUP BY col2, col0
----

query I rowsort
SELECT ALL col0 AS col2 FROM tab1 GROUP BY col1, col0 HAVING NULL IS NOT NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col2 AS col0 FROM tab1 GROUP BY col2 HAVING NOT ( NULL ) <= - col0 - - col0
----

query I rowsort
SELECT DISTINCT - col1 * - col1 FROM tab2 AS cor0 GROUP BY col1
----

16
90

query I rowsort
SELECT ALL col0 AS col2 FROM tab1 cor0 GROUP BY col0 HAVING NOT NULL IS NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + col1 col2, + col1 AS col2 FROM tab1 cor0 GROUP BY col1, col1 HAVING NOT ( NULL ) IS NOT NULL
----
44
44
57
57

8281
8464

query I rowsort
SELECT DISTINCT col0 AS col0 FROM tab1 AS cor0 WHERE NULL IS NULL GROUP BY col0 HAVING NULL = NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL col0 AS col2 FROM tab2 GROUP BY col0 HAVING + - col2 > NULL
----

query I rowsort
SELECT ALL - + col2 + - + col0 AS col2 FROM tab0 cor0 GROUP BY col0, col2
----

59
61

query I rowsort
SELECT - col1 * - AVG ( DISTINCT - + col1 ) FROM tab1 WHERE NOT NULL IS NULL GROUP BY col1
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL col2 AS col0 FROM tab1 GROUP BY col2, col2, col2 HAVING NOT NULL <> - - col0
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT - col1 col1 FROM tab0 AS cor0 WHERE NOT col0 IS NULL GROUP BY col1

query I rowsort
SELECT + col0 FROM tab0 AS cor0 GROUP BY col0 HAVING NOT ( NULL IS NOT NULL )
----
26
43
83

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + + col0 AS col1 FROM tab0 AS cor0 GROUP BY col0 HAVING NOT NULL >= + - col1
----

query I rowsort
SELECT - - col0 * + + col0 FROM tab2 AS cor0 GROUP BY col2, col0
----

-210
30
-8190
182
-8372
184

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - + col1 AS col0 FROM tab1 AS cor0 GROUP BY col1, col1, col1 HAVING col0 <> NULL
----

query I rowsort
SELECT ALL + col0 * col0 FROM tab1 AS cor0 GROUP BY col0
----

query I rowsort
SELECT DISTINCT - col2 AS col1 FROM tab1 AS cor0 GROUP BY col2, col1
----
-45
-71
-8

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col1 col0, col1 FROM tab2 GROUP BY col1 HAVING NOT NULL IS NOT NULL
----
41
41
59
59

query I rowsort label-2148
SELECT col1 / - col1 FROM tab2 GROUP BY col1
----
-1
-1
-1

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT + col0 AS col2, + col1 FROM tab1 GROUP BY col0, col1 HAVING NOT ( NULL ) < col1 + col2
----

query I rowsort
SELECT + col2 - + col2 FROM tab1 AS cor0 GROUP BY col2 HAVING NOT NULL IS NOT NULL
----

SELECT - col2 AS col2 FROM tab2 AS cor0 GROUP BY col2 HAVING NOT - col2 IS NOT NULL
----

query I rowsort
SELECT ALL col0 AS col0 FROM tab1 GROUP BY col0 HAVING NULL < NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - - col1 col2, col0 FROM tab1 AS cor0 GROUP BY col1, col0
----
44
82
57
28

query I rowsort
SELECT col1 + col1 AS col0 FROM tab1 AS cor0 GROUP BY col1
----
114
12
88

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - col2 AS col0 FROM tab2 GROUP BY col2 HAVING + col0 <= NULL
----

query I rowsort
SELECT ALL col0 AS col2 FROM tab1 GROUP BY col0, col1, col0
----

query I rowsort
SELECT col0 col2 FROM tab1 AS cor0 GROUP BY col0, col0
----
22
28
82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + col0 * - - AVG ( DISTINCT col0 ) AS col1 FROM tab1 cor0 GROUP BY col0 HAVING NOT NULL BETWEEN - col1 AND NULL
----

query I rowsort
SELECT DISTINCT - + col2 * + - col2 FROM tab0 AS cor0 GROUP BY col2 HAVING NOT ( NULL ) IS NOT NULL
----

query I rowsort
SELECT ALL - - col2 AS col0 FROM tab1 AS cor0 GROUP BY col2
----
45
71
8

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col1 col2, col1 AS col0 FROM tab0 AS cor0 GROUP BY col1
----
0
0
81
81

-44
-56

query I rowsort
SELECT ALL col1 FROM tab2 GROUP BY col1, col0, col1, col0 HAVING NOT col1 IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT + col2 col1, - col2 + col2 AS col1 FROM tab1 AS cor0 GROUP BY col2, col2
----
45
0
71
0

query I rowsort
SELECT + - col2 AS col2 FROM tab1 cor0 GROUP BY col2
----
-45
-71
-8

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT + + col0 col0, col0 FROM tab1 AS cor0 GROUP BY col0
----
22
22
28
28

query I rowsort
SELECT col0 * + - col0 * col0 FROM tab2 AS cor0 GROUP BY col0, col0
----
-3375
-753571
-778688

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col1 / + + col1 AS col0 FROM tab0 AS cor0 GROUP BY col1 HAVING NOT col0 <= NULL
----

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

SELECT col1 + col1 FROM tab0 WHERE - - col2 + col1 IS NULL GROUP BY col1
----

query I rowsort
SELECT DISTINCT + col2 AS col0 FROM tab0 cor0 GROUP BY col2 HAVING NULL IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col2 col2, + col2 AS col1 FROM tab0 AS cor0 GROUP BY col2
----
24
24
38
38

query I rowsort
SELECT ALL col2 AS col2 FROM tab1 GROUP BY col2 HAVING NOT ( NULL IS NOT NULL )
----
45
71
8

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL col2 - - + col1 col2, - col2 FROM tab0 AS cor0 GROUP BY col1, col2
----
105
-24
38
-38

-650
-6806

query I rowsort
SELECT ALL + AVG ( DISTINCT - col0 ) + - col0 * col0 AS col1 FROM tab2 GROUP BY col0, col0, col0 HAVING ( NULL ) IS NOT NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col1 * - col1 AS col2 FROM tab0 GROUP BY col1 HAVING col2 >= NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT col2 col1 FROM tab1 GROUP BY col2, col1

184
30

query I rowsort
SELECT ALL col0 FROM tab2 GROUP BY col0 HAVING ( NULL ) IS NOT NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col0 AS col2 FROM tab2 GROUP BY col1, col0 HAVING ( + col2 ) >= NULL
----

query I rowsort
SELECT - col0 FROM tab2 GROUP BY col0 HAVING NOT NULL BETWEEN col0 AND NULL
----

query I rowsort
SELECT ALL - col2 * - col2 FROM tab1 GROUP BY col2
----
2025
5041
64

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col1 / - col1 AS col2 FROM tab0 AS cor0 WHERE col0 IS NULL GROUP BY col1 HAVING ( col2 ) IS NULL OR NOT NULL IS NOT NULL
----

query II rowsort
SELECT DISTINCT + + col2, + col2 + - 75 AS col0 FROM tab1 cor0 GROUP BY col2, col2 HAVING - col2 + - 17 IS NULL
----

query I rowsort
SELECT ALL col2 col0 FROM tab1 GROUP BY col2, col2
----
45
71
8

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - 4 col2, 1 FROM tab1 GROUP BY col1, col2 HAVING NOT NULL IS NOT NULL
----
-4
1
-4
1

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-2858
SELECT DISTINCT - col2 col1, ( - 94 ) - - - 67 * + - col2 + CAST( NULL AS SIGNED ) FROM tab0 GROUP BY col2 HAVING - col1 BETWEEN ( NULL ) AND NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-2858
SELECT DISTINCT - col2 col1, ( - 94 ) - - - 67 * + - col2 + CAST ( NULL AS INTEGER ) FROM tab0 GROUP BY col2 HAVING - col1 BETWEEN ( NULL ) AND NULL
----

onlyif mysql # DIV for integer division: 
query I rowsort label-2859
SELECT col1 DIV col1 FROM tab1 GROUP BY col0, col1
----
1
1
1

skipif mysql # not compatible
query I rowsort label-2859
SELECT col1 / col1 FROM tab1 GROUP BY col0, col1
----
1
1
1

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ( + + col2 ) col2, - col2 * + - 32 AS col1 FROM tab2 AS cor0 WHERE col0 + + 83 IS NULL GROUP BY col2, col2, col2 HAVING NULL IN ( 70 )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL - col0 * + 57 * col0 col2 FROM tab1 AS cor0 GROUP BY col0, col0, col0 HAVING NOT NULL NOT BETWEEN ( + col2 ) AND col2

query I rowsort label-2875
SELECT CASE - CAST( NULL AS SIGNED ) WHEN - col1 THEN + col0 - - 48 ELSE NULL END AS col2 FROM tab0 GROUP BY col1
----
NULL
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-2875
SELECT CASE - CAST ( NULL AS INTEGER ) WHEN - col1 THEN + col0 - - 48 ELSE NULL END AS col2 FROM tab0 GROUP BY col1
----
NULL
NULL

onlyif mysql # CAST syntax: SIGNED type: 

16
90

query I rowsort
SELECT DISTINCT - 46 AS col2 FROM tab0 AS cor0 WHERE ( NOT NULL IS NULL ) GROUP BY col2
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL 76 + - col2 col2, col2 FROM tab2 GROUP BY col2
----
-11
87
-3
79

----

skipif mysql # not compatible
query II rowsort label-2938
SELECT + col1 - + ( - CAST ( NULL AS REAL ) ) + + + 71 * + ( - 27 ) AS col2, + col1 / + 63 - + col1 FROM tab2 GROUP BY col1 HAVING NULL > ( NULL )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT + col2 + - ( - col2 ) col1, 3 FROM tab1 GROUP BY col2
----
142
3
16
3

NULL
NULL

query I rowsort
SELECT col2 AS col2 FROM tab0 AS cor0 WHERE NOT ( NULL ) IS NULL GROUP BY col2 HAVING NULL BETWEEN + 67 AND NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT CASE col2 WHEN - col2 THEN - AVG ( DISTINCT - col0 ) END AS col1 FROM tab1 cor0 GROUP BY col2 HAVING + col1 = NULL
----

query I rowsort
SELECT - col0 * - 93 FROM tab1 WHERE + col2 * + col1 * - 33 IS NULL GROUP BY col0
----

----

skipif mysql # not compatible
query I rowsort label-3063
SELECT ALL + col1 AS col0 FROM tab1 WHERE NULL > + + 71 * + - col2 + + col1 + - - CAST ( NULL AS INTEGER ) * col1 + + col2 + - col1 GROUP BY col0, col1
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL - col2 AS col0 FROM tab2 AS cor0 GROUP BY col2, col1, col2 HAVING NOT NULL BETWEEN + - 33 * - - 38 + + col1 AND + col2 + - + col0
----

query I rowsort
SELECT DISTINCT - - 76 * col2 FROM tab0 AS cor0 GROUP BY col2, col0
----

0
81

query I rowsort
SELECT DISTINCT - col0 * + 48 + col0 / 91 AS col2 FROM tab1 AS cor0 GROUP BY col0, col0 HAVING ( ( NULL ) IS NOT NULL )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT + col2 col2, col1 * + + col1 FROM tab0 AS cor0 WHERE NOT ( NULL ) > col2 GROUP BY col2, col1, col0, col1
----

query I rowsort
SELECT - 40 FROM tab1 AS cor0 GROUP BY col1 HAVING NOT - + 13 + 52 IS NOT NULL
----

query I rowsort label-3199
SELECT ALL col1 / - col1 AS col2 FROM tab2 GROUP BY col1
----
-1
-1
-1

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - col2 * col1 - - ( + 11 ) * col0 * - col0 col1, col2 / - - 90 - - 82 FROM tab0 AS cor0 GROUP BY col2, col0, col1 HAVING NOT NULL IS NULL
----

query I rowsort
SELECT + col2 + col2 + + - col2 * - 10 AS col2 FROM tab0 AS cor0 GROUP BY col2
----
288
456
948

query I rowsort
SELECT DISTINCT + col2 FROM tab0 AS cor0 WHERE NOT NULL IS NULL GROUP BY col2
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT 55 * - col2 AS col1 FROM tab2 AS cor0 WHERE NOT NULL > NULL GROUP BY col2 HAVING NULL >= col1
----

query I rowsort
SELECT - col1 + + + 63 AS col0 FROM tab0 GROUP BY col1
----

-16
-91
-16
-92
-16

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-3207
SELECT + ( - col0 ) col1, + CAST ( - 16 AS INTEGER ) AS col2 FROM tab2 AS cor0 GROUP BY col0
----
-15
-16
-91
-16

query I rowsort
SELECT DISTINCT col0 - + - col0 FROM tab1 GROUP BY col0
----
164
44
56

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col1 + + col1 + 10 * - 81 * COALESCE ( 7, + 91 + col1 + ( + col2 ) ) + - - col1 AS col1 FROM tab1 GROUP BY col1 HAVING NOT ( col1 = NULL )
----

query I rowsort
SELECT - + 63 * 7 + - - col1 * col1 AS col1 FROM tab0 AS cor0 GROUP BY col1
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-3333
SELECT DISTINCT + col0 + COALESCE ( ( + 53 ), - CAST( NULL AS SIGNED ) * NULLIF ( - col2, - col1 ) ) AS col1 FROM tab1 WHERE ( - col0 ) = NULL GROUP BY col0, col2, col2
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-3333
SELECT DISTINCT + col0 + COALESCE ( ( + 53 ), - CAST ( NULL AS INTEGER ) * NULLIF ( - col2, - col1 ) ) AS col1 FROM tab1 WHERE ( - col0 ) = NULL GROUP BY col0, col2, col2
----

query I rowsort
SELECT + col2 * col2 FROM tab2 WHERE NOT NULL IS NULL GROUP BY col2, col2
----

query I rowsort
SELECT - + 44 col0 FROM tab2 AS cor0 GROUP BY col1
----
-44
-44
-44

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT COALESCE ( 50, col1 ) FROM tab1 GROUP BY col2 HAVING NOT NULL <= + - ( + - 58 ) + + + col2
----

query I rowsort
SELECT + + 54 FROM tab0 WHERE NOT NULL IS NOT NULL GROUP BY col1
----

query I rowsort
SELECT DISTINCT + col1 FROM tab1 AS cor0 GROUP BY col2, col1 HAVING ( NOT NULL IS NOT NULL )
----
44
57
6

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + 52 * + col2 + - col2 col0, + col1 * - col1 FROM tab0 GROUP BY col1, col2
----
1224
-6561
1938
0

57
6

query I rowsort
SELECT DISTINCT + - col0 AS col0 FROM tab2 WHERE NOT NULL <= + 48 * + + 99 * + + col2 * + 45 GROUP BY col0 HAVING NOT + col0 IS NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT DISTINCT + 38, + COALESCE ( - - COALESCE ( - 46, + - col1 ), + 74 ) AS col0 FROM tab2 GROUP BY col0
----
38
-46

query I rowsort

query I rowsort
SELECT ALL ( - col2 ) + - - col2 - - 93 AS col0 FROM tab1 GROUP BY col2
----
93
93
93

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col1 AS col0 FROM tab0 GROUP BY col2, col1 HAVING NOT ( NULL ) <> - ( + col0 )
----

query I rowsort
SELECT DISTINCT + col1 * 26 - + + col1 AS col0 FROM tab0 GROUP BY col1
----

query I rowsort
SELECT ALL ( - - col2 ) AS col1 FROM tab1 GROUP BY col2
----
45
71
8

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + col0 col1, 78 - - col0 - 65 + - + 50 * - + ( col2 ) FROM tab0 AS cor0 GROUP BY col2, col0
----
26
3989
43
1256

1

query I rowsort
SELECT DISTINCT 61 AS col2 FROM tab2 GROUP BY col1, col2
----
61

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + - 75 AS col0 FROM tab0 AS cor0 GROUP BY col1 HAVING NOT NULL NOT BETWEEN - - col0 + 12 AND ( - 59 )
----

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-3571
SELECT DISTINCT - - CAST( NULL AS SIGNED ) AS col1, col1 AS col2 FROM tab2 cor0 GROUP BY col1 HAVING NOT ( ( NULL IS NULL ) )

SELECT ALL COALESCE ( - 83, + - ( col2 ) * - - col0 * CAST( + col1 AS SIGNED ) ) FROM tab1 GROUP BY col1
----
-83
-83
-83

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-3589
SELECT ALL COALESCE ( - 83, + - ( col2 ) * - - col0 * CAST ( + col1 AS INTEGER ) ) FROM tab1 GROUP BY col1
----
-83
-83
-83

query I rowsort label-3648
SELECT + col2 + - col2 * - ( CAST ( NULL AS INTEGER ) ) AS col1 FROM tab1 GROUP BY col2
----
NULL
NULL
NULL

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT + 35, + col2 * - 15 AS col1 FROM tab0 GROUP BY col0, col2 HAVING NOT NULL > - col1 * + 42 * - col0 + + col2 + - col1
----

query I rowsort
SELECT - + col0 / col0 FROM tab1 AS cor0 WHERE + 44 = + - col1 GROUP BY col1, col0, col1 HAVING NOT ( NULL ) NOT BETWEEN 61 AND ( NULL )
----

query I rowsort
SELECT DISTINCT + ( + 48 ) + - - 94 + + 86 * col0 AS col1 FROM tab1 AS cor0 GROUP BY col0
----
2034
2550
7194

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT - col1 * - col1 * - COALESCE ( 30, 14, - col0 + 5 ) FROM tab2 GROUP BY col1 HAVING ( NULL ) IS NOT NULL
----

query I rowsort
SELECT ALL - 12 AS col1 FROM tab0 GROUP BY col2
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-3701
SELECT DISTINCT - 14 - col0 AS col2 FROM tab1 AS cor0 WHERE NULL <> col2 - - col2 GROUP BY col0 HAVING NOT + CAST( - col2 AS SIGNED ) * col0 + - col2 / - 81 BETWEEN NULL AND NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-3701
SELECT DISTINCT - 14 - col0 AS col2 FROM tab1 AS cor0 WHERE NULL <> col2 - - col2 GROUP BY col0 HAVING NOT + CAST ( - col2 AS INTEGER ) * col0 + - col2 / - 81 BETWEEN NULL AND NULL
----

query I rowsort
SELECT - col1 + - col2 * col1 FROM tab1 GROUP BY col2, col1
----

SELECT - CAST ( 70 AS INTEGER ) / + col2 FROM tab1 WHERE NOT ( 46 ) IS NOT NULL GROUP BY col2 HAVING NULL IS NULL
----

query I rowsort
SELECT - 77 - col0 AS col2 FROM tab0 GROUP BY col0 HAVING NOT NULL IS NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + col0 AS col1 FROM tab0 AS cor0 GROUP BY col0 HAVING ( col1 ) <= NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-3714
SELECT col2 AS col0 FROM tab1 GROUP BY col2 HAVING NOT ( - CAST( NULL AS SIGNED ) ) <= + 43

-1
67
-1
69
-1

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-3821
SELECT ALL 8 + - - col1 col2, col1 / - col1 AS col1 FROM tab2 AS cor0 GROUP BY col2, col1
----
49
-1
67
-1

query I rowsort
SELECT DISTINCT + 28 + - col2 * - col2 AS col0 FROM tab0 GROUP BY col2
----
1472
604
6269

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT col0 col1, ( - col0 ) * - col0 AS col0 FROM tab1 GROUP BY col0 HAVING NOT NULL BETWEEN NULL AND ( 65 )
----

query I rowsort
SELECT + col1 * - col0 + 76 AS col1 FROM tab0 GROUP BY col0, col1 HAVING NULL < COALESCE ( - + col0, col0 ) AND ( NULL ) IS NOT NULL
----

SELECT + COALESCE ( 83, - - col0 DIV CASE col0 WHEN col1 THEN NULL WHEN col0 THEN - col1 END ) FROM tab1 AS cor0 GROUP BY col1
----
83
83
83

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-3916
SELECT + COALESCE ( 83, - - col0 / CASE col0 WHEN col1 THEN NULL WHEN col0 THEN - col1 END ) FROM tab1 AS cor0 GROUP BY col1
----
83
83
83

onlyif mysql # CAST syntax: DECIMAL type: 
query II rowsort label-3946
SELECT DISTINCT col1 AS col0, - CAST( NULL AS DECIMAL ) + col1 AS col1 FROM tab0 GROUP BY col1, col1 HAVING + 22 * + 61 + - - col0 > NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort label-3946
SELECT DISTINCT col1 AS col0, - CAST ( NULL AS REAL ) + col1 AS col1 FROM tab0 GROUP BY col1, col1 HAVING + 22 * + 61 + - - col0 > NULL
----

query I rowsort
SELECT ALL col0 FROM tab2 AS cor0 GROUP BY col1, col1, col0 HAVING - col1 * - 13 + col0 + - 27 + - + 61 IS NULL
----

15
-44
15
-57
15
-6

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT col1 * - col1 * col1 + - + col1 AS col2, col1 AS col1 FROM tab2 AS cor0 GROUP BY col1 HAVING NOT ( NULL ) BETWEEN + ( - col1 ) AND + col2 + - 3
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT DISTINCT ( + col0 ) col0 FROM tab2 GROUP BY col0 HAVING NULL IS NULL

query I rowsort label-4054
SELECT + CAST ( + + 96 AS INTEGER ) FROM tab1 AS cor0 GROUP BY col0, col1
----
96
96
96

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + 29 * + col0 AS col2 FROM tab2 AS cor0 GROUP BY col1, col0, col1 HAVING NULL > + col2 + + + col0 * - col2 * col1 * + 48 * - col1
----

onlyif mysql # DIV for integer division: 
query I rowsort label-4056
SELECT DISTINCT + col0 DIV - - col0 FROM tab2 GROUP BY col0, col0

query I rowsort
SELECT ALL + col2 * - 83 * NULLIF ( - 83, - 11 ) FROM tab2 AS cor0 GROUP BY col1, col2
----
399562
544231
599343

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + col0 AS col1 FROM tab0 AS cor0 GROUP BY col0 HAVING NOT + - NULLIF ( + col1, - col0 ) * - AVG ( DISTINCT 35 ) >= NULL
----

query I rowsort
SELECT col2 * - + col2 AS col2 FROM tab1 AS cor0 GROUP BY col2, col2
----

225
1
8281
1
8464

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-4219
SELECT ALL col0 / + col0 col1, + col0 * col0 FROM tab2 AS cor0 GROUP BY col0
----
1
225
1
8281

----

skipif mysql # not compatible
query I rowsort label-4228
SELECT ALL + ( col0 ) FROM tab1 GROUP BY col0, col2 HAVING NULL NOT IN ( + col2 / - - 92 / - col2 * - col0, + COALESCE ( + + CAST ( - - col2 AS INTEGER ), - col0 ) )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL - + 75 col0, 23 FROM tab1 cor0 GROUP BY col2
----
-75
23
-75
23

1

query I rowsort
SELECT DISTINCT 0 AS col0 FROM tab2 AS cor0 GROUP BY col2
----
0

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT - + col1 * - col1 + + col1 col0, - 28 FROM tab0 cor0 GROUP BY col1, col1
----
0
-28
6642
-28

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-4415
SELECT DISTINCT COALESCE ( + 90, ( 11 ) + - col1 * + CAST( NULL AS SIGNED ), col0 - col0 ) + - col0 FROM tab0 GROUP BY col0 HAVING NOT ( col0 ) <> NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-4415
SELECT DISTINCT COALESCE ( + 90, ( 11 ) + - col1 * + CAST ( NULL AS INTEGER ), col0 - col0 ) + - col0 FROM tab0 GROUP BY col0 HAVING NOT ( col0 ) <> NULL
----

query I rowsort
SELECT 52 FROM tab0 GROUP BY col1, col0, col1 HAVING col0 <= ( NULL )
----

SELECT ALL col0 AS col0 FROM tab1 GROUP BY col0 HAVING + CAST ( ( col0 ) AS INTEGER ) IS NULL
----

query I rowsort
SELECT + col1 / - col1 * col1 FROM tab0 GROUP BY col1 HAVING + col1 IS NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + col1 * 98 * + COALESCE ( + 7, - col2 ) - col1 * col1 AS col1 FROM tab0 GROUP BY col1
----
0
49005

onlyif mysql # DIV for integer division: 

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-4506
SELECT ALL - col0 + + col0 AS col1 FROM tab0 WHERE col1 IN ( CAST( col0 AS SIGNED ) ) GROUP BY col0 HAVING NOT CAST( NULL AS SIGNED ) <= ( - col1 + + col1 )
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-4506
SELECT ALL - col0 + + col0 AS col1 FROM tab0 WHERE col1 IN ( CAST ( col0 AS INTEGER ) ) GROUP BY col0 HAVING NOT CAST ( NULL AS INTEGER ) <= ( - col1 + + col1 )
----

query I rowsort
SELECT ALL col0 AS col2 FROM tab1 GROUP BY col0, col0
----

query I rowsort label-4548
SELECT DISTINCT CAST ( ( - 67 ) AS INTEGER ) + + - col0 FROM tab1 cor0 GROUP BY col0, col2
----
-149
-89
-95

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT - + col2 * col2 + - ( col1 ) col0, col2 * col2 * col2 AS col2 FROM tab0 AS cor0 GROUP BY col2, col1
----
-1444
54872
-6241
493039

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-4558
SELECT DISTINCT CASE - 59 WHEN 88 THEN - col0 * + + col2 + - 25 + - + CAST( + col0 AS SIGNED ) END AS col1 FROM tab2 AS cor0 GROUP BY col1
----
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-4558
SELECT DISTINCT CASE - 59 WHEN 88 THEN - col0 * + + col2 + - 25 + - + CAST ( + col0 AS INTEGER ) END AS col1 FROM tab2 AS cor0 GROUP BY col1
----
NULL

query I rowsort
SELECT - + 68 FROM tab1 AS cor0 GROUP BY col0, col1, col2

NULL
91
NULL
92
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-4572
SELECT col0 col2, CAST ( NULL AS INTEGER ) FROM tab2 AS cor0 GROUP BY col0
----
15
NULL
91
NULL

query I rowsort
SELECT + + col1 * 56 FROM tab1 AS cor0 GROUP BY col1, col1
----
2464
3192
336

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT - 7 * + col1 * - col1 AS col0 FROM tab0 GROUP BY col1 HAVING NULL >= - col0
----

query I rowsort
SELECT - 33 FROM tab2 GROUP BY col2
----

44
NULL
57
NULL
6

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-4586
SELECT ALL CAST ( NULL AS INTEGER ) - col1 * - AVG ( + 13 ) col0, col1 AS col2 FROM tab1 GROUP BY col1, col1
----
NULL
44
NULL
57

query I rowsort
SELECT + col1 * + 99 AS col1 FROM tab0 AS cor0 GROUP BY col0, col1
----
0
0
8019

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + COALESCE ( + + ( + 22 ), + - 99 * + - CASE + - col0 WHEN - col0 THEN - col2 ELSE NULL END * + col0 - + col0 ) FROM tab1 AS cor0 GROUP BY col1 HAVING NULL IS NULL
----
22
22
22

SELECT col2 AS col2 FROM tab1 GROUP BY col2 HAVING NULL IS NOT NULL
----

query I rowsort
SELECT 7 + - col1 FROM tab0 GROUP BY col1, col0, col2 HAVING NOT NULL BETWEEN + - COALESCE ( + - 37, - col1 - - + col1 ) AND col1
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT DISTINCT col2 + + CASE + - 82 WHEN - 28 THEN - col0 + - col2 END AS col1, - col1 / + col1 FROM tab0 GROUP BY col1, col2 HAVING + col1 > col1
----

query II rowsort
SELECT - col0 AS col0, 54 AS col0 FROM tab2 GROUP BY col0, col0, col0
----

SELECT DISTINCT - ( + - col2 ) FROM tab2 cor0 GROUP BY col2, col0 HAVING NULL < + + col0
----

query I rowsort
SELECT col1 * + + col1 FROM tab2 cor0 GROUP BY col0, col1, col1 HAVING NOT + 56 > + 45
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL col1 AS col0 FROM tab0 AS cor0 WHERE NOT + 58 * + 43 IS NULL GROUP BY col1 HAVING NOT NULL NOT BETWEEN col0 AND NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-4677
SELECT - col1 - + + CAST( NULL AS SIGNED ) AS col2 FROM tab1 AS cor0 GROUP BY col0, col1 HAVING ( - col0 * + + col0 + - col1 ) IS NOT NULL

query I rowsort
SELECT - 30 FROM tab1 GROUP BY col2, col1
----
-30
-30
-30

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL 13 col0, - col2 AS col0 FROM tab0 GROUP BY col2
----
13
-24
13
-38

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-4694
SELECT DISTINCT col0 - col1, col1 AS col2 FROM tab2 AS cor0 GROUP BY col1, col0 HAVING ( NULL ) <> + col2 - + CAST( NULL AS SIGNED )
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort label-4694
SELECT DISTINCT col0 - col1, col1 AS col2 FROM tab2 AS cor0 GROUP BY col1, col0 HAVING ( NULL ) <> + col2 - + CAST ( NULL AS INTEGER )
----

query I rowsort
SELECT - col2 * - + col2 * 85 FROM tab0 AS cor0 GROUP BY col2 HAVING NOT NULL IS NOT NULL
----

query I rowsort
SELECT DISTINCT - + 78 + col1 col0 FROM tab2 cor0 GROUP BY col1, col2
----
-17
-19
-37

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + 85 * - + col2 + - - col2 + 54 + + 58 + - col2 * + col2 * - col2 / + - col2 AS col0 FROM tab2 cor0 GROUP BY col2 HAVING NOT 79 * - + col2 * - col0 >= NULL
----

query I rowsort
SELECT ALL + 83 FROM tab0 GROUP BY col2, col0
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-4864
SELECT DISTINCT col2 AS col0 FROM tab0 GROUP BY col2 HAVING NOT NULL = ( col0 + 42 * - CAST( + 33 AS SIGNED ) )
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-4864
SELECT DISTINCT col2 AS col0 FROM tab0 GROUP BY col2 HAVING NOT NULL = ( col0 + 42 * - CAST ( + 33 AS INTEGER ) )
----

query I rowsort
SELECT ALL 15 AS col0 FROM tab2 GROUP BY col1 HAVING ( NULL ) IS NULL
----

SELECT + COALESCE ( + 85, col0 DIV + ( col2 ) ) FROM tab0 AS cor0 GROUP BY col0
----
85
85
85

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-4887
SELECT + COALESCE ( + 85, col0 / + ( col2 ) ) FROM tab0 AS cor0 GROUP BY col0
----
85
85
85

SELECT DISTINCT + - AVG ( + - col0 ) AS col1 FROM tab0 AS cor0 GROUP BY col0 HAVING NULL IS NOT NULL
----

query I rowsort
SELECT ALL col2 / + + ( - - 46 ) FROM tab0 cor0 WHERE NOT NULL IS NULL GROUP BY col2
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + + 80 * + col1 col2, ( - col1 ) FROM tab1 AS cor0 GROUP BY col2, col1
----
3520
-44
4560
-57

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-4915
SELECT DISTINCT + col1 AS col2 FROM tab1 GROUP BY col1 HAVING NOT NULL < - col2 * CAST( col2 AS SIGNED )
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-4915
SELECT DISTINCT + col1 AS col2 FROM tab1 GROUP BY col1 HAVING NOT NULL < - col2 * CAST ( col2 AS INTEGER )
----

query I rowsort
SELECT ALL col0 AS col2 FROM tab0 GROUP BY col0, col1
----

query I rowsort
SELECT col1 + + 27 + + 19 * - col2 AS col0 FROM tab0 GROUP BY col1, col2
----
-1474
-348
-695

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col0 col0, col0 FROM tab0 GROUP BY col0, col0
----
26
26
43
43

query I rowsort
SELECT + 14 FROM tab0 cor0 GROUP BY col0
----
14
14
14

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT col1 * + col1 * - col1 AS col0 FROM tab2 GROUP BY col1, col2 HAVING NOT NULL BETWEEN col0 AND - - NULLIF ( col0, col0 * - col2 / + col0 )
----

query I rowsort
SELECT ALL - 29 * - col1 - - col1 * + - 39 AS col1 FROM tab1 AS cor0 GROUP BY col1
----

query I rowsort
SELECT DISTINCT + 16 * + col2 FROM tab2 AS cor0 GROUP BY col2, col2
----
1264
1392
928

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL + 6 col1, - 40 FROM tab2 GROUP BY col0 HAVING NULL NOT IN ( - col1 * col1 * - col1 - - + 84, 62 - + 15 * + col1 )
----

query I rowsort
SELECT DISTINCT - 98 AS col2 FROM tab0 AS cor0 GROUP BY col0 HAVING NULL IS NOT NULL
----

query I rowsort
SELECT + 52 AS col0 FROM tab1 GROUP BY col1
----
52
52
52

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT DISTINCT ( - + col1 ) AS col2, + 69 * col1 + - + AVG ( DISTINCT - col1 ) + + 17 AS col2 FROM tab0 GROUP BY col1 HAVING NOT 42 * - col2 = NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-5024
SELECT - - col0 + CAST( - CAST( NULL AS SIGNED ) AS SIGNED ) AS col1, col0 AS col2 FROM tab1 AS cor0 GROUP BY col0 HAVING NOT NULL > - 21

query I rowsort label-5060
SELECT ALL - 84 + - + col2 + - col2 / - col2 col1 FROM tab0 AS cor0 GROUP BY col2, col2 HAVING NOT col2 IS NULL
----
-107
-121
-162

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL col1 col0, col1 FROM tab2 GROUP BY col1
----
41
41
59
59
61
61

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT col1 col1, col1 FROM tab1 GROUP BY col1
----
44
44
57
57

-1

query I rowsort
SELECT DISTINCT - 22 AS col0 FROM tab1 WHERE NOT - ( + COALESCE ( - + 77, + - 49 ) ) + - ( + - 33 ) + col0 IN ( + 35 ) GROUP BY col1
----
-22

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT + + col1 + col1 + COALESCE ( - + 65, + + ( col0 ) ) AS col2 FROM tab0 AS cor0 GROUP BY col1 HAVING NOT ( NOT ( + col1 ) IS NOT NULL )
----
-65
97

query I rowsort

SELECT ALL - col2 FROM tab0 AS cor0 WHERE NULL = NULL AND - 24 * - COALESCE ( + col1, COALESCE ( 61, 72 * ( + col0 * col0 ), 55 ) + - col1, + 46 ) < + col1 GROUP BY col2, col1 HAVING NULL NOT IN ( + 62 )
----

query I rowsort
SELECT ALL + - col0 AS col1 FROM tab0 AS cor0 WHERE col1 * + col2 IS NULL GROUP BY col0
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT - - col1 - CASE ( + - col1 ) WHEN + - 2 THEN + 56 END col0 FROM tab2 cor0 GROUP BY col1
----
NULL
NULL
NULL

query I rowsort label-5208
SELECT ALL - col1 * col1 + 29 + - - col1 / + - col1 AS col1 FROM tab2 AS cor0 GROUP BY col1
----
-1653
-3453
-3693

skipif postgresql # PostgreSQL requires AS when renaming output columns
query III rowsort
SELECT col2 / - col2 + col2 * - col2 AS col1, 67 col1, 24 AS col1 FROM tab1 AS cor0 GROUP BY col2
----
9 values hashing to 442b706f32baefbb061d0cc9d3a2d7a7

query I rowsort
SELECT - col1 FROM tab0 AS cor0 WHERE NOT NULL IS NULL GROUP BY col1

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-5293
SELECT 59 col0, + CAST( - col0 AS SIGNED ) AS col0 FROM tab1 GROUP BY col0 HAVING NOT NULL IS NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort label-5293
SELECT 59 col0, + CAST ( - col0 AS INTEGER ) AS col0 FROM tab1 GROUP BY col0 HAVING NOT NULL IS NULL
----

query I rowsort
SELECT DISTINCT + col0 + col2 FROM tab1 GROUP BY col2, col0 HAVING NOT + + col2 BETWEEN NULL AND col0
----

----

skipif mysql # not compatible
query II rowsort label-5304
SELECT - col0 / - 47 + - + col0 AS col0, col0 AS col1 FROM tab2 AS cor0 WHERE NOT - CAST ( NULL AS INTEGER ) IS NULL GROUP BY col0 HAVING NULL > - 30 + - CAST ( NULL AS INTEGER )
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT DISTINCT - 1, 9 AS col0 FROM tab0 cor0 GROUP BY col2 HAVING NOT - 76 = - ( col2 ) + COALESCE ( + + 86, + + col0 )
----
-1
9

query I rowsort

SELECT - + col1 * + col1 * + NULLIF ( - CAST( NULL AS SIGNED ), + - 27 * + + NULLIF ( - col0, col1 * 9 ) ) + - + 78 + col1 + - + col1 * 26 / col1 / + AVG ( ALL + 6 ) FROM tab1 AS cor0 GROUP BY col1
----
NULL
NULL
NULL

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-5317
SELECT - + col1 * + col1 * + NULLIF ( - CAST ( NULL AS INTEGER ), + - 27 * + + NULLIF ( - col0, col1 * 9 ) ) + - + 78 + col1 + - + col1 * 26 / col1 / + AVG ( ALL + 6 ) FROM tab1 AS cor0 GROUP BY col1
----
NULL
NULL
NULL

query I rowsort
SELECT DISTINCT col0 - col0 * - 65 FROM tab0 AS cor0 GROUP BY col0
----
1716
2838
5478

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL - - 46 col0, - col0 FROM tab0 AS cor0 GROUP BY col0 HAVING NOT ( col0 ) IS NOT NULL
----

query I rowsort
SELECT col2 + + col0 FROM tab1 AS cor0 GROUP BY col0, col2
----

query I rowsort
SELECT DISTINCT + col0 * + 56 FROM tab2 AS cor0 GROUP BY col0, col2
----
5096
5152
840

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + col2 AS col0 FROM tab2 GROUP BY col2 HAVING - + col0 > NULL
----

onlyif mysql # DIV for integer division: 
query II rowsort label-5508
SELECT col0 DIV - 46 AS col1, col0 + - - col0 AS col0 FROM tab2 GROUP BY col0 HAVING NOT 33 IS NULL

----
3

query I rowsort
SELECT + 46 FROM tab2 AS cor0 WHERE - col1 IS NULL GROUP BY col0, col2 HAVING NOT NULL > + 4
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT - - 2 * - + col2 col0, ( - col1 ) + col2 AS col2 FROM tab1 AS cor0 GROUP BY col2, col1 HAVING NULL <= + col2
----

query I rowsort
SELECT - - col1 FROM tab2 AS cor0 GROUP BY col1, col1 HAVING NOT - 93 NOT BETWEEN - col1 / - 99 AND NULL
----

query I rowsort
SELECT 76 FROM tab2 GROUP BY col2
----
76
76
76

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT ALL col1 / + 8 col1, col1 AS col0 FROM tab2 GROUP BY col1, col1 HAVING NOT ( NULL ) <> col0
----

query II rowsort
SELECT ALL col2 * col1 + + - col2 AS col1, + 71 / - col1 * - COALESCE ( + col2, + col1 + - col1 ) AS col2 FROM tab1 GROUP BY col1, col2 HAVING NULL <= 4
----

-118
-98

query I rowsort
SELECT + col0 AS col1 FROM tab2 AS cor0 GROUP BY col1, col0 HAVING NOT - 52 NOT BETWEEN NULL AND - col0
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query III rowsort
SELECT DISTINCT 20 + - col2 AS col0, + col2 col0, - 95 AS col0 FROM tab2 AS cor0 GROUP BY col2
----
9 values hashing to 44912f0b8cb9b18845e83ac435de9c5f

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-5636

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-5669
SELECT ALL CAST( 59 AS SIGNED ) AS col1 FROM tab1 GROUP BY col0 HAVING NOT NULL BETWEEN col1 * - 34 AND NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-5669
SELECT ALL CAST ( 59 AS INTEGER ) AS col1 FROM tab1 GROUP BY col0 HAVING NOT NULL BETWEEN col1 * - 34 AND NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-5670
SELECT ALL + 68 * - CAST( NULL AS SIGNED ) / + col2 * - + col2 AS col0, col2 * + col2 - 2 FROM tab0 GROUP BY col2 HAVING NOT ( NULL ) IS NOT NULL

SELECT + 34 + - col0 + COALESCE ( 7, 29 * col0, + col0 * + CAST( 29 * + col2 AS SIGNED ) ) * col1 AS col2 FROM tab0 AS cor0 GROUP BY col1, col0
----
-49
558
8

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-5709
SELECT + 34 + - col0 + COALESCE ( 7, 29 * col0, + col0 * + CAST ( 29 * + col2 AS INTEGER ) ) * col1 AS col2 FROM tab0 AS cor0 GROUP BY col1, col0
----
-49
558
8

query I rowsort
SELECT + col1 col2 FROM tab2 WHERE NOT 21 IS NULL GROUP BY col0, col1 HAVING - col0 IS NOT NULL
----
41
59
61

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query II rowsort
SELECT - col1 + + 77, col1 * + - 34 AS col2 FROM tab2 GROUP BY col1 HAVING col2 BETWEEN ( NULL ) AND ( NULL )
----

query I rowsort
SELECT DISTINCT 2 AS col0 FROM tab0 GROUP BY col1
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-5719
SELECT ALL + col2 * 94 - + 68 + - + col2 * col2 + - + CASE - 2 WHEN - CAST( + 60 AS DECIMAL ) THEN + 38 END AS col1 FROM tab1 cor0 GROUP BY col2 HAVING NULL <= + + col1
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-5719
SELECT ALL + col2 * 94 - + 68 + - + col2 * col2 + - + CASE - 2 WHEN - CAST ( + 60 AS REAL ) THEN + 38 END AS col1 FROM tab1 cor0 GROUP BY col2 HAVING NULL <= + + col1
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort
SELECT ALL + + col0 * + - ( + 30 ) col2 FROM tab2 AS cor0 GROUP BY col2, col0 HAVING NOT NULL IS NULL

query I rowsort
SELECT ALL - ( + + col1 ) FROM tab1 GROUP BY col1
----
-44
-57
-6

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT 47 + - + col2 col2, 17 FROM tab0 GROUP BY col2 HAVING NOT col2 >= AVG ( - 86 )
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-5751
SELECT - col0 * + - col0 AS col2 FROM tab2 AS cor0 WHERE - col0 IN ( - col1, - col0, + col2, + - 36 * + 54 * + CAST( - col0 AS SIGNED ), - col2 + - ( - col1 ), col1 ) GROUP BY col2, col0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-5790
SELECT DISTINCT col1 AS col0 FROM tab0 GROUP BY col1 HAVING NOT ( col0 * + CAST( 14 / + col0 AS SIGNED ) > NULL )
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort label-5790
SELECT DISTINCT col1 AS col0 FROM tab0 GROUP BY col1 HAVING NOT ( col0 * + CAST ( 14 / + col0 AS INTEGER ) > NULL )
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-5791
SELECT - CAST( NULL AS DECIMAL ) FROM tab2 GROUP BY col1, col1

SELECT 12 AS col2 FROM tab0 GROUP BY col0, col1, col2 HAVING NOT ( NULL IS NULL )
----

query I rowsort
SELECT + 11 * + - col0 * - col0 / - 97 FROM tab2 cor0 WHERE col2 IS NULL GROUP BY col0
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT DISTINCT + col1 * 84 + ( + - 68 ) col1, col2 AS col1 FROM tab2 AS cor0 GROUP BY col2, col1 HAVING ( NULL ) IS NOT NULL
----

query I rowsort
SELECT + 0 FROM tab0 AS cor0 GROUP BY col2
----

query I rowsort
SELECT ALL col0 + 9 FROM tab1 AS cor0 GROUP BY col0
----
31
37
91

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT 59 col0, - col2 AS col0 FROM tab1 GROUP BY col2
----
59
-45
59
-71

query I rowsort
SELECT + col0 * 79 AS col0 FROM tab1 AS cor0 GROUP BY col0, col0
----
1738
2212
6478

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT DISTINCT col2 * + col2 AS col0 FROM tab2 AS cor0 GROUP BY col2, col2 HAVING NULL >= ( col2 + - 30 * col0 )
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-5924
SELECT DISTINCT col1 - col1 FROM tab1 AS cor0 GROUP BY col1 HAVING NOT - CAST( NULL AS SIGNED ) / - col1 + + col1 <> NULL

query I rowsort
SELECT 48 FROM tab1 GROUP BY col2
----
48
48
48

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ( col2 ) AS col1 FROM tab1 GROUP BY col2 HAVING NOT NULL <> + 14 / - col2 * 34 + 1 + - col1 / col1 * col2
----

query I rowsort
SELECT ALL 86 FROM tab0 GROUP BY col0 HAVING NULL IS NULL
----

query I rowsort
SELECT DISTINCT - col0 AS col2 FROM tab1 GROUP BY col1, col0
----
-22
-28
-82

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT 71 AS col1 FROM tab2 GROUP BY col2 HAVING NOT NULL NOT BETWEEN NULL AND - col1 / + col2
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-6089
SELECT DISTINCT + CAST( NULL AS SIGNED ) AS col0 FROM tab0 AS cor0 WHERE - 29 IS NULL GROUP BY col0, col2 HAVING + col2 IS NULL
----

skipif mysql # not compatible
query I rowsort label-6089
SELECT DISTINCT + CAST ( NULL AS INTEGER ) AS col0 FROM tab0 AS cor0 WHERE - 29 IS NULL GROUP BY col0, col2 HAVING + col2 IS NULL
----

skipif postgresql # PostgreSQL has strict column usage for GROUP BY clauses
query I rowsort
SELECT ALL + COALESCE ( 47, col2 ) FROM tab0 AS cor0 GROUP BY col0, col0
----
47
47
47

49
49

query I rowsort
SELECT col0 AS col1 FROM tab0 AS cor0 GROUP BY col0 HAVING NOT + col0 <> + - col0 - + + col0
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT - ( - 68 ) col2, col2 * - 47 FROM tab2 cor0 GROUP BY col2 HAVING NOT NULL IS NULL
----

query I rowsort
SELECT DISTINCT + col1 AS col2 FROM tab1 WHERE NULL BETWEEN + + col2 AND NULL GROUP BY col1
----

query I rowsort label-6116
SELECT - + 76 / col2 AS col1 FROM tab1 AS cor0 GROUP BY col2
----
-1
-1
-9

skipif postgresql # PostgreSQL requires AS when renaming output columns
query II rowsort
SELECT + - col1 col0, + col1 * col1 FROM tab0 WHERE - + 42 NOT BETWEEN + ( + + col0 ) AND + col0 GROUP BY col1 HAVING NOT NULL IS NOT NULL
----
-81
6561
0
0