Changeset: d028d436c36e for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d028d436c36e
Modified Files:
sql/test/SQLite_regress/sqllogictest/Tests/select4.test.sql
sql/test/SQLite_regress/sqllogictest/Tests/select4.test.stable.out
sql/test/SQLite_regress/sqllogictest/Tests/select4.test.stable.out.int128
Branch: Jul2015
Log Message:
Added ORDER BY part to all 2832 SELECT queries to get stable output of
resultset data on all platforms
diffs (truncated from 2927074 to 300 lines):
diff --git a/sql/test/SQLite_regress/sqllogictest/Tests/select4.test.sql
b/sql/test/SQLite_regress/sqllogictest/Tests/select4.test.sql
--- a/sql/test/SQLite_regress/sqllogictest/Tests/select4.test.sql
+++ b/sql/test/SQLite_regress/sqllogictest/Tests/select4.test.sql
@@ -1073,47 +1073,47 @@ INSERT INTO t1 VALUES(996,297,177,577,60
-- query IIIIIT rowsort all1
SELECT * FROM t1
-;
+ORDER BY 1,2,3,4,5,6;
-- 768 values hashing to 5d3fe674077ba48f8afa1c6f4e61ced4
-- query IIIIIT rowsort all2
SELECT * FROM t2
-;
+ORDER BY 1,2,3,4,5,6;
-- 678 values hashing to 09dd0a67e7c6bbb0b2aa2bc8364b9cb8
-- query IIIIIT rowsort all3
SELECT * FROM t3
-;
+ORDER BY 1,2,3,4,5,6;
-- 774 values hashing to a4da0dfc78895ffb5c59ae7f49afed54
-- query IIIIIT rowsort all4
SELECT * FROM t4
-;
+ORDER BY 1,2,3,4,5,6;
-- 666 values hashing to 66f651904b7b83fadcbddc7f15fc16b1
-- query IIIIIT rowsort all5
SELECT * FROM t5
-;
+ORDER BY 1,2,3,4,5,6;
-- 660 values hashing to 168733c3c947e4cd1b1cad5b997ece30
-- query IIIIIT rowsort all6
SELECT * FROM t6
-;
+ORDER BY 1,2,3,4,5,6;
-- 552 values hashing to 1498df6d8ab3f812e84f8e318dc53704
-- query IIIIIT rowsort all7
SELECT * FROM t7
-;
+ORDER BY 1,2,3,4,5,6;
-- 660 values hashing to fa70f972b3a5f3339f77037444cb54d5
-- query IIIIIT rowsort all8
SELECT * FROM t8
-;
+ORDER BY 1,2,3,4,5,6;
-- 654 values hashing to 55dc70aa8548b692aa3a7f2156fdeea5
-- query IIIIIT rowsort all9
SELECT * FROM t9
-;
+ORDER BY 1,2,3,4,5,6;
-- 588 values hashing to be47bb47837e44b32abdcfb5f1645153
CREATE INDEX t1i0 ON t1(a1,b1,c1,d1,e1,x1);
CREATE INDEX t1i1 ON t1(b1,c1,d1,e1,x1);
@@ -1134,47 +1134,47 @@ CREATE INDEX t8all ON t8(e8 DESC, d8 ASC
-- query IIIIIT rowsort all1
SELECT * FROM t1
-;
+ORDER BY 1,2,3,4,5,6;
-- 768 values hashing to 5d3fe674077ba48f8afa1c6f4e61ced4
-- query IIIIIT rowsort all2
SELECT * FROM t2
-;
+ORDER BY 1,2,3,4,5,6;
-- 678 values hashing to 09dd0a67e7c6bbb0b2aa2bc8364b9cb8
-- query IIIIIT rowsort all3
SELECT * FROM t3
-;
+ORDER BY 1,2,3,4,5,6;
-- 774 values hashing to a4da0dfc78895ffb5c59ae7f49afed54
-- query IIIIIT rowsort all4
SELECT * FROM t4
-;
+ORDER BY 1,2,3,4,5,6;
-- 666 values hashing to 66f651904b7b83fadcbddc7f15fc16b1
-- query IIIIIT rowsort all5
SELECT * FROM t5
-;
+ORDER BY 1,2,3,4,5,6;
-- 660 values hashing to 168733c3c947e4cd1b1cad5b997ece30
-- query IIIIIT rowsort all6
SELECT * FROM t6
-;
+ORDER BY 1,2,3,4,5,6;
-- 552 values hashing to 1498df6d8ab3f812e84f8e318dc53704
-- query IIIIIT rowsort all7
SELECT * FROM t7
-;
+ORDER BY 1,2,3,4,5,6;
-- 660 values hashing to fa70f972b3a5f3339f77037444cb54d5
-- query IIIIIT rowsort all8
SELECT * FROM t8
-;
+ORDER BY 1,2,3,4,5,6;
-- 654 values hashing to 55dc70aa8548b692aa3a7f2156fdeea5
-- query IIIIIT rowsort all9
SELECT * FROM t9
-;
+ORDER BY 1,2,3,4,5,6;
-- 588 values hashing to be47bb47837e44b32abdcfb5f1645153
-- query T valuesort
@@ -1214,7 +1214,7 @@ UNION
WHERE d7 in (687,507,603,52,118)
OR (d7=399 AND e7=408 AND 396=b7 AND a7=97 AND c7=813)
OR (e7=605 OR 837=b7 OR e7=918)
-;
+ORDER BY 1;
-- 41 values hashing to bbf619d1c2aae1fc385fb08bddcae829
-- query T valuesort
@@ -1250,7 +1250,7 @@ EXCEPT
SELECT a1 FROM t1
WHERE NOT ((731=e1 OR d1=972 OR e1=89)
OR b1 in (828,779,233,729,128,75,766,91,822,995))
-;
+ORDER BY 1;
-- 9 values hashing to 0242ff524f6efe4a8115ad23f4d8659a
-- query T valuesort
@@ -1273,7 +1273,7 @@ EXCEPT
EXCEPT
SELECT d8 FROM t8
WHERE NOT ((e8=586 AND b8=324 AND 231=c8 AND a8=54 AND d8=889))
-;
+ORDER BY 1;
-- 20 values hashing to 3766301bf3fa068cbcf5df057f20b1b4
-- query T valuesort
@@ -1295,7 +1295,7 @@ EXCEPT
SELECT c3 FROM t3
WHERE NOT (a3 in (820,101,383,822,594,457,971,818,380,12)
OR (964=a3 AND d3=444))
-;
+ORDER BY 1;
-- 179
-- 579
-- 729
@@ -1309,7 +1309,7 @@ EXCEPT
INTERSECT
SELECT d1 FROM t1
WHERE NOT ((149=b1 AND a1=776))
-;
+ORDER BY 1;
-- query T valuesort
SELECT b1 FROM t1
@@ -1346,7 +1346,7 @@ UNION ALL
WHERE a8 in (47,957,822,848,838,54,467,620,869)
OR (184=a8 OR a8=400)
OR b8 in (211,454,615,182,705,397,52,690,878,6,300)
-;
+ORDER BY 1;
-- 54 values hashing to a67a5b11c1b84f9a132ad71cec377cbc
-- query T valuesort
@@ -1385,7 +1385,7 @@ UNION ALL
UNION
SELECT c5 FROM t5
WHERE (12=c5 OR 971=b5 OR e5=470)
-;
+ORDER BY 1;
-- 27 values hashing to aeaaf7203a02879f27361a8532cf76ef
-- query T valuesort
@@ -1416,7 +1416,7 @@ EXCEPT
EXCEPT
SELECT a7 FROM t7
WHERE NOT (a7 in (884,998,356,854,848,592,982,622,565,879))
-;
+ORDER BY 1;
-- 18 values hashing to 8bdfd70f5413bea85e8826e9587834a9
-- query T valuesort
@@ -1437,7 +1437,7 @@ UNION
SELECT d9 FROM t9
WHERE a9 in (747,924,830,511,962,304,263,102,739,685,553)
OR c9 in (801,992,87)
-;
+ORDER BY 1;
-- 26 values hashing to fdce3b4ced0364d19f951333e78c9b78
-- query T valuesort
@@ -1475,7 +1475,7 @@ UNION ALL
UNION ALL
SELECT b5 FROM t5
WHERE (c5=313 OR 174=a5 OR e5=655)
-;
+ORDER BY 1;
-- 67 values hashing to f98c2d4d2a39578f3cf26a31dce5817a
-- query T valuesort
@@ -1502,7 +1502,7 @@ UNION ALL
WHERE (d5=991 OR e5=25)
OR (d5=792 AND 868=c5 AND 710=a5 AND e5=610)
OR e5 in (621,716,480,436)
-;
+ORDER BY 1;
-- 33 values hashing to fc2abaf4ef7388669cda23f4133b75de
-- query T valuesort
@@ -1529,7 +1529,7 @@ UNION ALL
UNION
SELECT a5 FROM t5
WHERE e5 in (522,937,561,25,944,206,352,758)
-;
+ORDER BY 1;
-- 50 values hashing to 9a533062bf7ea86aed6fe94d816fd73d
-- query T valuesort
@@ -1554,7 +1554,7 @@ UNION ALL
EXCEPT
SELECT c7 FROM t7
WHERE NOT ((135=c7 AND e7=27 AND d7=996 AND 958=a7))
-;
+ORDER BY 1;
-- 9 values hashing to b79423199aa8eb9f210d3da7b70c2bcb
-- query T valuesort
@@ -1588,7 +1588,7 @@ UNION
SELECT a5 FROM t5
WHERE d5 in (940,369,369,492,780,171,557)
OR c5 in (485,924,668,443,130,649,44)
-;
+ORDER BY 1;
-- 30 values hashing to 26b7338cd3c4153e158aabc6f7c1697e
-- query T valuesort
@@ -1610,7 +1610,7 @@ EXCEPT
SELECT c6 FROM t6
WHERE NOT ((348=b6 AND 35=a6)
OR (822=d6 OR d6=355))
-;
+ORDER BY 1;
-- 18 values hashing to b5f5121cd33b589a7c1faab9e49a32ac
-- query T valuesort
@@ -1626,7 +1626,7 @@ EXCEPT
SELECT a7 FROM t7
WHERE NOT (e7 in (663,462,903,455,6,816,499,460)
OR (435=c7 AND 442=d7 AND e7=988 AND 134=a7 AND 804=b7))
-;
+ORDER BY 1;
-- 21 values hashing to 4d066eac2b56fa3445b905774d53c2d6
-- query T valuesort
@@ -1672,7 +1672,7 @@ UNION
WHERE b2 in (211,285,897,264,317,754)
OR (a2=664 OR 546=b2 OR 783=e2)
OR (897=b2)
-;
+ORDER BY 1;
-- 40 values hashing to 433b7952a01f0399a526bd904b4ab6c8
-- query T valuesort
@@ -1698,7 +1698,7 @@ UNION
WHERE b4 in (708,608,114,480)
OR (c4=783 AND a4=72 AND d4=309 AND b4=603 AND 163=e4)
OR (e4=376)
-;
+ORDER BY 1;
-- 38 values hashing to f73c9b6c421b82aff3603ecc86cbd48f
-- query T valuesort
@@ -1711,7 +1711,7 @@ INTERSECT
WHERE NOT ((a5=81 AND e5=440 AND 369=d5 AND b5=855)
OR (b5=98 OR 13=e5 OR 242=a5)
OR (413=a5))
-;
+ORDER BY 1;
-- 657
-- query T valuesort
@@ -1740,7 +1740,7 @@ EXCEPT
UNION
SELECT c2 FROM t2
WHERE (e2=720 AND 676=c2 AND 987=a2 AND b2=818)
-;
+ORDER BY 1;
-- 112
-- 391
-- 676
@@ -1772,7 +1772,7 @@ EXCEPT
UNION ALL
SELECT c8 FROM t8
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
