1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/main/func_sformat.test b/mysql-test/main/func_sformat.test
index bbbf0d0d576..9775810148b 100644
--- a/mysql-test/main/func_sformat.test
+++ b/mysql-test/main/func_sformat.test
@@ -188,3 +188,14 @@ echo #;
 echo # Unsupported/disabled features;
 echo #;
 select sformat('{:p}', '50');
+
+echo #;
+echo # ucs2 test;
+echo #;
+select sformat('={}=', _ucs2 x'006100620063');
+set names utf8;
+select sformat(_ucs2 x'003D007B007D003D', _ucs2 x'0442043504410442');
+select hex(sformat(_ucs2 x'003D007B007D003D', _ucs2 x'0442043504410442'));
+create table t1 as select sformat(_ucs2 x'003D007B007D003D', _ucs2 x'0442043504410442') as x;
+show create table t1;
+drop table t1;