Changeset: fd8d055378e0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/fd8d055378e0
Modified Files:
sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.test
sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
sql/test/BugTracker-2025/Tests/7635_name_propagation_missing.test
sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
sql/test/BugTracker-2025/Tests/7653_incorrect_join_results.test
sql/test/SQLancer/Tests/sqlancer18.test
sql/test/copy/Tests/flexible-order.test.in
sql/test/merge-statements/Tests/mergestmt05.test
sql/test/pg_regress/Tests/strings.test
sql/test/strings/Tests/contains_join.test
sql/test/strings/Tests/contains_join_2.test.in
Branch: default
Log Message:
Canonicalize tests.
diffs (207 lines):
diff --git a/sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.test
b/sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.test
--- a/sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.test
+++ b/sql/test/BugTracker-2021/Tests/query-too-complex.Bug-7092.test
@@ -86990,3 +86990,4 @@ SELECT SUM(test.dkey), test.dkey
statement ok
drop table if exists test
+
diff --git a/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
b/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
--- a/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
+++ b/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
@@ -458,7 +458,7 @@ DROP TABLE v0
-- 31.sql
onlyif has-hugeint
-query I
+query I nosort
SELECT ALL ( SELECT - - - - - - - - - - - 1 - - - - - - 16 FROM ( SELECT NULL
- - - - - - - - - - - - - - - - 1 FROM ( SELECT - - - - 1 * - - - - - -
2147483648 * - - - 43 * 77745222.000000 ) AS v1 ( v1 ) GROUP BY GROUPING SETS (
GROUPING SETS ( CUBE ( v1 ) ) ) ORDER BY v1 , - - - 86 + - - 93 ^ v1 , v1 LIMIT
21 ) AS v1 UNION SELECT - - - - - - - - - - - - 93 WHERE - v1 < -
63226945.000000 - - - - - - - - - - 68 ) FROM ( VALUES ( - - - - - - - - - 40 /
- ( SELECT - - - - - - - - 0 WHERE - - - - - - - 40 = - - - - - 0 ) ) , ( - -
88 ) ) v1 ( v1 )
----
15
diff --git a/sql/test/BugTracker-2025/Tests/7635_name_propagation_missing.test
b/sql/test/BugTracker-2025/Tests/7635_name_propagation_missing.test
--- a/sql/test/BugTracker-2025/Tests/7635_name_propagation_missing.test
+++ b/sql/test/BugTracker-2025/Tests/7635_name_propagation_missing.test
@@ -4,14 +4,15 @@ CREATE TABLE t0(c0 INT)
statement ok
INSERT INTO t0 VALUES (1)
-query II
+query II nosort
SELECT * FROM t0 INNER JOIN (SELECT (1 = ANY(VALUES (1)))) AS sub ON TRUE
----
1
1
-query II
+query II nosort
SELECT * FROM t0 INNER JOIN (SELECT (1 = ANY(VALUES (1)) = TRUE)) AS sub ON
TRUE
----
1
1
+
diff --git a/sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
b/sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
--- a/sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
+++ b/sql/test/BugTracker-2025/Tests/7645_not_likeselect.test
@@ -1,6 +1,7 @@
statement ok
CREATE TABLE IF NOT EXISTS database0_t2(c2 STRING)
-query TI
+query TT nosort
SELECT * FROM database0_t2 JOIN (VALUES (INTERVAL '18115' MONTH)) ON ((
(database0_t2.c2 NOT LIKE CAST(INTERVAL '20039' MONTH AS STRING(909))) OR
(database0_t2.c2 LIKE database0_t2.c2) ))
----
+
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
@@ -4,8 +4,8 @@ CREATE TABLE t0 (c0 INT , c1 INT)
statement ok
INSERT INTO t0(c1) VALUES(1), (2), (3)
-query III
-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);
+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)
----
NULL
1
@@ -35,8 +35,8 @@ NULL
3
2
-query I
-SELECT t0.c1 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);
+query I nosort
+SELECT t0.c1 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)
----
1
1
@@ -47,3 +47,4 @@ 2
3
3
3
+
diff --git a/sql/test/SQLancer/Tests/sqlancer18.test
b/sql/test/SQLancer/Tests/sqlancer18.test
--- a/sql/test/SQLancer/Tests/sqlancer18.test
+++ b/sql/test/SQLancer/Tests/sqlancer18.test
@@ -644,7 +644,7 @@ create or replace view v102(vc0) as (sel
statement ok
commit
-query I
+query I nosort
SELECT 1 FROM v100 AS vx WHERE vx.vc0 = ANY(SELECT 1 FROM v100 HAVING
count(vx.vc0 = vx.vc0 AND (SELECT TRUE FROM v102)))
----
diff --git a/sql/test/copy/Tests/flexible-order.test.in
b/sql/test/copy/Tests/flexible-order.test.in
--- a/sql/test/copy/Tests/flexible-order.test.in
+++ b/sql/test/copy/Tests/flexible-order.test.in
@@ -1,12 +1,9 @@
-
statement ok
DROP TABLE IF EXISTS foo
statement ok
CREATE TABLE foo(s TEXT, t TEXT)
-
-
-- First show that the 'default' order works
statement ok
@@ -25,8 +22,6 @@ Xmies
statement ok
TRUNCATE foo
-
-
-- add USING DELIMITERS and NULL clauses
statement ok
@@ -44,8 +39,6 @@ NULL
3|
mies
-
-
-- add USING DELIMITERS and NULL clauses in a different order
statement ok
@@ -66,8 +59,6 @@ NULL
3|
mies
-
-
-- What happens if we duplicate a clause?
statement ok
@@ -89,7 +80,6 @@ NULL
3|
mies
-
-- What happens if a duplicate clause updates only part of the settings?
statement ok
@@ -102,4 +92,5 @@ statement error 42000!COPY INTO: row sep
COPY INTO foo FROM R'$TSTSRCDIR/aapnootmies.csv'
USING DELIMITERS '*', 'X'
NULL AS 'noot'
-USING DELIMITERS 'X';
+USING DELIMITERS 'X'
+
diff --git a/sql/test/merge-statements/Tests/mergestmt05.test
b/sql/test/merge-statements/Tests/mergestmt05.test
--- a/sql/test/merge-statements/Tests/mergestmt05.test
+++ b/sql/test/merge-statements/Tests/mergestmt05.test
@@ -1,4 +1,3 @@
-
statement ok
CREATE TABLE food_store (id INT, "name" TEXT, new_item BOOL)
diff --git a/sql/test/pg_regress/Tests/strings.test
b/sql/test/pg_regress/Tests/strings.test
--- a/sql/test/pg_regress/Tests/strings.test
+++ b/sql/test/pg_regress/Tests/strings.test
@@ -183,7 +183,7 @@ SELECT SUBSTRING('abcdefg' FROM 'a#"(b_d
statement error
SELECT SUBSTRING('abcdefg' FROM '#"(b_d)#"%' FOR '#') IS NULL AS "True"
-query I
+query I nosort
SELECT SUBSTRING('abcdefg' FROM '(b|c)' FOR NULL) IS NULL AS "True"
----
1
@@ -191,7 +191,7 @@ 1
statement error
SELECT SUBSTRING(NULL FROM '(b|c)' FOR '#') IS NULL AS "True"
-query I
+query I nosort
SELECT SUBSTRING('abcdefg' FROM NULL FOR '#') IS NULL AS "True"
----
1
diff --git a/sql/test/strings/Tests/contains_join.test
b/sql/test/strings/Tests/contains_join.test
--- a/sql/test/strings/Tests/contains_join.test
+++ b/sql/test/strings/Tests/contains_join.test
@@ -95,3 +95,4 @@ DROP TABLE foo
statement ok
DROP TABLE bar
+
diff --git a/sql/test/strings/Tests/contains_join_2.test.in
b/sql/test/strings/Tests/contains_join_2.test.in
--- a/sql/test/strings/Tests/contains_join_2.test.in
+++ b/sql/test/strings/Tests/contains_join_2.test.in
@@ -10,7 +10,7 @@ COPY 992001 RECORDS INTO creative_work_t
statement ok
COPY 5490 RECORDS INTO wo2_thesaurus FROM
E'$QTSTDATAPATH/spinque/wo2_thesaurus.txt' NULL AS ''
-query I
+query I nosort
select count(*) from creative_work_title c, wo2_thesaurus w where [c.s]
contains [w.s]
----
142819
@@ -20,3 +20,4 @@ drop table creative_work_title
statement ok
drop table wo2_thesaurus
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
