aboutsummaryrefslogtreecommitdiff
path: root/test/func9.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/func9.test')
-rw-r--r--test/func9.test12
1 files changed, 11 insertions, 1 deletions
diff --git a/test/func9.test b/test/func9.test
index 6cf9fc31e..42138ab2e 100644
--- a/test/func9.test
+++ b/test/func9.test
@@ -9,7 +9,7 @@
#
#*************************************************************************
#
-# Test cases for SQL newer functions
+# Test cases for some newer SQL functions
#
set testdir [file dirname $argv0]
source $testdir/tester.tcl
@@ -36,5 +36,15 @@ do_catchsql_test func9-160 {
SELECT concat_ws(',');
} {1 {wrong number of arguments to function concat_ws()}}
+# https://sqlite.org/forum/forumpost/4c344ca61f (2025-03-02)
+do_execsql_test func9-200 {
+ SELECT unistr('G\u00e4ste');
+} {Gäste}
+do_execsql_test func9-210 {
+ SELECT unistr_quote(unistr('G\u00e4ste'));
+} {'Gäste'}
+do_execsql_test func9-220 {
+ SELECT format('%#Q',unistr('G\u00e4ste'));
+} {'Gäste'}
finish_test