diff options
author | Alexander Barkov <bar@mariadb.org> | 2016-06-10 17:06:38 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2016-06-10 17:06:38 +0400 |
commit | 4155d0937b98e57a93adbe5b5dc20d06ceda59e7 (patch) | |
tree | 165bc57c43c4db2ca7dad2b95a275c3386dca5dc /mysql-test/r/ctype_utf8.result | |
parent | df1448801ceba4d8d8a02db83ba022fea9e6755d (diff) | |
download | mariadb-git-4155d0937b98e57a93adbe5b5dc20d06ceda59e7.tar.gz |
MDEV-8402 Bug #77473 Truncated data with subquery & UTF8
Diffstat (limited to 'mysql-test/r/ctype_utf8.result')
-rw-r--r-- | mysql-test/r/ctype_utf8.result | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_utf8.result b/mysql-test/r/ctype_utf8.result index 217d3ca26d8..121168c2a2a 100644 --- a/mysql-test/r/ctype_utf8.result +++ b/mysql-test/r/ctype_utf8.result @@ -5830,5 +5830,44 @@ OCTET_LENGTH(a) a 255 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA DROP TABLE t1; # +# MDEV-8402 Bug#77473 Bug#21317406 TRUNCATED DATA WITH SUBQUERY & UTF8 +# +# +SET NAMES utf8; +SELECT length(rpad(_utf8 0xD0B1, 65536, _utf8 0xD0B2)) AS data; +data +131072 +SELECT length(data) AS len FROM ( +SELECT rpad(_utf8 0xD0B1, 65536, _utf8 0xD0B2) AS data +) AS sub; +len +131072 +SELECT length(rpad(_utf8 0xD0B1, 65535, _utf8 0xD0B2)) AS data; +data +131070 +SELECT length(data) AS len FROM ( +SELECT rpad(_utf8 0xD0B1, 65535, _utf8 0xD0B2) AS data +) AS sub; +len +131070 +SELECT length(data) AS len FROM (SELECT REPEAT('ä', 36766) AS data) AS sub; +len +73532 +SELECT length(data) AS len FROM (SELECT REPEAT('ä', 36767) AS data) AS sub; +len +73534 +SELECT length(data) AS len FROM (SELECT REPEAT('ä', 36778) AS data) AS sub; +len +73556 +SELECT length(data) AS len FROM (SELECT REPEAT('ä', 65535) AS data) AS sub; +len +131070 +SELECT length(data) AS len FROM (SELECT REPEAT('ä', 65536) AS data) AS sub; +len +131072 +SELECT length(data) AS len FROM (SELECT REPEAT('ä', 65537) AS data) AS sub; +len +131074 +# # End of 5.5 tests # |