summaryrefslogtreecommitdiff
path: root/mysql-test/t/ctype_utf8.test
diff options
context:
space:
mode:
authorNirbhay Choubey <nirbhay@mariadb.com>2016-06-23 12:54:38 -0400
committerNirbhay Choubey <nirbhay@mariadb.com>2016-06-23 12:54:38 -0400
commitecdb2b6e86d4bef2718eaec61f1edd1c11e41e1a (patch)
tree010cc373543ab2e65c63b9e1e56a62252afa3c50 /mysql-test/t/ctype_utf8.test
parent51a32ebeb3653bfed481a3ddbfe5f93aecdf4a35 (diff)
parent12ae840375fe30da1c23647facaa0678858d6d92 (diff)
downloadmariadb-git-ecdb2b6e86d4bef2718eaec61f1edd1c11e41e1a.tar.gz
Merge tag 'mariadb-5.5.50' into 5.5-galeramariadb-galera-5.5.50
Diffstat (limited to 'mysql-test/t/ctype_utf8.test')
-rw-r--r--mysql-test/t/ctype_utf8.test23
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/t/ctype_utf8.test b/mysql-test/t/ctype_utf8.test
index a9b5cee11ce..d6fdc6c6a2c 100644
--- a/mysql-test/t/ctype_utf8.test
+++ b/mysql-test/t/ctype_utf8.test
@@ -1659,5 +1659,28 @@ SELECT OCTET_LENGTH(a),a FROM t1;
DROP TABLE t1;
--echo #
+--echo # MDEV-8402 Bug#77473 Bug#21317406 TRUNCATED DATA WITH SUBQUERY & UTF8
+--echo #
+--echo #
+
+SET NAMES utf8;
+SELECT length(rpad(_utf8 0xD0B1, 65536, _utf8 0xD0B2)) AS data;
+SELECT length(data) AS len FROM (
+ SELECT rpad(_utf8 0xD0B1, 65536, _utf8 0xD0B2) AS data
+) AS sub;
+
+SELECT length(rpad(_utf8 0xD0B1, 65535, _utf8 0xD0B2)) AS data;
+SELECT length(data) AS len FROM (
+ SELECT rpad(_utf8 0xD0B1, 65535, _utf8 0xD0B2) AS data
+) AS sub;
+
+SELECT length(data) AS len FROM (SELECT REPEAT('ä', 36766) AS data) AS sub;
+SELECT length(data) AS len FROM (SELECT REPEAT('ä', 36767) AS data) AS sub;
+SELECT length(data) AS len FROM (SELECT REPEAT('ä', 36778) AS data) AS sub;
+SELECT length(data) AS len FROM (SELECT REPEAT('ä', 65535) AS data) AS sub;
+SELECT length(data) AS len FROM (SELECT REPEAT('ä', 65536) AS data) AS sub;
+SELECT length(data) AS len FROM (SELECT REPEAT('ä', 65537) AS data) AS sub;
+
+--echo #
--echo # End of 5.5 tests
--echo #