aboutsummaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
authordrh <>2025-06-11 00:01:42 +0000
committerdrh <>2025-06-11 00:01:42 +0000
commit23e59b34e9d6c574280b7a1e29499c7d0805b01a (patch)
tree5d2c435b59eea21ff924f2f75f3e527488e6ccd1 /test
parenta09a4fbac958ab3c130c73500cc3cf68f9151d50 (diff)
downloadsqlite-23e59b34e9d6c574280b7a1e29499c7d0805b01a.tar.gz
sqlite-23e59b34e9d6c574280b7a1e29499c7d0805b01a.zip
Fix the concat_ws() SQL function so that it includes empty strings in the
concatenation. [forum:/forumpost/52503ac21d|Forum post 52503ac21d]. FossilOrigin-Name: 80a78987da484d435a8242c05c48d546d430920df713b24a9d9d9fff7ba1113d
Diffstat (limited to 'test')
-rw-r--r--test/func9.test3
1 files changed, 3 insertions, 0 deletions
diff --git a/test/func9.test b/test/func9.test
index 42138ab2e..2383b76f6 100644
--- a/test/func9.test
+++ b/test/func9.test
@@ -26,6 +26,9 @@ do_catchsql_test func9-120 {
do_execsql_test func9-130 {
SELECT concat_ws(',',1,2,3,4,5,6,7,8,NULL,9,10,11,12);
} {1,2,3,4,5,6,7,8,9,10,11,12}
+do_execsql_test func9-131 {
+ SELECT concat_ws(',',1,2,3,4,'',6,7,8,NULL,9,10,11,12);
+} {1,2,3,4,,6,7,8,9,10,11,12}
do_execsql_test func9-140 {
SELECT concat_ws(NULL,1,2,3,4,5,6,7,8,NULL,9,10,11,12);
} {{}}