Changeset: d1d2ce4a7b73 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d1d2ce4a7b73 Modified Files: sql/test/BugTracker-2024/Tests/between-boolean-7451.test sql/test/BugTracker-2024/Tests/concat_order-7455.test sql/test/BugTracker-2024/Tests/constant-expression-issue-7457.test sql/test/BugTracker-2024/Tests/contains-between-issue-7459.test sql/test/BugTracker-2024/Tests/function_return_issue.test sql/test/BugTracker-2024/Tests/push_select_exp-issue-7460.test sql/test/BugTracker-2024/Tests/where_null-7450.test Branch: default Log Message:
Add some missing DROP TABLE/VIEW statements diffs (144 lines): diff --git a/sql/test/BugTracker-2024/Tests/between-boolean-7451.test b/sql/test/BugTracker-2024/Tests/between-boolean-7451.test --- a/sql/test/BugTracker-2024/Tests/between-boolean-7451.test +++ b/sql/test/BugTracker-2024/Tests/between-boolean-7451.test @@ -1,4 +1,3 @@ - statement ok CREATE TABLE t0(c0 VARCHAR, PRIMARY KEY(c0)) @@ -29,7 +28,7 @@ True True query IT -SELECT t1.c1, t1.c2 FROM t1, t0 WHERE (NOT CAST((true BETWEEN t1.c2 AND t0.c0) AS VARCHAR)); +SELECT t1.c1, t1.c2 FROM t1, t0 WHERE (NOT CAST((true BETWEEN t1.c2 AND t0.c0) AS VARCHAR)) ---- 0 NULL @@ -37,7 +36,7 @@ 0 NULL query ITT -SELECT * FROM t1, t0 WHERE (NOT CAST((true BETWEEN t1.c2 AND t0.c0) AS VARCHAR)); -- 2 rows +SELECT * FROM t1, t0 WHERE (NOT CAST((true BETWEEN t1.c2 AND t0.c0) AS VARCHAR)) ---- 0 NULL @@ -45,3 +44,10 @@ a 0 NULL false + +statement ok +DROP TABLE t1 + +statement ok +DROP TABLE t0 + diff --git a/sql/test/BugTracker-2024/Tests/concat_order-7455.test b/sql/test/BugTracker-2024/Tests/concat_order-7455.test --- a/sql/test/BugTracker-2024/Tests/concat_order-7455.test +++ b/sql/test/BugTracker-2024/Tests/concat_order-7455.test @@ -58,7 +58,7 @@ False False query TTT -SELECT * FROM v0, t0 WHERE (t0.c0||true BETWEEN v0.c0 AND v0.c0); +SELECT * FROM v0, t0 WHERE (t0.c0||true BETWEEN v0.c0 AND v0.c0) ---- True (empty) @@ -69,3 +69,10 @@ 0 True (empty) 0 + +statement ok +DROP VIEW v0 + +statement ok +DROP TABLE t0 + diff --git a/sql/test/BugTracker-2024/Tests/constant-expression-issue-7457.test b/sql/test/BugTracker-2024/Tests/constant-expression-issue-7457.test --- a/sql/test/BugTracker-2024/Tests/constant-expression-issue-7457.test +++ b/sql/test/BugTracker-2024/Tests/constant-expression-issue-7457.test @@ -28,3 +28,7 @@ a False b NULL + +statement ok +DROP TABLE t0 + diff --git a/sql/test/BugTracker-2024/Tests/contains-between-issue-7459.test b/sql/test/BugTracker-2024/Tests/contains-between-issue-7459.test --- a/sql/test/BugTracker-2024/Tests/contains-between-issue-7459.test +++ b/sql/test/BugTracker-2024/Tests/contains-between-issue-7459.test @@ -4,3 +4,7 @@ CREATE TABLE t0(c0 INTEGER, c1 VARCHAR(5 query IT SELECT * FROM t0 ORDER BY CONTAINS(((CASE '1' WHEN t0.c0 THEN '' ELSE t0.c0 END ) NOT BETWEEN 0 AND t0.c0>=t0.c1), t0.c1) DESC ---- + +statement ok +DROP TABLE t0 + diff --git a/sql/test/BugTracker-2024/Tests/function_return_issue.test b/sql/test/BugTracker-2024/Tests/function_return_issue.test --- a/sql/test/BugTracker-2024/Tests/function_return_issue.test +++ b/sql/test/BugTracker-2024/Tests/function_return_issue.test @@ -13,3 +13,6 @@ select id from do_test(true) ---- 1 +statement ok +drop function do_test + diff --git a/sql/test/BugTracker-2024/Tests/push_select_exp-issue-7460.test b/sql/test/BugTracker-2024/Tests/push_select_exp-issue-7460.test --- a/sql/test/BugTracker-2024/Tests/push_select_exp-issue-7460.test +++ b/sql/test/BugTracker-2024/Tests/push_select_exp-issue-7460.test @@ -12,3 +12,10 @@ SELECT * FROM t0, v0 WHERE CAST((t0.c2 B ---- True 1 + +statement ok +DROP VIEW v0 + +statement ok +DROP TABLE t0 + diff --git a/sql/test/BugTracker-2024/Tests/where_null-7450.test b/sql/test/BugTracker-2024/Tests/where_null-7450.test --- a/sql/test/BugTracker-2024/Tests/where_null-7450.test +++ b/sql/test/BugTracker-2024/Tests/where_null-7450.test @@ -1,20 +1,28 @@ statement ok -CREATE TABLE t0(c0 INT); +CREATE TABLE t0(c0 INT) statement ok -INSERT INTO t0 ( c0) VALUES (false); +INSERT INTO t0 ( c0) VALUES (false) statement ok -CREATE VIEW v0(c0) AS SELECT true FROM t0 WHERE NULL GROUP BY t0.c0, true; +CREATE VIEW v0(c0) AS SELECT true FROM t0 WHERE NULL GROUP BY t0.c0, true query I -SELECT * FROM v0; +SELECT * FROM v0 ---- query I -SELECT * FROM v0 WHERE true; +SELECT * FROM v0 WHERE true ---- query I -SELECT * FROM v0 WHERE true UNION ALL SELECT * FROM v0 WHERE (NOT true); +SELECT * FROM v0 WHERE true UNION ALL SELECT * FROM v0 WHERE (NOT true) ---- + + +statement ok +DROP VIEW v0 + +statement ok +DROP TABLE t0 + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
