Changeset: fddec7caec2a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/fddec7caec2a
Added Files:
sql/test/BugTracker-2026/Tests/7986-right-function-bug.test
Modified Files:
sql/test/BugTracker-2026/Tests/All
Branch: Dec2025
Log Message:
Add test for issue #7986
diffs (26 lines):
diff --git a/sql/test/BugTracker-2026/Tests/7986-right-function-bug.test
b/sql/test/BugTracker-2026/Tests/7986-right-function-bug.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2026/Tests/7986-right-function-bug.test
@@ -0,0 +1,13 @@
+-- bug: RIGHT('ä', 1) should not return an empty string but 'ä'
+query TITI nosort
+SELECT
+ RIGHT('ä', 1) AS actual,
+ CHAR_LENGTH(RIGHT('ä', 1)) AS actual_chars,
+ SUBSTRING('ä', 1, 1) AS expected,
+ CHAR_LENGTH(SUBSTRING('ä', 1, 1)) AS expected_chars
+----
+ä
+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
@@ -166,3 +166,4 @@ KNOWNFAIL?7980-lag-offset-ignored-bug
KNOWNFAIL?7982-range-current-row-bug
KNOWNFAIL?7984-exists-select-count-bug
KNOWNFAIL?7985-qualify-row_number-over-bug
+KNOWNFAIL?7986-right-function-bug
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
