Changeset: 4c792abfc83d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4c792abfc83d Added Files: sql/test/BugTracker-2026/Tests/8018-rel2bin_select-assert-failure.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #8018 diffs (87 lines): diff --git a/sql/test/BugTracker-2026/Tests/8018-rel2bin_select-assert-failure.test b/sql/test/BugTracker-2026/Tests/8018-rel2bin_select-assert-failure.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/8018-rel2bin_select-assert-failure.test @@ -0,0 +1,74 @@ +statement ok +CREATE TABLE t8018 (x INT) + +statement ok rowcount 1 +INSERT INTO t8018 VALUES (1) + +query TI nosort +SELECT flagged.b, flagged.x +FROM ( + SELECT (ranked.x IN (SELECT 1)) AS b, + ranked.x + FROM ( + SELECT x, ROW_NUMBER() OVER () AS rn + FROM t8018 + ) AS ranked + WHERE ranked.rn > 1 +) AS flagged +WHERE flagged.b = TRUE +---- + +statement ok +CREATE VIEW v8018 AS +SELECT flagged.b, flagged.x +FROM ( + SELECT (ranked.x IN (SELECT 1)) AS b, + ranked.x + FROM ( + SELECT x, ROW_NUMBER() OVER () AS rn + FROM t8018 + ) AS ranked + WHERE ranked.rn > 1 +) AS flagged +WHERE flagged.b = TRUE + +query TI nosort +SELECT * FROM v8018 +---- + +query I nosort +SELECT COUNT(*) FROM v8018 +---- +0 + +-- Repeating the boolean predicate must still return one aggregate row. +-- next query triggers assert failure: sql/backends/monet5/rel_bin.c:4994: rel2bin_select: Assertion `sql->session->status == -10' failed. +query I nosort +SELECT COUNT(*) FROM v8018 +WHERE b = TRUE +---- +0 + +-- next statement triggers assert failure: sql/backends/monet5/rel_bin.c:4994: rel2bin_select: Assertion `sql->session->status == -10' failed. +statement ok +CREATE TABLE t8018_count AS +SELECT COUNT(*) AS row_count +FROM v8018 +WHERE b = TRUE + +query II nosort +SELECT COUNT(*), COALESCE(MAX(row_count), -1) +FROM t8018_count +---- +1 +0 + +statement ok +DROP TABLE IF EXISTS t8018_count + +statement ok +DROP VIEW IF EXISTS v8018 + +statement ok +DROP TABLE t8018 + diff --git a/sql/test/BugTracker-2026/Tests/All b/sql/test/BugTracker-2026/Tests/All --- a/sql/test/BugTracker-2026/Tests/All +++ b/sql/test/BugTracker-2026/Tests/All @@ -195,3 +195,4 @@ KNOWNFAIL?8013-triple-same-predicate-bug KNOWNFAIL?8014-rel_bin-exp_bin-assert-failure KNOWNFAIL?8015-join-subquery-NULL-bug KNOWNFAIL?8017-create-where-exists-select-acos-bug +KNOWNFAIL?8018-rel2bin_select-assert-failure _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
