You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "alamb (via GitHub)" <gi...@apache.org> on 2023/04/23 14:49:52 UTC
[GitHub] [arrow-datafusion] alamb commented on a diff in pull request #6100: test: more sqllogicaltest for GROUPBY.
alamb commented on code in PR #6100:
URL: https://github.com/apache/arrow-datafusion/pull/6100#discussion_r1174594693
##########
datafusion/core/tests/sqllogictests/test_files/groupby.slt:
##########
@@ -52,15 +52,1876 @@ INSERT INTO tab2 VALUES(91,59,79)
statement ok
INSERT INTO tab2 VALUES(92,41,58)
-# group by same column
-query I
-SELECT 38 FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col1;
+query I rowsort
+SELECT - tab1.col0 * 84 + + 38 AS col2 FROM tab1 GROUP BY tab1.col0
+----
+-1810
+-2314
+-6850
+
+query I rowsort
+SELECT + cor0.col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT DISTINCT - ( + col1 ) + - 51 AS col0 FROM tab1 AS cor0 GROUP BY col1
+----
+-108
+-57
+-95
+
+query I rowsort
+SELECT col1 * cor0.col1 * 56 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+194936
+208376
+94136
+
+query I rowsort label-4
+SELECT ALL + tab2.col1 / tab2.col1 FROM tab2 GROUP BY col1
+----
+1
+1
+1
+
+query I rowsort
+SELECT ALL + tab1.col0 FROM tab1 GROUP BY col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT DISTINCT tab1.col0 AS col1 FROM tab1 GROUP BY tab1.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT ALL col2 FROM tab1 GROUP BY col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT ALL + cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col2
+----
+26
+43
+83
+
+query III rowsort
+SELECT DISTINCT * FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col2, cor0.col0
+----
+26 0 79
+43 81 24
+83 0 38
+
+query III rowsort
+SELECT * FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col2, cor0.col0
+----
+26 0 79
+43 81 24
+83 0 38
+
+query I rowsort
+SELECT - 9 * cor0.col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+-369
+-531
+-549
+
+query I rowsort
+SELECT DISTINCT - 21 FROM tab2 GROUP BY col2
+----
+-21
+
+query I rowsort
+SELECT DISTINCT - 97 AS col2 FROM tab1 GROUP BY col0
+----
+-97
+
+query I rowsort
+SELECT + ( - 1 ) AS col0 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+-1
+-1
+-1
+
+query I rowsort
+SELECT - + cor0.col1 FROM tab0, tab0 cor0 GROUP BY cor0.col1
+----
+-81
+0
+
+query I rowsort
+SELECT + cor0.col0 + 36 AS col2 FROM tab0 AS cor0 GROUP BY col0
+----
+119
+62
+79
+
+query I rowsort
+SELECT cor0.col1 AS col1 FROM tab0 AS cor0 GROUP BY col1
+----
+0
+81
+
+query I rowsort
+SELECT DISTINCT + cor0.col1 FROM tab2 cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT ALL + cor0.col0 + - col0 col1 FROM tab1 AS cor0 GROUP BY col0
+----
+0
+0
+0
+
+query I rowsort
+SELECT ALL 54 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+54
+54
+54
+
+query I rowsort
+SELECT 40 AS col1 FROM tab1 cor0 GROUP BY cor0.col0
+----
+40
+40
+40
+
+query I rowsort
+SELECT DISTINCT ( cor0.col0 ) AS col0 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT 62 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+62
+62
+62
+
+query I rowsort
+SELECT 23 FROM tab2 GROUP BY tab2.col2
+----
+23
+23
+23
+
+query I rowsort
+SELECT + ( - tab0.col0 ) col2 FROM tab0, tab0 AS cor0 GROUP BY tab0.col0
+----
+-26
+-43
+-83
+
+query I rowsort
+SELECT + cor0.col1 FROM tab1 AS cor0 GROUP BY cor0.col1
+----
+44
+57
+6
+
+query I rowsort
+SELECT cor0.col1 FROM tab2 AS cor0 GROUP BY cor0.col1, cor0.col2
+----
+41
+59
+61
+
+query I rowsort
+SELECT DISTINCT + 80 + cor0.col2 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+104
+118
+159
+
+query I rowsort
+SELECT DISTINCT 30 * - 9 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+-270
+
+query I rowsort
+SELECT DISTINCT - col2 FROM tab1 AS cor0 GROUP BY col2
+----
+-45
+-71
+-8
+
+query I rowsort
+SELECT ALL - col2 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+-45
+-71
+-8
+
+query I rowsort
+SELECT DISTINCT + 82 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+82
+
+query I rowsort
+SELECT 79 * 19 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+1501
+1501
+1501
+
+query I rowsort
+SELECT ALL ( + 68 ) FROM tab1 cor0 GROUP BY cor0.col2
+----
+68
+68
+68
+
+query I rowsort
+SELECT - col0 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+-22
+-28
+-82
+
+query I rowsort
+SELECT + 81 col2 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+81
+81
+81
+
+query I rowsort
+SELECT ALL cor0.col2 AS col1 FROM tab2 cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT ALL + cor0.col0 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col1, cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT - cor0.col2 AS col0 FROM tab0 cor0 GROUP BY cor0.col2
+----
+-24
+-38
+-79
+
+query I rowsort
+SELECT cor0.col0 FROM tab1 AS cor0 GROUP BY col0, cor0.col1, cor0.col1
+----
+22
+28
+82
+
+query I rowsort
+SELECT 58 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+58
+58
+
+query I rowsort
+SELECT ALL cor0.col1 + - 20 AS col1 FROM tab0 cor0 GROUP BY cor0.col1
+----
+-20
+61
+
+query I rowsort
+SELECT ALL + col1 col0 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT DISTINCT - - 56 FROM tab2, tab0 AS cor0 GROUP BY cor0.col1
+----
+56
+
+query I rowsort
+SELECT - 10 AS col0 FROM tab2, tab1 AS cor0, tab2 AS cor1 GROUP BY cor1.col0
+----
+-10
+-10
+-10
+
+query I rowsort
+SELECT 31 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+31
+31
+31
+
+query I rowsort
+SELECT col2 AS col0 FROM tab0 cor0 GROUP BY cor0.col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT + 70 AS col1 FROM tab0 GROUP BY col0
+----
+70
+70
+70
+
+query I rowsort
+SELECT DISTINCT cor0.col1 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT - cor0.col1 FROM tab2, tab2 AS cor0 GROUP BY cor0.col1
+----
+-41
+-59
+-61
+
+query I rowsort
+SELECT DISTINCT + tab0.col0 col1 FROM tab0 GROUP BY tab0.col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT DISTINCT - cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+-24
+-38
+-79
+
+query I rowsort
+SELECT + cor0.col0 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT - 5 AS col2 FROM tab2, tab2 AS cor0, tab2 AS cor1 GROUP BY tab2.col1
+----
+-5
+-5
+-5
+
+query I rowsort
+SELECT DISTINCT 0 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+0
+
+query I rowsort
+SELECT DISTINCT - - tab2.col0 FROM tab2 GROUP BY col0
+----
+15
+91
+92
+
+query III rowsort
+SELECT DISTINCT * FROM tab2 AS cor0 GROUP BY cor0.col0, col1, cor0.col2
+----
+15 61 87
+91 59 79
+92 41 58
+
+query I rowsort label-58
+SELECT 9 / + cor0.col0 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col2
+----
+0
+0
+0
+
+query I rowsort
+SELECT ( - 72 ) AS col1 FROM tab1 cor0 GROUP BY cor0.col0, cor0.col2
+----
+-72
+-72
+-72
+
+query I rowsort
+SELECT cor0.col0 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT ( col0 ) FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort label-62
+SELECT ALL 59 / 26 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+2
+2
+2
+
+query I rowsort
+SELECT 15 FROM tab1 AS cor0 GROUP BY col2, col2
+----
+15
+15
+15
+
+query I rowsort
+SELECT CAST ( NULL AS INTEGER ) FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col2
+----
+NULL
+NULL
+NULL
+
+query I rowsort
+SELECT ALL - 79 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+-79
+-79
+-79
+
+query I rowsort
+SELECT ALL 69 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+69
+69
+69
+
+query I rowsort
+SELECT ALL 37 col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+37
+37
+
+query I rowsort
+SELECT ALL 55 * 15 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+825
+825
+825
+
+query I rowsort
+SELECT ( 63 ) FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+63
+63
+63
+
+query I rowsort
+SELECT - cor0.col2 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+-45
+-71
+-8
+
+query I rowsort
+SELECT - col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+-58
+-79
+-87
+
+query I rowsort
+SELECT ALL 81 * 11 FROM tab2 AS cor0 GROUP BY col1, cor0.col0
+----
+891
+891
+891
+
+query I rowsort
+SELECT ALL 9 FROM tab2 AS cor0 GROUP BY col2
+----
+9
+9
+9
+
+query I rowsort
+SELECT DISTINCT ( - 31 ) col1 FROM tab1 GROUP BY tab1.col0
+----
+-31
+
+query I rowsort label-75
+SELECT + + cor0.col0 / - cor0.col0 FROM tab1, tab0 AS cor0 GROUP BY cor0.col0
+----
+-1
+-1
+-1
+
+query I rowsort
+SELECT cor0.col2 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT ALL cor0.col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+0
+81
+
+query I rowsort
+SELECT ALL + - ( - tab0.col2 ) AS col0 FROM tab0 GROUP BY tab0.col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT 72 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+72
+72
+
+query I rowsort
+SELECT - 20 - + col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+-101
+-20
+
+query I rowsort
+SELECT - - 63 FROM tab1 GROUP BY tab1.col0
+----
+63
+63
+63
+
+query I rowsort
+SELECT cor0.col2 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col2, col1
+----
+45
+71
+8
+
+query I rowsort
+SELECT + cor0.col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+0
+81
+
+query I rowsort
+SELECT DISTINCT cor0.col1 FROM tab1 AS cor0 GROUP BY cor0.col1, cor0.col1
+----
+44
+57
+6
+
+query I rowsort
+SELECT cor0.col0 - col0 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+0
+0
+0
+
+query I rowsort
+SELECT 50 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+50
+50
+50
+
+query I rowsort
+SELECT - 18 AS col0 FROM tab1 cor0 GROUP BY cor0.col2
+----
+-18
+-18
+-18
+
+query I rowsort
+SELECT + cor0.col2 * cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col2
+----
+1444
+576
+6241
+
+query I rowsort
+SELECT ALL 91 / cor0.col1 FROM tab2 AS cor0 GROUP BY col1, cor0.col1
+----
+1
+1
+2
+
+query I rowsort
+SELECT cor0.col2 AS col2 FROM tab0 AS cor0 GROUP BY col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT ALL + 85 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+85
+85
+85
+
+query I rowsort
+SELECT + 49 AS col2 FROM tab0 cor0 GROUP BY cor0.col0
+----
+49
+49
+49
+
+query I rowsort
+SELECT cor0.col2 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT - col0 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+-15
+-91
+-92
+
+query I rowsort
+SELECT DISTINCT - 87 AS col1 FROM tab0 AS cor0 GROUP BY col0
+----
+-87
+
+query I rowsort
+SELECT + 39 FROM tab0 AS cor0 GROUP BY col1
+----
+39
+39
+
+query I rowsort
+SELECT ALL cor0.col2 * + col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+3364
+6241
+7569
+
+query I rowsort
+SELECT 40 FROM tab0 GROUP BY tab0.col1
+----
+40
+40
+
+query I rowsort
+SELECT tab1.col2 AS col0 FROM tab1 GROUP BY tab1.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT tab2.col0 FROM tab2 GROUP BY tab2.col0
+----
+15
+91
+92
+
+query I rowsort
+SELECT + col0 * + col0 FROM tab0 GROUP BY tab0.col0
+----
+1849
+676
+6889
+
+query I rowsort
+SELECT ALL cor0.col2 + cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+158
+48
+76
+
+query I rowsort
+SELECT DISTINCT cor0.col2 FROM tab1 cor0 GROUP BY cor0.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT ALL + cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT cor0.col2 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+24
+38
+79
+
+query I rowsort label-106
+SELECT - 53 / cor0.col0 col0 FROM tab1 cor0 GROUP BY cor0.col0
+----
+-1
+-2
+0
+
+query I rowsort
+SELECT cor0.col1 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+0
+81
+
+query I rowsort
+SELECT DISTINCT + cor0.col1 col0 FROM tab2 cor0 GROUP BY cor0.col1, cor0.col0
+----
+41
+59
+61
+
+query I rowsort
+SELECT - cor0.col2 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col0, cor0.col2
+----
+-45
+-71
+-8
+
+query I rowsort
+SELECT cor0.col1 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col1
+----
+0
+81
+
+query I rowsort
+SELECT 25 AS col1 FROM tab2 cor0 GROUP BY cor0.col0
+----
+25
+25
+25
+
+query I rowsort
+SELECT cor0.col0 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT DISTINCT + 6 FROM tab1 cor0 GROUP BY col2, cor0.col0
+----
+6
+
+query I rowsort
+SELECT cor0.col2 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT ALL 72 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+72
+72
+72
+
+query I rowsort
+SELECT ALL + 73 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+73
+73
+73
+
+query I rowsort
+SELECT tab1.col0 AS col2 FROM tab1 GROUP BY col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT + cor0.col1 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT DISTINCT - cor0.col1 col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+-81
+0
+
+query I rowsort
+SELECT cor0.col0 * 51 FROM tab1 AS cor0 GROUP BY col0
+----
+1122
+1428
+4182
+
+query I rowsort
+SELECT ALL + 89 FROM tab2, tab1 AS cor0, tab1 AS cor1 GROUP BY cor0.col2
+----
+89
+89
+89
+
+query I rowsort
+SELECT ALL + cor0.col0 - + cor0.col0 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+0
+0
+0
+
+query I rowsort
+SELECT ALL 71 AS col0 FROM tab0 GROUP BY col1
+----
+71
+71
+
+query I rowsort
+SELECT - ( + cor0.col0 ) AS col1 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+-26
+-43
+-83
+
+query I rowsort
+SELECT 62 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+62
+62
+62
+
+query I rowsort
+SELECT ALL - 97 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+-97
+-97
+-97
+
+query I rowsort
+SELECT DISTINCT + 29 * ( cor0.col0 ) + + 47 FROM tab1 cor0 GROUP BY cor0.col0
+----
+2425
+685
+859
+
+query I rowsort
+SELECT DISTINCT col2 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT ALL 40 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+40
+40
+40
+
+query I rowsort
+SELECT cor0.col1 + cor0.col1 AS col2 FROM tab2 cor0 GROUP BY cor0.col1
+----
+118
+122
+82
+
+query I rowsort
+SELECT ( + cor0.col1 ) FROM tab2 AS cor0 GROUP BY cor0.col1, cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT cor0.col1 * + cor0.col1 col1 FROM tab1 AS cor0 GROUP BY cor0.col1
+----
+1936
+3249
+36
+
+query I rowsort
+SELECT ALL + cor0.col0 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT - 9 FROM tab2 AS cor0 GROUP BY cor0.col1, cor0.col1, col2
+----
+-9
+-9
+-9
+
+query I rowsort
+SELECT ALL - 7 * cor0.col1 FROM tab1 AS cor0 GROUP BY cor0.col0, cor0.col1
+----
+-308
+-399
+-42
+
+query I rowsort
+SELECT - 21 AS col2 FROM tab1 cor0 GROUP BY cor0.col1, cor0.col1
+----
+-21
+-21
+-21
+
+query I rowsort
+SELECT DISTINCT tab1.col2 FROM tab1 GROUP BY tab1.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT DISTINCT - 76 FROM tab2 GROUP BY tab2.col2
+----
+-76
+
+query I rowsort
+SELECT DISTINCT - cor0.col1 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+-41
+-59
+-61
+
+query I rowsort
+SELECT cor0.col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+0
+81
+
+query I rowsort
+SELECT ALL - cor0.col2 + - 55 AS col1 FROM tab0 AS cor0 GROUP BY col2
+----
+-134
+-79
+-93
+
+query I rowsort
+SELECT - + 28 FROM tab0, tab2 cor0 GROUP BY tab0.col1
+----
+-28
+-28
+
+query I rowsort
+SELECT ALL col1 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT ALL + 35 * 14 AS col1 FROM tab2 GROUP BY tab2.col1
+----
+490
+490
+490
+
+query I rowsort
+SELECT ALL cor0.col0 FROM tab2 AS cor0 GROUP BY cor0.col0, cor0.col1
+----
+15
+91
+92
+
+query I rowsort
+SELECT DISTINCT - cor0.col2 * 18 + + 56 FROM tab2 AS cor0 GROUP BY col2
+----
+-1366
+-1510
+-988
+
+query I rowsort
+SELECT cor0.col0 FROM tab0 cor0 GROUP BY col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT ALL - 38 AS col1 FROM tab2 GROUP BY tab2.col2
+----
+-38
+-38
+-38
+
+query I rowsort
+SELECT - 79 FROM tab0, tab0 cor0, tab0 AS cor1 GROUP BY cor1.col0
+----
+-79
+-79
+-79
+
+query I rowsort
+SELECT + cor0.col2 FROM tab1 cor0 GROUP BY cor0.col2, cor0.col1
+----
+45
+71
+8
+
+query I rowsort
+SELECT cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT cor0.col2 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col0
+----
+24
+38
+79
+
+query I rowsort
+SELECT + - 57 AS col1 FROM tab2 GROUP BY tab2.col2
+----
+-57
+-57
+-57
+
+query I rowsort
+SELECT ALL - cor0.col1 FROM tab2 cor0 GROUP BY cor0.col1
+----
+-41
+-59
+-61
+
+query I rowsort
+SELECT DISTINCT cor0.col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT - cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+-26
+-43
+-83
+
+query I rowsort
+SELECT ( - cor0.col1 ) FROM tab1 AS cor0 GROUP BY cor0.col1
+----
+-44
+-57
+-6
+
+query I rowsort
+SELECT DISTINCT - cor0.col2 FROM tab0 cor0 GROUP BY cor0.col2, cor0.col2
+----
+-24
+-38
+-79
+
+query I rowsort
+SELECT DISTINCT tab1.col1 * ( + tab1.col1 ) FROM tab1 GROUP BY col1
+----
+1936
+3249
+36
+
+query I rowsort
+SELECT - cor0.col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+-41
+-59
+-61
+
+query III rowsort
+SELECT * FROM tab2 AS cor0 GROUP BY cor0.col1, cor0.col2, cor0.col0
+----
+15 61 87
+91 59 79
+92 41 58
+
+query I rowsort
+SELECT + 83 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+83
+83
+83
+
+query I rowsort
+SELECT + ( 97 ) + - tab0.col1 FROM tab0, tab1 AS cor0 GROUP BY tab0.col1
+----
+16
+97
+
+query I rowsort
+SELECT 61 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+61
+61
+61
+
+query I rowsort
+SELECT ALL cor0.col2 FROM tab0 cor0 GROUP BY cor0.col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT cor0.col2 FROM tab0, tab1 AS cor0 GROUP BY cor0.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT + - 3 FROM tab2 GROUP BY col1
+----
+-3
+-3
+-3
+
+query I rowsort
+SELECT DISTINCT + 96 FROM tab2 GROUP BY tab2.col1
+----
+96
+
+query I rowsort
+SELECT ALL 81 FROM tab1 AS cor0 GROUP BY cor0.col1
+----
+81
+81
+81
+
+query I rowsort
+SELECT cor0.col0 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT - + 51 col2 FROM tab2, tab2 AS cor0 GROUP BY cor0.col1
+----
+-51
+-51
+-51
+
+query I rowsort
+SELECT cor0.col1 + - cor0.col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+0
+0
+0
+
+query I rowsort
+SELECT 35 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col1
+----
+35
+35
+35
+
+query I rowsort
+SELECT + tab2.col1 col0 FROM tab2 GROUP BY tab2.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT 37 AS col1 FROM tab0 AS cor0 GROUP BY col0
+----
+37
+37
+37
+
+query I rowsort
+SELECT + cor0.col1 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT cor0.col1 FROM tab2, tab1 AS cor0 GROUP BY cor0.col1
+----
+44
+57
+6
+
+query I rowsort
+SELECT ALL - col0 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+-22
+-28
+-82
+
+query I rowsort
+SELECT + 77 AS col1 FROM tab1 AS cor0 CROSS JOIN tab0 AS cor1 GROUP BY cor0.col2
+----
+77
+77
+77
+
+query I rowsort
+SELECT ALL cor0.col0 col1 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT + cor0.col2 * + cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col2
+----
+1032
+2054
+3154
+
+query I rowsort
+SELECT DISTINCT 39 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+39
+
+query III rowsort
+SELECT DISTINCT * FROM tab1 AS cor0 GROUP BY cor0.col0, cor0.col2, cor0.col1
+----
+22 6 8
+28 57 45
+82 44 71
+
+query I rowsort
+SELECT ALL + 28 FROM tab2 cor0 GROUP BY cor0.col0
+----
+28
+28
+28
+
+query I rowsort
+SELECT cor0.col0 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT ALL cor0.col2 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT + ( col0 ) * col0 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+225
+8281
+8464
+
+query I rowsort label-188
+SELECT - 21 - + 57 / cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+-21
+-22
+-23
+
+query I rowsort
+SELECT + 37 + cor0.col0 * cor0.col2 FROM tab2 AS cor0 GROUP BY cor0.col2, col0
+----
+1342
+5373
+7226
+
+query I rowsort
+SELECT ALL cor0.col2 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col0
+----
+45
+71
+8
+
+query III rowsort
+SELECT * FROM tab1 AS cor0 GROUP BY col2, cor0.col1, cor0.col0
+----
+22 6 8
+28 57 45
+82 44 71
+
+query I rowsort
+SELECT ( cor0.col2 ) AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT DISTINCT 28 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+28
+
+query I rowsort
+SELECT ALL - 18 FROM tab0, tab1 AS cor0 GROUP BY cor0.col0
----
+-18
+-18
+-18
+
+query I rowsort
+SELECT DISTINCT cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+24
38
+79
+
+query I rowsort
+SELECT + col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT - cor0.col0 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col1, cor0.col0
+----
+-22
+-28
+-82
+
+query I rowsort
+SELECT 29 FROM tab1 AS cor0 GROUP BY cor0.col1, cor0.col0
+----
+29
+29
+29
+
+query I rowsort
+SELECT - + cor0.col0 - 39 AS col0 FROM tab0, tab0 cor0 GROUP BY cor0.col0
+----
+-122
+-65
+-82
+
+query I rowsort
+SELECT ALL 45 AS col0 FROM tab0 GROUP BY tab0.col0
+----
+45
+45
+45
+
+query I rowsort
+SELECT + 74 AS col1 FROM tab1 GROUP BY tab1.col0
+----
+74
+74
+74
+
+query I rowsort
+SELECT cor0.col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort label-203
+SELECT - cor0.col2 + CAST ( 80 AS INTEGER ) FROM tab1 AS cor0 GROUP BY col2
+----
+35
+72
+9
+
+query I rowsort
+SELECT DISTINCT - cor0.col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+-81
+0
+
+query I rowsort
+SELECT - 51 * + cor0.col2 FROM tab0, tab2 cor0, tab1 AS cor1 GROUP BY cor0.col2
+----
+-2958
+-4029
+-4437
+
+query I rowsort
+SELECT ALL + col0 * cor0.col0 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+225
+8281
+8464
+
+query I rowsort
+SELECT DISTINCT ( col0 ) FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT 87 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+87
+87
+87
+
+query I rowsort
+SELECT + cor0.col0 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+# TODO: WRONG
Review Comment:
```suggestion
# TODO: WRONG
# https://github.com/apache/arrow-datafusion/issues/6099
```
##########
datafusion/core/tests/sqllogictests/test_files/groupby.slt:
##########
@@ -52,15 +52,1876 @@ INSERT INTO tab2 VALUES(91,59,79)
statement ok
INSERT INTO tab2 VALUES(92,41,58)
-# group by same column
-query I
-SELECT 38 FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col1;
+query I rowsort
+SELECT - tab1.col0 * 84 + + 38 AS col2 FROM tab1 GROUP BY tab1.col0
+----
+-1810
+-2314
+-6850
+
+query I rowsort
+SELECT + cor0.col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT DISTINCT - ( + col1 ) + - 51 AS col0 FROM tab1 AS cor0 GROUP BY col1
+----
+-108
+-57
+-95
+
+query I rowsort
+SELECT col1 * cor0.col1 * 56 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+194936
+208376
+94136
+
+query I rowsort label-4
+SELECT ALL + tab2.col1 / tab2.col1 FROM tab2 GROUP BY col1
+----
+1
+1
+1
+
+query I rowsort
+SELECT ALL + tab1.col0 FROM tab1 GROUP BY col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT DISTINCT tab1.col0 AS col1 FROM tab1 GROUP BY tab1.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT ALL col2 FROM tab1 GROUP BY col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT ALL + cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col2
+----
+26
+43
+83
+
+query III rowsort
+SELECT DISTINCT * FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col2, cor0.col0
+----
+26 0 79
+43 81 24
+83 0 38
+
+query III rowsort
+SELECT * FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col2, cor0.col0
+----
+26 0 79
+43 81 24
+83 0 38
+
+query I rowsort
+SELECT - 9 * cor0.col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+-369
+-531
+-549
+
+query I rowsort
+SELECT DISTINCT - 21 FROM tab2 GROUP BY col2
+----
+-21
+
+query I rowsort
+SELECT DISTINCT - 97 AS col2 FROM tab1 GROUP BY col0
+----
+-97
+
+query I rowsort
+SELECT + ( - 1 ) AS col0 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+-1
+-1
+-1
+
+query I rowsort
+SELECT - + cor0.col1 FROM tab0, tab0 cor0 GROUP BY cor0.col1
+----
+-81
+0
+
+query I rowsort
+SELECT + cor0.col0 + 36 AS col2 FROM tab0 AS cor0 GROUP BY col0
+----
+119
+62
+79
+
+query I rowsort
+SELECT cor0.col1 AS col1 FROM tab0 AS cor0 GROUP BY col1
+----
+0
+81
+
+query I rowsort
+SELECT DISTINCT + cor0.col1 FROM tab2 cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT ALL + cor0.col0 + - col0 col1 FROM tab1 AS cor0 GROUP BY col0
+----
+0
+0
+0
+
+query I rowsort
+SELECT ALL 54 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+54
+54
+54
+
+query I rowsort
+SELECT 40 AS col1 FROM tab1 cor0 GROUP BY cor0.col0
+----
+40
+40
+40
+
+query I rowsort
+SELECT DISTINCT ( cor0.col0 ) AS col0 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT 62 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+62
+62
+62
+
+query I rowsort
+SELECT 23 FROM tab2 GROUP BY tab2.col2
+----
+23
+23
+23
+
+query I rowsort
+SELECT + ( - tab0.col0 ) col2 FROM tab0, tab0 AS cor0 GROUP BY tab0.col0
+----
+-26
+-43
+-83
+
+query I rowsort
+SELECT + cor0.col1 FROM tab1 AS cor0 GROUP BY cor0.col1
+----
+44
+57
+6
+
+query I rowsort
+SELECT cor0.col1 FROM tab2 AS cor0 GROUP BY cor0.col1, cor0.col2
+----
+41
+59
+61
+
+query I rowsort
+SELECT DISTINCT + 80 + cor0.col2 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+104
+118
+159
+
+query I rowsort
+SELECT DISTINCT 30 * - 9 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+-270
+
+query I rowsort
+SELECT DISTINCT - col2 FROM tab1 AS cor0 GROUP BY col2
+----
+-45
+-71
+-8
+
+query I rowsort
+SELECT ALL - col2 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+-45
+-71
+-8
+
+query I rowsort
+SELECT DISTINCT + 82 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+82
+
+query I rowsort
+SELECT 79 * 19 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+1501
+1501
+1501
+
+query I rowsort
+SELECT ALL ( + 68 ) FROM tab1 cor0 GROUP BY cor0.col2
+----
+68
+68
+68
+
+query I rowsort
+SELECT - col0 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+-22
+-28
+-82
+
+query I rowsort
+SELECT + 81 col2 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+81
+81
+81
+
+query I rowsort
+SELECT ALL cor0.col2 AS col1 FROM tab2 cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT ALL + cor0.col0 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col1, cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT - cor0.col2 AS col0 FROM tab0 cor0 GROUP BY cor0.col2
+----
+-24
+-38
+-79
+
+query I rowsort
+SELECT cor0.col0 FROM tab1 AS cor0 GROUP BY col0, cor0.col1, cor0.col1
+----
+22
+28
+82
+
+query I rowsort
+SELECT 58 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+58
+58
+
+query I rowsort
+SELECT ALL cor0.col1 + - 20 AS col1 FROM tab0 cor0 GROUP BY cor0.col1
+----
+-20
+61
+
+query I rowsort
+SELECT ALL + col1 col0 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT DISTINCT - - 56 FROM tab2, tab0 AS cor0 GROUP BY cor0.col1
+----
+56
+
+query I rowsort
+SELECT - 10 AS col0 FROM tab2, tab1 AS cor0, tab2 AS cor1 GROUP BY cor1.col0
+----
+-10
+-10
+-10
+
+query I rowsort
+SELECT 31 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+31
+31
+31
+
+query I rowsort
+SELECT col2 AS col0 FROM tab0 cor0 GROUP BY cor0.col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT + 70 AS col1 FROM tab0 GROUP BY col0
+----
+70
+70
+70
+
+query I rowsort
+SELECT DISTINCT cor0.col1 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT - cor0.col1 FROM tab2, tab2 AS cor0 GROUP BY cor0.col1
+----
+-41
+-59
+-61
+
+query I rowsort
+SELECT DISTINCT + tab0.col0 col1 FROM tab0 GROUP BY tab0.col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT DISTINCT - cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+-24
+-38
+-79
+
+query I rowsort
+SELECT + cor0.col0 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT - 5 AS col2 FROM tab2, tab2 AS cor0, tab2 AS cor1 GROUP BY tab2.col1
+----
+-5
+-5
+-5
+
+query I rowsort
+SELECT DISTINCT 0 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+0
+
+query I rowsort
+SELECT DISTINCT - - tab2.col0 FROM tab2 GROUP BY col0
+----
+15
+91
+92
+
+query III rowsort
+SELECT DISTINCT * FROM tab2 AS cor0 GROUP BY cor0.col0, col1, cor0.col2
+----
+15 61 87
+91 59 79
+92 41 58
+
+query I rowsort label-58
+SELECT 9 / + cor0.col0 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col2
+----
+0
+0
+0
+
+query I rowsort
+SELECT ( - 72 ) AS col1 FROM tab1 cor0 GROUP BY cor0.col0, cor0.col2
+----
+-72
+-72
+-72
+
+query I rowsort
+SELECT cor0.col0 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT ( col0 ) FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort label-62
+SELECT ALL 59 / 26 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+2
+2
+2
+
+query I rowsort
+SELECT 15 FROM tab1 AS cor0 GROUP BY col2, col2
+----
+15
+15
+15
+
+query I rowsort
+SELECT CAST ( NULL AS INTEGER ) FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col2
+----
+NULL
+NULL
+NULL
+
+query I rowsort
+SELECT ALL - 79 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+-79
+-79
+-79
+
+query I rowsort
+SELECT ALL 69 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+69
+69
+69
+
+query I rowsort
+SELECT ALL 37 col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+37
+37
+
+query I rowsort
+SELECT ALL 55 * 15 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+825
+825
+825
+
+query I rowsort
+SELECT ( 63 ) FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+63
+63
+63
+
+query I rowsort
+SELECT - cor0.col2 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+-45
+-71
+-8
+
+query I rowsort
+SELECT - col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+-58
+-79
+-87
+
+query I rowsort
+SELECT ALL 81 * 11 FROM tab2 AS cor0 GROUP BY col1, cor0.col0
+----
+891
+891
+891
+
+query I rowsort
+SELECT ALL 9 FROM tab2 AS cor0 GROUP BY col2
+----
+9
+9
+9
+
+query I rowsort
+SELECT DISTINCT ( - 31 ) col1 FROM tab1 GROUP BY tab1.col0
+----
+-31
+
+query I rowsort label-75
+SELECT + + cor0.col0 / - cor0.col0 FROM tab1, tab0 AS cor0 GROUP BY cor0.col0
+----
+-1
+-1
+-1
+
+query I rowsort
+SELECT cor0.col2 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT ALL cor0.col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+0
+81
+
+query I rowsort
+SELECT ALL + - ( - tab0.col2 ) AS col0 FROM tab0 GROUP BY tab0.col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT 72 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+72
+72
+
+query I rowsort
+SELECT - 20 - + col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+-101
+-20
+
+query I rowsort
+SELECT - - 63 FROM tab1 GROUP BY tab1.col0
+----
+63
+63
+63
+
+query I rowsort
+SELECT cor0.col2 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col2, col1
+----
+45
+71
+8
+
+query I rowsort
+SELECT + cor0.col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+0
+81
+
+query I rowsort
+SELECT DISTINCT cor0.col1 FROM tab1 AS cor0 GROUP BY cor0.col1, cor0.col1
+----
+44
+57
+6
+
+query I rowsort
+SELECT cor0.col0 - col0 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+0
+0
+0
+
+query I rowsort
+SELECT 50 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+50
+50
+50
+
+query I rowsort
+SELECT - 18 AS col0 FROM tab1 cor0 GROUP BY cor0.col2
+----
+-18
+-18
+-18
+
+query I rowsort
+SELECT + cor0.col2 * cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col2
+----
+1444
+576
+6241
+
+query I rowsort
+SELECT ALL 91 / cor0.col1 FROM tab2 AS cor0 GROUP BY col1, cor0.col1
+----
+1
+1
+2
+
+query I rowsort
+SELECT cor0.col2 AS col2 FROM tab0 AS cor0 GROUP BY col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT ALL + 85 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+85
+85
+85
+
+query I rowsort
+SELECT + 49 AS col2 FROM tab0 cor0 GROUP BY cor0.col0
+----
+49
+49
+49
+
+query I rowsort
+SELECT cor0.col2 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT - col0 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+-15
+-91
+-92
+
+query I rowsort
+SELECT DISTINCT - 87 AS col1 FROM tab0 AS cor0 GROUP BY col0
+----
+-87
+
+query I rowsort
+SELECT + 39 FROM tab0 AS cor0 GROUP BY col1
+----
+39
+39
+
+query I rowsort
+SELECT ALL cor0.col2 * + col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+3364
+6241
+7569
+
+query I rowsort
+SELECT 40 FROM tab0 GROUP BY tab0.col1
+----
+40
+40
+
+query I rowsort
+SELECT tab1.col2 AS col0 FROM tab1 GROUP BY tab1.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT tab2.col0 FROM tab2 GROUP BY tab2.col0
+----
+15
+91
+92
+
+query I rowsort
+SELECT + col0 * + col0 FROM tab0 GROUP BY tab0.col0
+----
+1849
+676
+6889
+
+query I rowsort
+SELECT ALL cor0.col2 + cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+158
+48
+76
+
+query I rowsort
+SELECT DISTINCT cor0.col2 FROM tab1 cor0 GROUP BY cor0.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT ALL + cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT cor0.col2 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+24
+38
+79
+
+query I rowsort label-106
+SELECT - 53 / cor0.col0 col0 FROM tab1 cor0 GROUP BY cor0.col0
+----
+-1
+-2
+0
+
+query I rowsort
+SELECT cor0.col1 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+0
+81
+
+query I rowsort
+SELECT DISTINCT + cor0.col1 col0 FROM tab2 cor0 GROUP BY cor0.col1, cor0.col0
+----
+41
+59
+61
+
+query I rowsort
+SELECT - cor0.col2 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col0, cor0.col2
+----
+-45
+-71
+-8
+
+query I rowsort
+SELECT cor0.col1 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col1
+----
+0
+81
+
+query I rowsort
+SELECT 25 AS col1 FROM tab2 cor0 GROUP BY cor0.col0
+----
+25
+25
+25
+
+query I rowsort
+SELECT cor0.col0 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT DISTINCT + 6 FROM tab1 cor0 GROUP BY col2, cor0.col0
+----
+6
+
+query I rowsort
+SELECT cor0.col2 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT ALL 72 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+72
+72
+72
+
+query I rowsort
+SELECT ALL + 73 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+73
+73
+73
+
+query I rowsort
+SELECT tab1.col0 AS col2 FROM tab1 GROUP BY col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT + cor0.col1 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT DISTINCT - cor0.col1 col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+-81
+0
+
+query I rowsort
+SELECT cor0.col0 * 51 FROM tab1 AS cor0 GROUP BY col0
+----
+1122
+1428
+4182
+
+query I rowsort
+SELECT ALL + 89 FROM tab2, tab1 AS cor0, tab1 AS cor1 GROUP BY cor0.col2
+----
+89
+89
+89
+
+query I rowsort
+SELECT ALL + cor0.col0 - + cor0.col0 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+0
+0
+0
+
+query I rowsort
+SELECT ALL 71 AS col0 FROM tab0 GROUP BY col1
+----
+71
+71
+
+query I rowsort
+SELECT - ( + cor0.col0 ) AS col1 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+-26
+-43
+-83
+
+query I rowsort
+SELECT 62 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+62
+62
+62
+
+query I rowsort
+SELECT ALL - 97 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+-97
+-97
+-97
+
+query I rowsort
+SELECT DISTINCT + 29 * ( cor0.col0 ) + + 47 FROM tab1 cor0 GROUP BY cor0.col0
+----
+2425
+685
+859
+
+query I rowsort
+SELECT DISTINCT col2 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT ALL 40 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+40
+40
+40
+
+query I rowsort
+SELECT cor0.col1 + cor0.col1 AS col2 FROM tab2 cor0 GROUP BY cor0.col1
+----
+118
+122
+82
+
+query I rowsort
+SELECT ( + cor0.col1 ) FROM tab2 AS cor0 GROUP BY cor0.col1, cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT cor0.col1 * + cor0.col1 col1 FROM tab1 AS cor0 GROUP BY cor0.col1
+----
+1936
+3249
+36
+
+query I rowsort
+SELECT ALL + cor0.col0 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT - 9 FROM tab2 AS cor0 GROUP BY cor0.col1, cor0.col1, col2
+----
+-9
+-9
+-9
+
+query I rowsort
+SELECT ALL - 7 * cor0.col1 FROM tab1 AS cor0 GROUP BY cor0.col0, cor0.col1
+----
+-308
+-399
+-42
+
+query I rowsort
+SELECT - 21 AS col2 FROM tab1 cor0 GROUP BY cor0.col1, cor0.col1
+----
+-21
+-21
+-21
+
+query I rowsort
+SELECT DISTINCT tab1.col2 FROM tab1 GROUP BY tab1.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT DISTINCT - 76 FROM tab2 GROUP BY tab2.col2
+----
+-76
+
+query I rowsort
+SELECT DISTINCT - cor0.col1 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+-41
+-59
+-61
+
+query I rowsort
+SELECT cor0.col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+0
+81
+
+query I rowsort
+SELECT ALL - cor0.col2 + - 55 AS col1 FROM tab0 AS cor0 GROUP BY col2
+----
+-134
+-79
+-93
+
+query I rowsort
+SELECT - + 28 FROM tab0, tab2 cor0 GROUP BY tab0.col1
+----
+-28
+-28
+
+query I rowsort
+SELECT ALL col1 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT ALL + 35 * 14 AS col1 FROM tab2 GROUP BY tab2.col1
+----
+490
+490
+490
+
+query I rowsort
+SELECT ALL cor0.col0 FROM tab2 AS cor0 GROUP BY cor0.col0, cor0.col1
+----
+15
+91
+92
+
+query I rowsort
+SELECT DISTINCT - cor0.col2 * 18 + + 56 FROM tab2 AS cor0 GROUP BY col2
+----
+-1366
+-1510
+-988
+
+query I rowsort
+SELECT cor0.col0 FROM tab0 cor0 GROUP BY col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT ALL - 38 AS col1 FROM tab2 GROUP BY tab2.col2
+----
+-38
+-38
+-38
+
+query I rowsort
+SELECT - 79 FROM tab0, tab0 cor0, tab0 AS cor1 GROUP BY cor1.col0
+----
+-79
+-79
+-79
+
+query I rowsort
+SELECT + cor0.col2 FROM tab1 cor0 GROUP BY cor0.col2, cor0.col1
+----
+45
+71
+8
+
+query I rowsort
+SELECT cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT cor0.col2 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col0
+----
+24
+38
+79
+
+query I rowsort
+SELECT + - 57 AS col1 FROM tab2 GROUP BY tab2.col2
+----
+-57
+-57
+-57
+
+query I rowsort
+SELECT ALL - cor0.col1 FROM tab2 cor0 GROUP BY cor0.col1
+----
+-41
+-59
+-61
+
+query I rowsort
+SELECT DISTINCT cor0.col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT - cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+-26
+-43
+-83
+
+query I rowsort
+SELECT ( - cor0.col1 ) FROM tab1 AS cor0 GROUP BY cor0.col1
+----
+-44
+-57
+-6
+
+query I rowsort
+SELECT DISTINCT - cor0.col2 FROM tab0 cor0 GROUP BY cor0.col2, cor0.col2
+----
+-24
+-38
+-79
+
+query I rowsort
+SELECT DISTINCT tab1.col1 * ( + tab1.col1 ) FROM tab1 GROUP BY col1
+----
+1936
+3249
+36
+
+query I rowsort
+SELECT - cor0.col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+-41
+-59
+-61
+
+query III rowsort
+SELECT * FROM tab2 AS cor0 GROUP BY cor0.col1, cor0.col2, cor0.col0
+----
+15 61 87
+91 59 79
+92 41 58
+
+query I rowsort
+SELECT + 83 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+83
+83
+83
+
+query I rowsort
+SELECT + ( 97 ) + - tab0.col1 FROM tab0, tab1 AS cor0 GROUP BY tab0.col1
+----
+16
+97
+
+query I rowsort
+SELECT 61 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+61
+61
+61
+
+query I rowsort
+SELECT ALL cor0.col2 FROM tab0 cor0 GROUP BY cor0.col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT cor0.col2 FROM tab0, tab1 AS cor0 GROUP BY cor0.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT + - 3 FROM tab2 GROUP BY col1
+----
+-3
+-3
+-3
+
+query I rowsort
+SELECT DISTINCT + 96 FROM tab2 GROUP BY tab2.col1
+----
+96
+
+query I rowsort
+SELECT ALL 81 FROM tab1 AS cor0 GROUP BY cor0.col1
+----
+81
+81
+81
+
+query I rowsort
+SELECT cor0.col0 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT - + 51 col2 FROM tab2, tab2 AS cor0 GROUP BY cor0.col1
+----
+-51
+-51
+-51
+
+query I rowsort
+SELECT cor0.col1 + - cor0.col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+0
+0
+0
+
+query I rowsort
+SELECT 35 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col1
+----
+35
+35
+35
+
+query I rowsort
+SELECT + tab2.col1 col0 FROM tab2 GROUP BY tab2.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT 37 AS col1 FROM tab0 AS cor0 GROUP BY col0
+----
+37
+37
+37
+
+query I rowsort
+SELECT + cor0.col1 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+41
+59
+61
+
+query I rowsort
+SELECT cor0.col1 FROM tab2, tab1 AS cor0 GROUP BY cor0.col1
+----
+44
+57
+6
+
+query I rowsort
+SELECT ALL - col0 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+-22
+-28
+-82
+
+query I rowsort
+SELECT + 77 AS col1 FROM tab1 AS cor0 CROSS JOIN tab0 AS cor1 GROUP BY cor0.col2
+----
+77
+77
+77
+
+query I rowsort
+SELECT ALL cor0.col0 col1 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT + cor0.col2 * + cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col2
+----
+1032
+2054
+3154
+
+query I rowsort
+SELECT DISTINCT 39 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+39
+
+query III rowsort
+SELECT DISTINCT * FROM tab1 AS cor0 GROUP BY cor0.col0, cor0.col2, cor0.col1
+----
+22 6 8
+28 57 45
+82 44 71
+
+query I rowsort
+SELECT ALL + 28 FROM tab2 cor0 GROUP BY cor0.col0
+----
+28
+28
+28
+
+query I rowsort
+SELECT cor0.col0 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT ALL cor0.col2 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT + ( col0 ) * col0 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+225
+8281
+8464
+
+query I rowsort label-188
+SELECT - 21 - + 57 / cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+-21
+-22
+-23
+
+query I rowsort
+SELECT + 37 + cor0.col0 * cor0.col2 FROM tab2 AS cor0 GROUP BY cor0.col2, col0
+----
+1342
+5373
+7226
+
+query I rowsort
+SELECT ALL cor0.col2 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col0
+----
+45
+71
+8
+
+query III rowsort
+SELECT * FROM tab1 AS cor0 GROUP BY col2, cor0.col1, cor0.col0
+----
+22 6 8
+28 57 45
+82 44 71
+
+query I rowsort
+SELECT ( cor0.col2 ) AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+24
+38
+79
+
+query I rowsort
+SELECT DISTINCT 28 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+28
+
+query I rowsort
+SELECT ALL - 18 FROM tab0, tab1 AS cor0 GROUP BY cor0.col0
----
+-18
+-18
+-18
+
+query I rowsort
+SELECT DISTINCT cor0.col2 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+24
38
+79
+
+query I rowsort
+SELECT + col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT - cor0.col0 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col1, cor0.col0
+----
+-22
+-28
+-82
+
+query I rowsort
+SELECT 29 FROM tab1 AS cor0 GROUP BY cor0.col1, cor0.col0
+----
+29
+29
+29
+
+query I rowsort
+SELECT - + cor0.col0 - 39 AS col0 FROM tab0, tab0 cor0 GROUP BY cor0.col0
+----
+-122
+-65
+-82
+
+query I rowsort
+SELECT ALL 45 AS col0 FROM tab0 GROUP BY tab0.col0
+----
+45
+45
+45
+
+query I rowsort
+SELECT + 74 AS col1 FROM tab1 GROUP BY tab1.col0
+----
+74
+74
+74
+
+query I rowsort
+SELECT cor0.col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort label-203
+SELECT - cor0.col2 + CAST ( 80 AS INTEGER ) FROM tab1 AS cor0 GROUP BY col2
+----
+35
+72
+9
+
+query I rowsort
+SELECT DISTINCT - cor0.col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+-81
+0
+
+query I rowsort
+SELECT - 51 * + cor0.col2 FROM tab0, tab2 cor0, tab1 AS cor1 GROUP BY cor0.col2
+----
+-2958
+-4029
+-4437
+
+query I rowsort
+SELECT ALL + col0 * cor0.col0 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+225
+8281
+8464
+
+query I rowsort
+SELECT DISTINCT ( col0 ) FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+26
+43
+83
+
+query I rowsort
+SELECT 87 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+87
+87
+87
+
+query I rowsort
+SELECT + cor0.col0 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+# TODO: WRONG
+query I rowsort
+SELECT DISTINCT + 45 col0 FROM tab1 AS cor0 GROUP BY col0
+----
+45
+45
+
+query I rowsort label-211
+SELECT ALL CAST ( NULL AS INTEGER ) FROM tab2 AS cor0 GROUP BY col1
+----
+NULL
+NULL
+NULL
+
+query I rowsort
+SELECT ALL cor0.col1 + col1 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+0
+162
+
+query I rowsort
+SELECT - cor0.col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+-81
+0
+
+query I rowsort
+SELECT DISTINCT + 99 * 76 + + tab2.col1 AS col2 FROM tab2 GROUP BY col1
+----
+7565
+7583
+7585
+
+query I rowsort
+SELECT ALL 54 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+54
+54
+54
+
+query I rowsort
+SELECT + cor0.col2 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col2, cor0.col0
+----
+58
+79
+87
+
+query I rowsort
+SELECT cor0.col0 + + 87 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+109
+115
+169
+
+query I rowsort
+SELECT cor0.col0 FROM tab2 AS cor0 GROUP BY cor0.col0, cor0.col1, cor0.col0
+----
+15
+91
+92
+
+query I rowsort
+SELECT ALL col0 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT DISTINCT - cor0.col0 - + cor0.col0 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+-182
+-184
+-30
+
+query I rowsort
+SELECT ALL - 68 * + cor0.col1 FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col1
+----
+-5508
+0
+
+query I rowsort
+SELECT col2 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col2
+----
+24
38
+79
+
+query I rowsort
+SELECT ALL - 11 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+-11
+-11
+-11
+
+query I rowsort
+SELECT 66 AS col1 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+66
+66
+66
+
+query I rowsort
+SELECT - cor0.col2 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+-58
+-79
+-87
+
+query I rowsort
+SELECT ALL 37 FROM tab2, tab0 AS cor0 GROUP BY cor0.col1
+----
+37
+37
+
+query I rowsort
+SELECT DISTINCT + 20 col2 FROM tab0 GROUP BY tab0.col1
+----
+20
+
+query I rowsort
+SELECT 42 FROM tab0 cor0 GROUP BY col2
+----
+42
+42
+42
+
+query I rowsort
+SELECT ALL - cor0.col1 AS col1 FROM tab1 cor0 GROUP BY cor0.col1
+----
+-44
+-57
+-6
+
+query I rowsort
+SELECT - col2 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+-58
+-79
+-87
+
+query I rowsort
+SELECT DISTINCT + 86 FROM tab1 GROUP BY tab1.col2
+----
+86
+
+query I rowsort
+SELECT + cor0.col1 AS col1 FROM tab2, tab0 cor0 GROUP BY cor0.col1
+----
+0
+81
+
+query I rowsort
+SELECT - 13 FROM tab0 cor0 GROUP BY cor0.col1
+----
+-13
+-13
+
+query I rowsort
+SELECT tab1.col0 AS col1 FROM tab1 GROUP BY tab1.col0
+----
+22
+28
+82
query I rowsort
-SELECT cor0.col1 AS col2 FROM tab0 AS cor0 GROUP BY cor0.col1, cor0.col1;
+SELECT ALL cor0.col1 * cor0.col1 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col1
----
+1681
+3481
+3721
+
+query I rowsort
+SELECT - cor0.col0 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+-15
+-91
+-92
+
+query I rowsort
+SELECT cor0.col2 FROM tab1 AS cor0 GROUP BY cor0.col0, cor0.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT ALL - 67 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+-67
+-67
+-67
+
+query I rowsort
+SELECT + 75 AS col2 FROM tab1 cor0 GROUP BY cor0.col0
+----
+75
+75
+75
+
+query I rowsort
+SELECT ALL cor0.col1 FROM tab0 AS cor0 GROUP BY col0, cor0.col1
+----
+0
0
81
+
+query I rowsort
+SELECT ALL + cor0.col1 FROM tab0 AS cor0 GROUP BY col1
+----
+0
+81
+
+query I rowsort
+SELECT DISTINCT - 38 - - cor0.col0 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+-12
+45
+5
+
+query I rowsort
+SELECT + cor0.col0 + - col0 + 21 AS col0 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+21
+21
+21
+
+query I rowsort
+SELECT + cor0.col0 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col0, cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT ALL - cor0.col0 FROM tab0 AS cor0 GROUP BY cor0.col0, cor0.col0
+----
+-26
+-43
+-83
+
+query III rowsort
+SELECT * FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col1, cor0.col0
+----
+26 0 79
+43 81 24
+83 0 38
+
+query I rowsort
+SELECT DISTINCT + + tab2.col2 FROM tab2, tab1 AS cor0 GROUP BY tab2.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT cor0.col0 AS col1 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+15
+91
+92
+
+query I rowsort
+SELECT col0 AS col0 FROM tab2 AS cor0 GROUP BY cor0.col0
+----
+15
+91
+92
+
+query I rowsort
+SELECT - cor0.col0 AS col1 FROM tab1 AS cor0 GROUP BY col0
+----
+-22
+-28
+-82
+
+query I rowsort
+SELECT DISTINCT ( + 71 ) col1 FROM tab1 GROUP BY tab1.col2
+----
+71
+
+query I rowsort
+SELECT + 96 * 29 col1 FROM tab2, tab1 AS cor0 GROUP BY tab2.col0
+----
+2784
+2784
+2784
+
+query I rowsort
+SELECT + 3 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+3
+3
+3
+
+query I rowsort
+SELECT 37 FROM tab0 AS cor0 GROUP BY col0
+----
+37
+37
+37
+
+query I rowsort
+SELECT 82 FROM tab0 cor0 GROUP BY cor0.col1
+----
+82
+82
+
+query I rowsort
+SELECT cor0.col2 FROM tab2 cor0 GROUP BY cor0.col2
+----
+58
+79
+87
+
+query I rowsort
+SELECT DISTINCT - 87 FROM tab1, tab2 AS cor0, tab2 AS cor1 GROUP BY tab1.col0
+----
+-87
+
+query I rowsort
+SELECT 55 FROM tab1 AS cor0 GROUP BY cor0.col2, cor0.col1
+----
+55
+55
+55
+
+query I rowsort
+SELECT DISTINCT 35 FROM tab0 cor0 GROUP BY cor0.col2, cor0.col0
+----
+35
+
+query I rowsort
+SELECT cor0.col0 FROM tab2 cor0 GROUP BY col0
+----
+15
+91
+92
+
+query I rowsort
+SELECT - cor0.col2 AS col1 FROM tab1 AS cor0 GROUP BY col2
+----
+-45
+-71
+-8
+
+query I rowsort
+SELECT ALL ( cor0.col2 ) AS col1 FROM tab2, tab1 AS cor0 GROUP BY cor0.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT DISTINCT - col2 FROM tab1 GROUP BY tab1.col2
+----
+-45
+-71
+-8
+
+query I rowsort
+SELECT 38 FROM tab1 AS cor0 GROUP BY cor0.col1, cor0.col1
+----
+38
+38
+38
+
+query I rowsort
+SELECT - 16 * - cor0.col0 * 47 FROM tab0 AS cor0 GROUP BY cor0.col0
+----
+19552
+32336
+62416
+
+query I rowsort
+SELECT - 31 FROM tab2 AS cor0 GROUP BY cor0.col2
+----
+-31
+-31
+-31
+
+query I rowsort
+SELECT ( + 34 ) AS col1 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+34
+34
+34
+
+query I rowsort
+SELECT cor0.col2 AS col0 FROM tab1 AS cor0 GROUP BY cor0.col2
+----
+45
+71
+8
+
+query I rowsort
+SELECT DISTINCT 21 FROM tab0 AS cor0 GROUP BY cor0.col2
+----
+21
+
+query I rowsort
+SELECT 62 AS col2 FROM tab0 cor0 GROUP BY cor0.col1, cor0.col2
+----
+62
+62
+62
+
+query I rowsort
+SELECT cor0.col0 FROM tab1 cor0 GROUP BY cor0.col0, cor0.col1
+----
+22
+28
+82
+
+query I rowsort
+SELECT DISTINCT cor0.col0 FROM tab2 AS cor0 GROUP BY cor0.col0, col1
+----
+15
+91
+92
+
+query I rowsort
+SELECT DISTINCT cor0.col0 AS col2 FROM tab1 AS cor0 GROUP BY cor0.col0
+----
+22
+28
+82
+
+query I rowsort
+SELECT ALL - ( 30 ) * + cor0.col1 AS col2 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+-1230
+-1770
+-1830
+
+# TODO: WRONG
Review Comment:
Can we please add a reference to the ticket here too?
```suggestion
# TODO: WRONG
# https://github.com/apache/arrow-datafusion/issues/6099
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org