Changeset: 11bd3ece72a8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/11bd3ece72a8 Modified Files: sql/test/BugTracker-2025/Tests/7648_rightjoin_crash.test sql/test/BugTracker-2025/Tests/7650_right_join_crash.test sql/test/BugTracker-2025/Tests/7656_incorrect_error.test sql/test/BugTracker-2025/Tests/7659_trigger_crashes.test Branch: Mar2025 Log Message:
Canonicalize tests. diffs (61 lines): diff --git a/sql/test/BugTracker-2025/Tests/7648_rightjoin_crash.test b/sql/test/BugTracker-2025/Tests/7648_rightjoin_crash.test --- a/sql/test/BugTracker-2025/Tests/7648_rightjoin_crash.test +++ b/sql/test/BugTracker-2025/Tests/7648_rightjoin_crash.test @@ -1,7 +1,7 @@ statement ok CREATE TABLE IF NOT EXISTS t0(c0 INT) -query II +query II nosort SELECT * FROM t0 RIGHT JOIN (VALUES (1)) AS subQuery1(col_1) ON EXISTS (VALUES (CASE subQuery1.col_1 WHEN subQuery1.col_1 THEN 1 END)) ---- NULL @@ -13,6 +13,7 @@ CREATE TABLE IF NOT EXISTS t1(c0 DOUBLE statement ok CREATE TABLE IF NOT EXISTS t2(c0 DOUBLE ) -query II -SELECT * FROM t1 INNER JOIN t2 ON (NOT EXISTS (VALUES (((t1.c0)+(t2.c0))))) IS NULL; +query RR nosort +SELECT * FROM t1 INNER JOIN t2 ON (NOT EXISTS (VALUES (((t1.c0)+(t2.c0))))) IS NULL ---- + diff --git a/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test b/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test --- a/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test +++ b/sql/test/BugTracker-2025/Tests/7650_right_join_crash.test @@ -1,6 +1,7 @@ statement ok CREATE TABLE IF NOT EXISTS t1(c0 INTERVAL DAY,c2 DOUBLE) -query ITI +query TRI nosort SELECT ALL * FROM t1 RIGHT JOIN (VALUES (0)) AS subQuery1(col_1) ON ( t1.c0 < ANY(VALUES (t1.c0+t1.c0)) ) AND (VALUES (subQuery1.col_1), (EXISTS (VALUES (t1.c2))) ) ---- + diff --git a/sql/test/BugTracker-2025/Tests/7656_incorrect_error.test b/sql/test/BugTracker-2025/Tests/7656_incorrect_error.test --- a/sql/test/BugTracker-2025/Tests/7656_incorrect_error.test +++ b/sql/test/BugTracker-2025/Tests/7656_incorrect_error.test @@ -1,4 +1,3 @@ - -- the primary key statement ok create table a(id int) @@ -21,3 +20,4 @@ alter table b add foreign key(i) referen statement error 40000!DROP TABLE: FOREIGN KEY b.b_i_fkey depends on a drop table a + diff --git a/sql/test/BugTracker-2025/Tests/7659_trigger_crashes.test b/sql/test/BugTracker-2025/Tests/7659_trigger_crashes.test --- a/sql/test/BugTracker-2025/Tests/7659_trigger_crashes.test +++ b/sql/test/BugTracker-2025/Tests/7659_trigger_crashes.test @@ -20,9 +20,8 @@ statement ok CREATE TABLE table1(column1 INT, column2 INT) statement error -CREATE TRIGGER trigger6 AFTER UPDATE ON table1 REFERENCING OLD TABLE AS old_table NEW TABLE AS new_table FOR EACH STATEMENT SELECT * FROM sys.triggers; +CREATE TRIGGER trigger6 AFTER UPDATE ON table1 REFERENCING OLD TABLE AS old_table NEW TABLE AS new_table FOR EACH STATEMENT SELECT * FROM sys.triggers statement ok drop table table1 - _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
