Changeset: 06294ceb60a8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/06294ceb60a8 Modified Files: sql/test/BugTracker-2023/Tests/misc-crashes-7390.test Branch: default Log Message:
Adjusted query 24.sql such that the error "SELECT: identifier 'v1' ambiguous" is not reported anymore, and the insert succeeds. That was the original case where the next SELECT query would crash the server (or generate an assertion failure in: gdk/gdk_bat.c:2098: BATsetcount: Assertion `b->batCapacity >= cnt' failed.) 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 @@ -359,15 +359,20 @@ x -1 x -statement error 42000!SELECT: identifier 'v1' ambiguous -WITH v0 AS (SELECT 14, * FROM v0) INSERT INTO v0 SELECT v1 * 0 FROM v0 NATURAL JOIN v0, v0, v0 AS v2, v0, v0 AS v3 ORDER BY v1 * 0 / 77 +-- statement error 42000!SELECT: identifier 'v1' ambiguous +-- WITH v0 AS (SELECT 14, * FROM v0) INSERT INTO v0 SELECT v1 * 0 FROM v0 NATURAL JOIN v0, v0, v0 AS v2, v0, v0 AS v3 ORDER BY v1 * 0 / 77 + +statement ok +WITH v0 AS (SELECT 14, * FROM v0) INSERT INTO v0 SELECT v0.v1 * 0 FROM v0 NATURAL JOIN v0, v0, v0 AS v2, v0, v0 AS v3 ORDER BY v0.v1 * 0 / 77 query I nosort SELECT count(*) FROM v0 ---- -8 +131080 --- after the second insert, rerun same query as above, now it crashes server +-- after the second insert, rerun same query as above, now it crashes server with assertion failure +-- gdk/gdk_bat.c:2098: BATsetcount: Assertion `b->batCapacity >= cnt' failed. +skipif knownfail query IT nosort SELECT * , 'x' FROM v0 WHERE (SELECT 39 WHERE (v1 + -32768 NOT IN (14, 255))) * 87 + 2147483647 ---- _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
