Changeset: 39087e54cd4a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=39087e54cd4a
Modified Files:
sql/test/SQLite_regress/sqllogictest/Tests/select2.test.sql
sql/test/SQLite_regress/sqllogictest/Tests/select2.test.stable.out
sql/test/SQLite_regress/sqllogictest/Tests/select2.test.stable.out.int128
Branch: Jul2015
Log Message:
Added ORDER BY part to all 1000 SELECT queries to get stable output of
resultset data on all platforms
diffs (truncated from 76946 to 300 lines):
diff --git a/sql/test/SQLite_regress/sqllogictest/Tests/select2.test.sql
b/sql/test/SQLite_regress/sqllogictest/Tests/select2.test.sql
--- a/sql/test/SQLite_regress/sqllogictest/Tests/select2.test.sql
+++ b/sql/test/SQLite_regress/sqllogictest/Tests/select2.test.sql
@@ -33,7 +33,7 @@ INSERT INTO t1(e,d,c,b,a) VALUES(246,248
-- query I rowsort
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 efdbaa4d180e7867bec1c4d897bd25b9
-- query IIIIIII rowsort
@@ -47,7 +47,7 @@ SELECT e,
a+b*2+c*3+d*4
FROM t1
WHERE a>b
-;
+ORDER BY 1,2,3,4,5,6,7;
-- 119 values hashing to 46c6841abfae8913a6759ec6f454ab0f
-- query III rowsort
@@ -57,7 +57,7 @@ SELECT abs(b-c),
FROM t1
WHERE coalesce(a,b,c,d,e)<>0
AND (a>b-2 AND a<b+2)
-;
+ORDER BY 1,2,3;
-- 24 values hashing to 0451564addcc49504e7dd88be40b3e69
-- query IIII rowsort
@@ -67,7 +67,7 @@ SELECT a,
d
FROM t1
WHERE a IS NULL
-;
+ORDER BY 1,2,3,4;
-- NULL
-- 1
-- NULL
@@ -83,7 +83,7 @@ SELECT (SELECT count(*) FROM t1 AS x WHE
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR (a>b-2 AND a<b+2)
-;
+ORDER BY 1,2;
-- 20 values hashing to 4107afddb1186b30a9105bf7bf09f540
-- query IIIIII rowsort
@@ -98,13 +98,13 @@ SELECT a+b*2+c*3,
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR b IS NOT NULL
-;
+ORDER BY 1,2,3,4,5,6;
-- 174 values hashing to 777dcbc0198356b9c12bf01fa545f68c
-- query I rowsort
SELECT abs(b-c)
FROM t1
-;
+ORDER BY 1;
-- 30 values hashing to c289bcde2e1a495d6cc09dde069c6c87
-- query I rowsort
@@ -113,7 +113,7 @@ SELECT a+b*2
WHERE (a>b-2 AND a<b+2)
AND b IS NOT NULL
AND a>b
-;
+ORDER BY 1;
-- 391
-- 475
-- 502
@@ -134,7 +134,7 @@ SELECT c,
WHERE (c<=d-2 OR c>=d+2)
AND coalesce(a,b,c,d,e)<>0
AND c>d
-;
+ORDER BY 1,2,3,4,5,6,7;
-- 35 values hashing to b523d6b6df543010b45626657adada9d
-- query IIIIIII rowsort
@@ -149,7 +149,7 @@ SELECT d,
FROM t1
WHERE b>c
AND (e>c OR e<d)
-;
+ORDER BY 1,2,3,4,5,6,7;
-- 63 values hashing to 80800d1e987b7049fa5d57c55815bf4c
-- query IIIIIII rowsort
@@ -163,7 +163,7 @@ SELECT e,
FROM t1
WHERE b IS NOT NULL
AND coalesce(a,b,c,d,e)<>0
-;
+ORDER BY 1,2,3,4,5,6,7;
-- 189 values hashing to e421c85cd0132772b0b7762c78066abb
-- query IIII rowsort
@@ -175,7 +175,7 @@ SELECT (SELECT count(*) FROM t1 AS x WHE
WHERE d NOT BETWEEN 110 AND 150
AND c>d
AND c BETWEEN b-2 AND d+2
-;
+ORDER BY 1,2,3,4;
-- 24 values hashing to 83cde3379decb55b28d3ac450c6f9881
-- query IIII rowsort
@@ -187,7 +187,7 @@ SELECT a+b*2+c*3+d*4+e*5,
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND (e>c OR e<d)
-;
+ORDER BY 1,2,3,4;
-- 1612
-- 107
-- 108
@@ -200,7 +200,7 @@ SELECT a+b*2+c*3+d*4+e*5,
-- query I rowsort
SELECT (SELECT count(*) FROM t1 AS x WHERE x.c>t1.c AND x.d<t1.d)
FROM t1
-;
+ORDER BY 1;
-- 30 values hashing to ec9f02c46c399db521c47dd9cb6a40dd
-- query III rowsort
@@ -211,7 +211,7 @@ SELECT d-e,
WHERE coalesce(a,b,c,d,e)<>0
OR b>c
OR b IS NOT NULL
-;
+ORDER BY 1,2,3;
-- 90 values hashing to 7be06d7255991a0b921d169b65e408c0
-- query IIIIIII rowsort
@@ -225,7 +225,7 @@ SELECT CASE WHEN c>(SELECT avg(c) FROM t
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a-b
FROM t1
-;
+ORDER BY 1,2,3,4,5,6,7;
-- 210 values hashing to 292b0a5b2821884ba5d11e217b76fbd7
-- query III rowsort
@@ -237,7 +237,7 @@ SELECT a+b*2+c*3+d*4+e*5,
WHERE coalesce(a,b,c,d,e)<>0
OR b>c
OR a>b
-;
+ORDER BY 1,2,3;
-- 90 values hashing to f2ff447495c871e67c605d2c0b5e70ec
-- query III rowsort
@@ -248,7 +248,7 @@ SELECT (SELECT count(*) FROM t1 AS x WHE
WHERE c BETWEEN b-2 AND d+2
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND b IS NOT NULL
-;
+ORDER BY 1,2,3;
-- 42 values hashing to d2467d2f2cfae3b29ec7f4a5152f36c4
-- query IIIII rowsort
@@ -259,7 +259,7 @@ SELECT a+b*2+c*3,
CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END
FROM t1
WHERE c>d
-;
+ORDER BY 1,2,3,4,5;
-- 65 values hashing to 5ed50f9b86136acfad54696420ffa1f0
-- query IIIII rowsort
@@ -269,7 +269,7 @@ SELECT e,
d,
a+b*2+c*3+d*4
FROM t1
-;
+ORDER BY 1,2,3,4,5;
-- 150 values hashing to a030f689f5a0035d4db42d5da9f4b7a7
-- query III rowsort
@@ -279,7 +279,7 @@ SELECT e,
FROM t1
WHERE EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
AND d NOT BETWEEN 110 AND 150
-;
+ORDER BY 1,2,3;
-- 42 values hashing to e0970228aa8a30d2050cfd3c11be9185
-- query IIIIII rowsort
@@ -293,7 +293,7 @@ SELECT a+b*2,
WHERE (e>c OR e<d)
OR (e>a AND e<b)
OR a IS NULL
-;
+ORDER BY 1,2,3,4,5,6;
-- 138 values hashing to bf08a6d9c0db20af06d88ca646cda804
-- query III rowsort
@@ -304,7 +304,7 @@ SELECT CASE WHEN c>(SELECT avg(c) FROM t
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
OR c>d
-;
+ORDER BY 1,2,3;
-- 45 values hashing to a15fae7379de155bbaeb251f575a7db0
-- query IIII rowsort
@@ -315,7 +315,7 @@ SELECT abs(b-c),
FROM t1
WHERE a IS NULL
OR d NOT BETWEEN 110 AND 150
-;
+ORDER BY 1,2,3,4;
-- 72 values hashing to 12fdbfddf3f67b7da4a8224b4e2798a6
-- query IIIII rowsort
@@ -328,7 +328,7 @@ SELECT a,
WHERE (a>b-2 AND a<b+2)
OR b IS NOT NULL
OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
-;
+ORDER BY 1,2,3,4,5;
-- 135 values hashing to cb5eb3ba2131bf64c07defbe3cb6e3af
-- query IIIII rowsort
@@ -341,7 +341,7 @@ SELECT a-b,
WHERE b>c
AND coalesce(a,b,c,d,e)<>0
AND (e>a AND e<b)
-;
+ORDER BY 1,2,3,4,5;
-- 10 values hashing to 4457dbfe4ab387a5f8f9b308280689f6
-- query IIIIII rowsort
@@ -353,7 +353,7 @@ SELECT abs(b-c),
CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222
WHEN a<b+3 THEN 333 ELSE 444 END
FROM t1
-;
+ORDER BY 1,2,3,4,5,6;
-- 180 values hashing to bb777feb11708e8bab6a2441bd11b89e
-- query IIIIIII rowsort
@@ -369,7 +369,7 @@ SELECT a-b,
WHERE b IS NOT NULL
AND e+d BETWEEN a+b-10 AND c+130
AND c BETWEEN b-2 AND d+2
-;
+ORDER BY 1,2,3,4,5,6,7;
-- 2
-- -1
-- 107
@@ -384,7 +384,7 @@ SELECT a+b*2+c*3+d*4,
FROM t1
WHERE e+d BETWEEN a+b-10 AND c+130
AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b)
-;
+ORDER BY 1,2;
-- 1272
-- 1290
@@ -393,7 +393,7 @@ SELECT CASE a+1 WHEN b THEN 111 WHEN c T
WHEN d THEN 333 WHEN e THEN 444 ELSE 555 END,
a+b*2+c*3+d*4
FROM t1
-;
+ORDER BY 1,2;
-- 60 values hashing to c1e3a4310060dcd710dc9c750c881699
-- query IIIIIII rowsort
@@ -408,7 +408,7 @@ SELECT CASE WHEN c>(SELECT avg(c) FROM t
FROM t1
WHERE a IS NULL
AND d>e
-;
+ORDER BY 1,2,3,4,5,6,7;
-- 1120
-- NULL
-- 555
@@ -425,7 +425,7 @@ SELECT (a+b+c+d+e)/5,
FROM t1
WHERE d NOT BETWEEN 110 AND 150
OR (a>b-2 AND a<b+2)
-;
+ORDER BY 1,2,3,4;
-- 88 values hashing to b22693af4f023122fff8a50a5e372bda
-- query II rowsort
@@ -433,7 +433,7 @@ SELECT (a+b+c+d+e)/5,
d
FROM t1
WHERE b IS NOT NULL
-;
+ORDER BY 1,2;
-- 54 values hashing to 1b7def90663182338e06a1cf6a69716c
-- query II rowsort
@@ -443,7 +443,7 @@ SELECT a+b*2+c*3,
WHERE b IS NOT NULL
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
