Changeset: 51149efbbd0b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/51149efbbd0b
Modified Files:
sql/test/BugTracker-2024/Tests/7455-concat_order.test
sql/test/BugTracker-2025/Tests/7653_incorrect_join_results.test
Branch: manti
Log Message:
sort the test output
diffs (79 lines):
diff --git a/sql/test/BugTracker-2024/Tests/7455-concat_order.test
b/sql/test/BugTracker-2024/Tests/7455-concat_order.test
--- a/sql/test/BugTracker-2024/Tests/7455-concat_order.test
+++ b/sql/test/BugTracker-2024/Tests/7455-concat_order.test
@@ -14,48 +14,48 @@ statement ok
INSERT INTO t0 (c0) VALUES ('b')
query ITT nosort
-SELECT * FROM v0, t0
+SELECT * FROM v0, t0 ORDER BY 1,2,3
----
1
(empty)
0
1
+(empty)
+0
+1
+(empty)
+0
+1
a
NULL
1
-b
+a
NULL
1
-(empty)
-0
-1
a
NULL
1
b
NULL
1
-(empty)
-0
-1
-a
+b
NULL
1
b
NULL
query I nosort
-SELECT (t0.c0||true BETWEEN v0.c0 AND v0.c0) FROM v0, t0
+SELECT (t0.c0||true BETWEEN v0.c0 AND v0.c0) FROM v0, t0 ORDER BY 1
----
-1
+0
+0
+0
+0
0
0
1
-0
-0
1
-0
-0
+1
query ITT nosort
SELECT * FROM v0, t0 WHERE (t0.c0||true BETWEEN v0.c0 AND v0.c0)
diff --git a/sql/test/BugTracker-2025/Tests/7653_incorrect_join_results.test
b/sql/test/BugTracker-2025/Tests/7653_incorrect_join_results.test
--- a/sql/test/BugTracker-2025/Tests/7653_incorrect_join_results.test
+++ b/sql/test/BugTracker-2025/Tests/7653_incorrect_join_results.test
@@ -5,7 +5,7 @@ statement ok
INSERT INTO t0(c1) VALUES(1), (2), (3)
query III nosort
-SELECT * FROM t0 JOIN LATERAL (SELECT CASE WHEN 0.7 <> ALL(SELECT t0.c1 FROM
t0 AS sub1) THEN 2 ELSE 1 END FROM t0 AS sub2) AS subQuery(col_1) ON NOT ((
EXISTS (SELECT 1)) AND 0)
+SELECT * FROM t0 JOIN LATERAL (SELECT CASE WHEN 0.7 <> ALL(SELECT t0.c1 FROM
t0 AS sub1) THEN 2 ELSE 1 END FROM t0 AS sub2) AS subQuery(col_1) ON NOT ((
EXISTS (SELECT 1)) AND 0) ORDER BY 1,2,3
----
NULL
1
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
