Changeset: 4b4761f152c9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4b4761f152c9 Added Files: sql/test/BugTracker-2026/Tests/8006-field-function-bug.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
Add test for issue #8006 diffs (31 lines): diff --git a/sql/test/BugTracker-2026/Tests/8006-field-function-bug.test b/sql/test/BugTracker-2026/Tests/8006-field-function-bug.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/8006-field-function-bug.test @@ -0,0 +1,18 @@ +-- according to https://www.monetdb.org/documentation-Dec2025/user-guide/sql-functions/string-functions/ +-- scalar function field(s, s1 [, s2 ...]) function should return one integer value or null, not multiple rows +query II nosort +SELECT + field('foo', 'foo', 'bar', 'foo') AS actual, + 0 AS expected +---- +0 +0 + + +-- note that function field does NOT exist in the sys.functions table +-- it seems to be implemented in sql/server/rel_select.c from line 3473 onwards +query TTTTTT rowsort +select name, mod, type, varres, vararg, system from sys.functions where name = 'field' +---- + + 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 @@ -186,3 +186,4 @@ KNOWNFAIL?8002-schema-renaming-makes-seq KNOWNFAIL?8003-windowed-group_concat-ignores-orderby-bug KNOWNFAIL?8004-nth_value-windowfunction-bug KNOWNFAIL?8005-prod-aggr-function-bug +KNOWNFAIL?8006-field-function-bug _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
