summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorTor Didriksen <tor.didriksen@oracle.com>2017-08-15 13:15:19 +0200
committerTor Didriksen <tor.didriksen@oracle.com>2017-08-23 07:32:49 +0200
commitebd96c314953f5c0073ff5846484fd5e438fe0ad (patch)
treeb463a71d6e66267ea4469c1814a0837b150c1258 /mysql-test/t
parentd75f8a174218fd0ada64222d2a538f7aace897bc (diff)
downloadmariadb-git-ebd96c314953f5c0073ff5846484fd5e438fe0ad.tar.gz
Bug#19875294 ASSERTION `SRC' FAILED IN MY_STRNXFRM_UNICODE (SIG 6 -STRINGS/CTYPE-UTF8.C:5151)
Backport from 5.7 to 5.5 Field_set::val_str() should return String("", 0, cs) rather than String(NULL, 0, cs)
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/case.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/case.test b/mysql-test/t/case.test
index e1c807fe32b..c2d8f44e953 100644
--- a/mysql-test/t/case.test
+++ b/mysql-test/t/case.test
@@ -173,3 +173,15 @@ select t1.a, (case t1.a when 0 then 0 else t1.b end) d from t1
drop table t1, t2;
--echo End of 5.0 tests
+
+--echo #
+--echo # Bug#19875294 ASSERTION `SRC' FAILED IN MY_STRNXFRM_UNICODE
+--echo # (SIG 6 -STRINGS/CTYPE-UTF8.C:5151)
+--echo #
+
+set @@sql_mode='';
+CREATE TABLE t1(c1 SET('','')CHARACTER SET ucs2) engine=innodb;
+INSERT INTO t1 VALUES(990101.102);
+SELECT COALESCE(c1)FROM t1 ORDER BY 1;
+DROP TABLE t1;
+set @@sql_mode=default;