Changeset: 57e8235d37f7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/57e8235d37f7 Modified Files: sql/test/BugTracker-2024/Tests/add-partition-crash-7437.test sql/test/BugTracker-2024/Tests/aggr-exp-copy-crash-7435.test sql/test/BugTracker-2024/Tests/bind-exps-crash-7438.test sql/test/BugTracker-2024/Tests/count-unnest-crash-7436.test sql/test/BugTracker-2024/Tests/exp-bin-crash-7434.test sql/test/BugTracker-2024/Tests/exps-cards-crash-7439.test sql/test/BugTracker-2024/Tests/is-col-uniq-crash-7441.test sql/test/BugTracker-2024/Tests/recursive-merge-table-crash-7443.test sql/test/BugTracker-2024/Tests/rewrite-count-crash-7433.test sql/test/BugTracker-2024/Tests/unaligned_mats-7442.test sql/test/BugTracker-2024/Tests/where-between-issue-7428.test Branch: Dec2023 Log Message:
Extend tests with DROP TABLE statements at the end. diffs (125 lines): diff --git a/sql/test/BugTracker-2024/Tests/add-partition-crash-7437.test b/sql/test/BugTracker-2024/Tests/add-partition-crash-7437.test --- a/sql/test/BugTracker-2024/Tests/add-partition-crash-7437.test +++ b/sql/test/BugTracker-2024/Tests/add-partition-crash-7437.test @@ -6,3 +6,9 @@ CREATE TABLE sublimits2 (a int, b varcha statement error 42000!SELECT: no such unary operator 'addtwo'(tinyint) ALTER TABLE testagain ADD TABLE sublimits2 AS PARTITION IN (-100 * 2, '-90', '120', addtwo(55), 11.2) + +statement ok +DROP TABLE sublimits2 + +statement ok +DROP TABLE testagain diff --git a/sql/test/BugTracker-2024/Tests/aggr-exp-copy-crash-7435.test b/sql/test/BugTracker-2024/Tests/aggr-exp-copy-crash-7435.test --- a/sql/test/BugTracker-2024/Tests/aggr-exp-copy-crash-7435.test +++ b/sql/test/BugTracker-2024/Tests/aggr-exp-copy-crash-7435.test @@ -3,3 +3,6 @@ CREATE TABLE v0 ( v1 , v2 ) as ( select statement ok DELETE FROM v0 WHERE NOT ( v1 = ( SELECT 3 WHERE v2 = ( SELECT sum ( v2 ) OVER ( ) ) GROUP BY 7 )) + +statement ok +DROP TABLE v0 diff --git a/sql/test/BugTracker-2024/Tests/bind-exps-crash-7438.test b/sql/test/BugTracker-2024/Tests/bind-exps-crash-7438.test --- a/sql/test/BugTracker-2024/Tests/bind-exps-crash-7438.test +++ b/sql/test/BugTracker-2024/Tests/bind-exps-crash-7438.test @@ -3,3 +3,6 @@ CREATE TABLE v0 ( v2 INTEGER , v1 INTEGE statement ok SELECT CAST ( ( ( SELECT NULL v1 WHERE v2 IS NULL OR ( 'www' > ANY ( v1 ) ) ) ) AS BIGINT ) FROM v0 + +statement ok +DROP TABLE v0 diff --git a/sql/test/BugTracker-2024/Tests/count-unnest-crash-7436.test b/sql/test/BugTracker-2024/Tests/count-unnest-crash-7436.test --- a/sql/test/BugTracker-2024/Tests/count-unnest-crash-7436.test +++ b/sql/test/BugTracker-2024/Tests/count-unnest-crash-7436.test @@ -3,3 +3,6 @@ CREATE TABLE v0 ( v1 DOUBLE ) statement ok DELETE FROM v0 WHERE ( v1 ) IS NULL OR ( SELECT DENSE_RANK ( ) OVER ( PARTITION BY count ( * ) ORDER BY v1 % 10 ) WHERE 0 BETWEEN v1 AND v1 ) < 4 + +statement ok +DROP TABLE v0 diff --git a/sql/test/BugTracker-2024/Tests/exp-bin-crash-7434.test b/sql/test/BugTracker-2024/Tests/exp-bin-crash-7434.test --- a/sql/test/BugTracker-2024/Tests/exp-bin-crash-7434.test +++ b/sql/test/BugTracker-2024/Tests/exp-bin-crash-7434.test @@ -3,3 +3,6 @@ CREATE TABLE v0 ( v1 REAL ) statement error conversion of string '<js>null</js>' to type hge failed. SELECT ( NULL IN ( ( SELECT median ( 1 ) ) , ntile ( '<js>null</js>' ) OVER ( ) ) ) AS new_column FROM v0 + +statement ok +DROP TABLE v0 diff --git a/sql/test/BugTracker-2024/Tests/exps-cards-crash-7439.test b/sql/test/BugTracker-2024/Tests/exps-cards-crash-7439.test --- a/sql/test/BugTracker-2024/Tests/exps-cards-crash-7439.test +++ b/sql/test/BugTracker-2024/Tests/exps-cards-crash-7439.test @@ -3,3 +3,6 @@ CREATE TABLE v0 ( v1 oid ) statement ok DELETE FROM v0 WHERE NOT ( v1 IN ( SELECT MAX ( DISTINCT ( SELECT NULL WHERE v1 AND v1 = 'aggordview1' GROUP BY v1 ) ) FROM v0 ) ) + +statement ok +DROP TABLE v0 diff --git a/sql/test/BugTracker-2024/Tests/is-col-uniq-crash-7441.test b/sql/test/BugTracker-2024/Tests/is-col-uniq-crash-7441.test --- a/sql/test/BugTracker-2024/Tests/is-col-uniq-crash-7441.test +++ b/sql/test/BugTracker-2024/Tests/is-col-uniq-crash-7441.test @@ -1,8 +1,11 @@ statement ok -CREATE TABLE v0 (v1 integer); +CREATE TABLE v0 (v1 integer) statement ok -SELECT 1 IS NOT NULL FROM v0 ORDER BY AVG(max(286)) OVER (ORDER BY 111 NULLS FIRST) NULLS LAST; +SELECT 1 IS NOT NULL FROM v0 ORDER BY AVG(max(286)) OVER (ORDER BY 111 NULLS FIRST) NULLS LAST statement ok -SELECT DISTINCT * FROM v0 AS cor0 WHERE (2) IN (v1 / - v1, v1); +SELECT DISTINCT * FROM v0 AS cor0 WHERE (2) IN (v1 / - v1, v1) + +statement ok +DROP TABLE v0 diff --git a/sql/test/BugTracker-2024/Tests/recursive-merge-table-crash-7443.test b/sql/test/BugTracker-2024/Tests/recursive-merge-table-crash-7443.test --- a/sql/test/BugTracker-2024/Tests/recursive-merge-table-crash-7443.test +++ b/sql/test/BugTracker-2024/Tests/recursive-merge-table-crash-7443.test @@ -16,3 +16,12 @@ ALTER TABLE t1 ADD TABLE a AS PARTITION query IT SELECT c, d FROM t1 ---- + +statement ok +DROP TABLE id CASCADE + +statement ok +DROP TABLE t1 + +statement ok +DROP TABLE a diff --git a/sql/test/BugTracker-2024/Tests/rewrite-count-crash-7433.test b/sql/test/BugTracker-2024/Tests/rewrite-count-crash-7433.test --- a/sql/test/BugTracker-2024/Tests/rewrite-count-crash-7433.test +++ b/sql/test/BugTracker-2024/Tests/rewrite-count-crash-7433.test @@ -3,3 +3,6 @@ CREATE TABLE v0 ( v1 VARCHAR ( 217 ) ) statement ok UPDATE v0 SET v1 = ( SELECT ( v1 IN ( SELECT COUNT ( * ) WHERE v1 = 1 ) ) AS new_column ) + +statement ok +DROP TABLE v0 diff --git a/sql/test/BugTracker-2024/Tests/unaligned_mats-7442.test b/sql/test/BugTracker-2024/Tests/unaligned_mats-7442.test --- a/sql/test/BugTracker-2024/Tests/unaligned_mats-7442.test +++ b/sql/test/BugTracker-2024/Tests/unaligned_mats-7442.test @@ -11,3 +11,6 @@ query I rowsort SELECT count ( v1 ) FROM v0 WHERE v2 IN ( SELECT ( row_number ( ) OVER ( ) ) FROM v0 ) ---- 0 + +statement ok +DROP TABLE v0 diff --git a/sql/test/BugTracker-2024/Tests/where-between-issue-7428.test b/sql/test/BugTracker-2024/Tests/where-between-issue-7428.test --- a/sql/test/BugTracker-2024/Tests/where-between-issue-7428.test +++ b/sql/test/BugTracker-2024/Tests/where-between-issue-7428.test @@ -50,4 +50,3 @@ DROP TABLE t0 statement ok DROP TABLE t1 - _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
