Changeset: e6ea8bdbfbd7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e6ea8bdbfbd7
Modified Files:
sql/test/SQLite_regress/sqllogictest/Tests/select3.test
Branch: Aug2024
Log Message:
Revert test from sqllogictest.
diffs (truncated from 27312 to 300 lines):
diff --git a/sql/test/SQLite_regress/sqllogictest/Tests/select3.test
b/sql/test/SQLite_regress/sqllogictest/Tests/select3.test
--- a/sql/test/SQLite_regress/sqllogictest/Tests/select3.test
+++ b/sql/test/SQLite_regress/sqllogictest/Tests/select3.test
@@ -99,12 +99,12 @@ SELECT CASE WHEN c>(SELECT avg(c) FROM t
----
30 values hashing to efdbaa4d180e7867bec1c4d897bd25b9
-query I nosort x0
+query I rowsort x0
SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
ORDER BY 1
----
-30 values hashing to 89034ce300947389af564589af8a89f1
+30 values hashing to efdbaa4d180e7867bec1c4d897bd25b9
query II rowsort x1
SELECT a+b*2+c*3+d*4+e*5,
@@ -113,13 +113,13 @@ SELECT a+b*2+c*3+d*4+e*5,
----
60 values hashing to f5182c92f97475673097a499ce82ae64
-query II nosort x1
-SELECT a+b*2+c*3+d*4+e*5,
- (a+b+c+d+e)/5
- FROM t1
- ORDER BY 1,2
-----
-60 values hashing to 25594adb22d44ca00690acfe1602b943
+query II rowsort x1
+SELECT a+b*2+c*3+d*4+e*5,
+ (a+b+c+d+e)/5
+ FROM t1
+ ORDER BY 1,2
+----
+60 values hashing to f5182c92f97475673097a499ce82ae64
query IIIII rowsort x2
SELECT a+b*2+c*3+d*4+e*5,
@@ -135,7 +135,7 @@ SELECT a+b*2+c*3+d*4+e*5,
----
55 values hashing to 625899fde153a4e776b22705ac30f7fb
-query IIIII nosort x2
+query IIIII rowsort x2
SELECT a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
@@ -148,7 +148,7 @@ SELECT a+b*2+c*3+d*4+e*5,
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
ORDER BY 2,4
----
-55 values hashing to 21ecb70588f8519d3c93de59ed6949e1
+55 values hashing to 625899fde153a4e776b22705ac30f7fb
query IIIII rowsort x2
SELECT a+b*2+c*3+d*4+e*5,
@@ -164,7 +164,7 @@ SELECT a+b*2+c*3+d*4+e*5,
----
55 values hashing to 625899fde153a4e776b22705ac30f7fb
-query IIIII nosort x2
+query IIIII rowsort x2
SELECT a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
@@ -177,7 +177,7 @@ SELECT a+b*2+c*3+d*4+e*5,
AND d>e
ORDER BY 3,2,5,1,4
----
-55 values hashing to 6a9135783ae80346b9ea72e72ffafdf5
+55 values hashing to 625899fde153a4e776b22705ac30f7fb
query IIIII rowsort x2
SELECT a+b*2+c*3+d*4+e*5,
@@ -193,7 +193,7 @@ SELECT a+b*2+c*3+d*4+e*5,
----
55 values hashing to 625899fde153a4e776b22705ac30f7fb
-query IIIII nosort x2
+query IIIII rowsort x2
SELECT a+b*2+c*3+d*4+e*5,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
@@ -206,7 +206,7 @@ SELECT a+b*2+c*3+d*4+e*5,
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
ORDER BY 3,2,1,5
----
-55 values hashing to 6a9135783ae80346b9ea72e72ffafdf5
+55 values hashing to 625899fde153a4e776b22705ac30f7fb
query IIIII rowsort x3
SELECT a,
@@ -219,7 +219,7 @@ SELECT a,
----
15 values hashing to a9ad8d5d73081dc1d90969f10a494afa
-query IIIII nosort x3
+query IIIII rowsort x3
SELECT a,
a+b*2+c*3+d*4,
e,
@@ -240,7 +240,7 @@ SELECT a+b*2+c*3+d*4,
----
90 values hashing to 0f041784f194ec63cf2a252e8dc9b8d2
-query III nosort x4
+query III rowsort x4
SELECT a+b*2+c*3+d*4,
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END,
@@ -248,7 +248,7 @@ SELECT a+b*2+c*3+d*4,
FROM t1
ORDER BY 1,2,3
----
-90 values hashing to 68afc85758a3947443cb15a9c709e22a
+90 values hashing to 0f041784f194ec63cf2a252e8dc9b8d2
query IIII rowsort x5
SELECT b,
@@ -262,7 +262,7 @@ SELECT b,
AND b>c
----
-query IIII nosort x5
+query IIII rowsort x5
SELECT b,
a+b*2+c*3,
c-d,
@@ -287,7 +287,7 @@ SELECT b,
AND (a>b-2 AND a<b+2)
----
-query IIII nosort x5
+query IIII rowsort x5
SELECT b,
a+b*2+c*3,
c-d,
@@ -312,7 +312,7 @@ SELECT b,
AND b>c
----
-query IIII nosort x5
+query IIII rowsort x5
SELECT b,
a+b*2+c*3,
c-d,
@@ -337,7 +337,7 @@ SELECT b,
AND (e>a AND e<b)
----
-query IIII nosort x5
+query IIII rowsort x5
SELECT b,
a+b*2+c*3,
c-d,
@@ -362,7 +362,7 @@ SELECT e,
----
80 values hashing to 1165928153cf03fadf7d270e4efc8a8b
-query IIIII nosort x6
+query IIIII rowsort x6
SELECT e,
a,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
@@ -373,7 +373,7 @@ SELECT e,
OR d>e
ORDER BY 3,1,5,2,4
----
-80 values hashing to 9ae0fc404535bae2320bf2ee02f3a111
+80 values hashing to 1165928153cf03fadf7d270e4efc8a8b
query IIIII rowsort x6
SELECT e,
@@ -387,7 +387,7 @@ SELECT e,
----
80 values hashing to 1165928153cf03fadf7d270e4efc8a8b
-query IIIII nosort x6
+query IIIII rowsort x6
SELECT e,
a,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END,
@@ -398,7 +398,7 @@ SELECT e,
OR (c<=d-2 OR c>=d+2)
ORDER BY 4,1,5,3,2
----
-80 values hashing to f6c0b3d0c02c63b20f754ae7f36dd622
+80 values hashing to 1165928153cf03fadf7d270e4efc8a8b
query I rowsort x7
SELECT a+b*2+c*3+d*4+e*5
@@ -406,12 +406,12 @@ SELECT a+b*2+c*3+d*4+e*5
----
30 values hashing to f54b614acd4cb798dba29ba05152f26d
-query I nosort x7
+query I rowsort x7
SELECT a+b*2+c*3+d*4+e*5
FROM t1
ORDER BY 1
----
-30 values hashing to 5f0b79eeee903fb989964b2be6f4df7a
+30 values hashing to f54b614acd4cb798dba29ba05152f26d
query I rowsort x8
SELECT d-e
@@ -421,14 +421,14 @@ SELECT d-e
----
24 values hashing to b60e9de3a50740f40cca35b98a056b8c
-query I nosort x8
+query I rowsort x8
SELECT d-e
FROM t1
WHERE b>c
OR a>b
ORDER BY 1
----
-24 values hashing to 76a711ba9d533ba8f6ab138b4ac63241
+24 values hashing to b60e9de3a50740f40cca35b98a056b8c
query I rowsort x9
SELECT d
@@ -438,14 +438,14 @@ SELECT d
----
22 values hashing to 785796b507b0f3998ec9b04e74fa565b
-query I nosort x9
+query I rowsort x9
SELECT d
FROM t1
WHERE a>b
OR d>e
ORDER BY 1
----
-22 values hashing to 82b4fb525b221666886bfe76e269415b
+22 values hashing to 785796b507b0f3998ec9b04e74fa565b
query I rowsort x9
SELECT d
@@ -455,14 +455,14 @@ SELECT d
----
22 values hashing to 785796b507b0f3998ec9b04e74fa565b
-query I nosort x9
+query I rowsort x9
SELECT d
FROM t1
WHERE d>e
OR a>b
ORDER BY 1
----
-22 values hashing to 82b4fb525b221666886bfe76e269415b
+22 values hashing to 785796b507b0f3998ec9b04e74fa565b
query IIIIIII rowsort x10
SELECT abs(a),
@@ -477,7 +477,7 @@ SELECT abs(a),
----
119 values hashing to de49937f8a76d58e90ee610d71c5d209
-query IIIIIII nosort x10
+query IIIIIII rowsort x10
SELECT abs(a),
(a+b+c+d+e)/5,
a+b*2+c*3+d*4,
@@ -489,7 +489,7 @@ SELECT abs(a),
WHERE a>b
ORDER BY 7,3,5,1,6
----
-119 values hashing to 3039f2cda202d621e12f9671b0bbe87e
+119 values hashing to de49937f8a76d58e90ee610d71c5d209
query III rowsort x11
SELECT d,
@@ -499,14 +499,14 @@ SELECT d,
----
90 values hashing to df4215319598e8101abcb5c7509649e8
-query III nosort x11
+query III rowsort x11
SELECT d,
a,
a+b*2+c*3+d*4+e*5
FROM t1
ORDER BY 2,3
----
-90 values hashing to f304e98b0c59ba35dfdff2e6b2b36f27
+90 values hashing to df4215319598e8101abcb5c7509649e8
query III rowsort x12
SELECT d-e,
@@ -519,7 +519,7 @@ SELECT d-e,
----
72 values hashing to 5026537fcfcc7d06e2928e16f9b160fc
-query III nosort x12
+query III rowsort x12
SELECT d-e,
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
