Changeset: 84e2ee3b3ca7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/84e2ee3b3ca7 Added Files: sql/test/BugTracker-2026/Tests/8020-correlated-subquery-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #8020 diffs (43 lines): diff --git a/sql/test/BugTracker-2026/Tests/8020-correlated-subquery-bug.test b/sql/test/BugTracker-2026/Tests/8020-correlated-subquery-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/8020-correlated-subquery-bug.test @@ -0,0 +1,30 @@ +statement ok +create table t8020 (id int, fk int) + +statement ok rowcount 3 +insert into t8020 values (100,1),(101,1),(101,2) + +query I rowsort +select (select a.id from t8020 a + where a.fk = 1 + and a.id < (select b.id from t8020 b + where b.fk = c.id and b.id = 101)) +from (values (1)) as c(id) +---- +100 + + +-- next query fails with: GDK reported error: BATsubcross: more than one match +-- where we expected it to succeed +query I rowsort +select (select a.id from t8020 a + where a.fk = c.id + and a.id < (select b.id from t8020 b + where b.fk = c.id and b.id = 101)) +from (values (1)) as c(id) +---- +100 + +statement ok +drop table t8020 + 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 @@ -197,3 +197,4 @@ KNOWNFAIL?8015-join-subquery-NULL-bug KNOWNFAIL?8017-create-where-exists-select-acos-bug KNOWNFAIL?8018-rel2bin_select-assert-failure KNOWNFAIL?8019-rel_bin-exp_bin-assert-failure +KNOWNFAIL?8020-correlated-subquery-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
