summaryrefslogtreecommitdiff
path: root/mysql-test/t/dyncol.test
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2015-12-14 15:02:39 +0100
committerOleksandr Byelkin <sanja@mariadb.com>2015-12-15 14:08:29 +0100
commita75ac82c2f24a6a7ffb2effe90455d367913b78d (patch)
treee87fa099c52859c3a88d13dae6283d33fc5c6d4e /mysql-test/t/dyncol.test
parent98c9fbfa215242f2930990a0a80b9c5642d23e58 (diff)
downloadmariadb-git-a75ac82c2f24a6a7ffb2effe90455d367913b78d.tar.gz
MDEV-9147: Character set is ignored in Dynamic Column for saved string
Fixed moving charset from definition to the value.
Diffstat (limited to 'mysql-test/t/dyncol.test')
-rw-r--r--mysql-test/t/dyncol.test7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/dyncol.test b/mysql-test/t/dyncol.test
index 0f4058d4eef..f0b8e0444f1 100644
--- a/mysql-test/t/dyncol.test
+++ b/mysql-test/t/dyncol.test
@@ -902,5 +902,12 @@ select column_json(column_create('float', 1.23456789012345E+100 as double));
select column_json(column_create('float', 1.23456789012345E+10 as double));
--echo #
+--echo # MDEV-9147: Character set is ignored in Dynamic Column for saved string
+--echo #
+SET NAMES utf8;
+SELECT COLUMN_GET(COLUMN_CREATE(1, 0xC2A2 AS CHAR CHARACTER SET latin1), 1 AS CHAR CHARACTER SET utf8) AS a;
+SELECT COLUMN_GET(COLUMN_CREATE(1, 0xC2A2 AS CHAR CHARACTER SET utf8), 1 AS CHAR CHARACTER SET utf8) AS a;
+
+--echo #
--echo # end of 10.0 tests
--echo #