This is an automated email from the ASF dual-hosted git repository.
jakevin pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git
The following commit(s) were added to refs/heads/main by this push:
new 1a277acd59 test: more sqllogicaltest for GROUPBY. (#6100)
1a277acd59 is described below
commit 1a277acd59111bd6be763167c9fc5a0fbcd1e74e
Author: jakevin <[email protected]>
AuthorDate: Mon Apr 24 12:10:36 2023 +0800
test: more sqllogicaltest for GROUPBY. (#6100)
* test: more sqllogicaltest for GROUPBY.
* fix test
* add issue link
---
.../tests/sqllogictests/test_files/groupby.slt | 1872 +++++++++++++++++++-
1 file changed, 1868 insertions(+), 4 deletions(-)
diff --git a/datafusion/core/tests/sqllogictests/test_files/groupby.slt
b/datafusion/core/tests/sqllogictests/test_files/groupby.slt
index 83981095bf..4693423b3a 100644
--- a/datafusion/core/tests/sqllogictests/test_files/groupby.slt
+++ b/datafusion/core/tests/sqllogictests/test_files/groupby.slt
@@ -52,15 +52,1879 @@ 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
+# https://github.com/apache/arrow-datafusion/issues/6099
+query I rowsort
+SELECT DISTINCT + 45 col0 FROM tab1 AS cor0 GROUP BY col0
+----
+45
+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
+# https://github.com/apache/arrow-datafusion/issues/6099
+query I rowsort
+SELECT DISTINCT 94 AS col1 FROM tab0 AS cor0 GROUP BY cor0.col1
+----
+94
+94
+
+query I rowsort
+SELECT DISTINCT + col1 FROM tab2 AS cor0 GROUP BY cor0.col1
+----
+41
+59
+61
