diff options
author | drh <> | 2025-06-11 00:01:42 +0000 |
---|---|---|
committer | drh <> | 2025-06-11 00:01:42 +0000 |
commit | 23e59b34e9d6c574280b7a1e29499c7d0805b01a (patch) | |
tree | 5d2c435b59eea21ff924f2f75f3e527488e6ccd1 /test | |
parent | a09a4fbac958ab3c130c73500cc3cf68f9151d50 (diff) | |
download | sqlite-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.test | 3 |
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); } {{}} |