Changeset: b8b4d019d1d4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b8b4d019d1d4 Added Files: sql/test/BugTracker-2026/Tests/7965-select-1-limit-0-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for #7965 diffs (47 lines): diff --git a/sql/test/BugTracker-2026/Tests/7965-select-1-limit-0-bug.test b/sql/test/BugTracker-2026/Tests/7965-select-1-limit-0-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7965-select-1-limit-0-bug.test @@ -0,0 +1,34 @@ +-- Failing query when using LIMIT 0 +query I nosort +SELECT 1 LIMIT 0 +---- + +-- Control query: succeeds and returns an empty result set. +query I nosort +SELECT 1 ORDER BY 1 LIMIT 0 +---- + +-- query succeeds when using LIMIT 1 +query I nosort +SELECT 1 LIMIT 1 +---- +1 + + + +-- Failing query when using VALUES and LIMIT 0 +query I nosort +SELECT * FROM (VALUES (1)) AS v(x) LIMIT 0 +---- + +-- Control query using VALUES: succeeds and returns an empty result set. +query I nosort +SELECT * FROM (VALUES (1)) AS v(x) ORDER BY x LIMIT 0 +---- + +-- query succeeds when using VALUES and LIMIT 1. +query I nosort +SELECT * FROM (VALUES (1)) AS v(x) LIMIT 1 +---- +1 + 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 @@ -148,3 +148,4 @@ KNOWNFAIL?7957-tail_type-crash KNOWNFAIL?7961-list_empty-crash KNOWNFAIL?7963-having-sum-or-exists-or-sum-bug 7964-optimize-limit-0-queries +KNOWNFAIL?7965-select-1-limit-0-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
