Changeset: f324a81b4301 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f324a81b4301 Modified Files: sql/test/BugTracker-2023/Tests/misc-crashes-7390.test Branch: Jun2023 Log Message:
Add test for 7390/11.sql diffs (28 lines): 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 @@ -165,11 +165,22 @@ drop table v0 -- 10.sql statement ok -CREATE TABLE v0 (v1 INT PRIMARY KEY) +CREATE TABLE v0(v1 INT PRIMARY KEY) query I SELECT DISTINCT (SELECT v1 WHERE (5)) >= ANY(9223372036854775807) FROM v0 ---- --- TODO: add remaining 11.sql to 40.sql tests and fix bugs +statement ok +DROP TABLE v0 + +-- 11.sql +statement ok +CREATE TABLE v0(v1 BIGINT UNIQUE PRIMARY KEY); + +statement error 42000!PARTITION BY: subqueries not allowed in PARTITION BY clause +UPDATE v0 SET v1 = v1 * 73 WHERE v1 = (SELECT SUM(v1) OVER (PARTITION BY 52, (NOT EXISTS (SELECT 0 + (SELECT v1 WHERE v1 * v1 * v1 GROUP BY v1) AS v3 WHERE v1 = 'x' OR 'x' OR v1)), v1, 37 ORDER BY v1 NULLS LAST) IS NOT NULL AS v2 GROUP BY v1 HAVING v1 > 'x') AND NOT ((v1 = 66 AND v1 < 'x') AND v1 = 50) AND 35 >= 65; + +statement ok +DROP TABLE v0 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
