Changeset: 7f9a1bd47918 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/7f9a1bd47918 Added Files: sql/test/BugTracker-2026/Tests/7998-scalar-subquery-error-msg-improvement.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #7998 diffs (39 lines): diff --git a/sql/test/BugTracker-2026/Tests/7998-scalar-subquery-error-msg-improvement.test b/sql/test/BugTracker-2026/Tests/7998-scalar-subquery-error-msg-improvement.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7998-scalar-subquery-error-msg-improvement.test @@ -0,0 +1,26 @@ +statement ok +CREATE TABLE ga(id INT, a INT) + +statement ok +INSERT INTO ga VALUES (1,10) + +statement ok +CREATE TABLE gb(a INT, b INT) + +statement ok +INSERT INTO gb VALUES (10,100),(10,101) + +-- MonetDB: !GDK reported error: selectjoin: more than one match +-- PostgreSQL: ERROR: more than one row returned by a subquery used as an expression +-- DuckDB: Invalid Input Error: More than one row returned by a subquery used as an expression +-- MySQL: ERROR 1242: Subquery returns more than 1 row + +statement error More than one row returned by a subquery used as an expression +SELECT ga.id, (SELECT gb.b FROM gb WHERE gb.a = ga.a) FROM ga + +statement ok +DROP TABLE IF EXISTS ga + +statement ok +DROP TABLE IF EXISTS gb + 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 @@ -178,3 +178,4 @@ KNOWNFAIL?7994-exists-groupby-rollup-bug KNOWNFAIL?7995-left-join-lateral-subquery-bug KNOWNFAIL?7996-delete-not-exists-correlated-query-bug KNOWNFAIL?7997-recursive-cte-number-overflow-issue +KNOWNFAIL?7998-scalar-subquery-error-msg-improvement _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
