diff options
author | Rucha Deodhar <rucha.deodhar@mariadb.com> | 2021-02-15 01:39:37 +0530 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2021-05-19 06:48:36 +0200 |
commit | 2fdb556e045e9918410086eeaac5a94a4c028626 (patch) | |
tree | 1420013b4e76b3192cb8ac33406c818d3ecfc3af /mysql-test/main/cast.result | |
parent | c366845a0b5c08285c958cf1500b3b7906ecf8d4 (diff) | |
download | mariadb-git-2fdb556e045e9918410086eeaac5a94a4c028626.tar.gz |
MDEV-8334: Rename utf8 to utf8mb3
This patch changes the main name of 3 byte character set from utf8 to
utf8mb3. New old_mode UTF8_IS_UTF8MB3 is added and set TRUE by default,
so that utf8 would mean utf8mb3. If not set, utf8 would mean utf8mb4.
Diffstat (limited to 'mysql-test/main/cast.result')
-rw-r--r-- | mysql-test/main/cast.result | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/main/cast.result b/mysql-test/main/cast.result index 6f6de3c8e79..2c01021c700 100644 --- a/mysql-test/main/cast.result +++ b/mysql-test/main/cast.result @@ -477,11 +477,11 @@ c1 c2 c3 c4 c5 show create table t1; Table Create Table t1 CREATE TABLE `t1` ( - `c1` varchar(2) CHARACTER SET utf8 NOT NULL, - `c2` varchar(2) CHARACTER SET utf8 NOT NULL, - `c3` varchar(2) CHARACTER SET utf8 NOT NULL, - `c4` varchar(2) CHARACTER SET utf8 NOT NULL, - `c5` varchar(2) CHARACTER SET utf8 NOT NULL + `c1` varchar(2) CHARACTER SET utf8mb3 NOT NULL, + `c2` varchar(2) CHARACTER SET utf8mb3 NOT NULL, + `c3` varchar(2) CHARACTER SET utf8mb3 NOT NULL, + `c4` varchar(2) CHARACTER SET utf8mb3 NOT NULL, + `c5` varchar(2) CHARACTER SET utf8mb3 NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; create table t1 (a binary(4), b char(4) character set koi8r); @@ -822,13 +822,13 @@ collation(cast("a" as char(10) binary)) latin1_bin select collation(cast("a" as char(10) charset utf8 binary)); collation(cast("a" as char(10) charset utf8 binary)) -utf8_bin +utf8mb3_bin select collation(cast("a" as char(10) ascii binary)); collation(cast("a" as char(10) ascii binary)) latin1_bin select collation(cast("a" as char(10) binary charset utf8)); collation(cast("a" as char(10) binary charset utf8)) -utf8_bin +utf8mb3_bin select collation(cast("a" as char(10) binary ascii)); collation(cast("a" as char(10) binary ascii)) latin1_bin @@ -1239,14 +1239,14 @@ DECLARE a VARCHAR(30) CHARACTER SET utf8; SET a=CAST(_utf8 0xD18F AS CHAR(1) CHARACTER SET latin1); END; $$ -ERROR HY000: Cannot convert 'utf8' character 0xD18F to 'latin1' +ERROR HY000: Cannot convert 'utf8mb3' character 0xD18F to 'latin1' # Conversion problems still escalate warnings to errors (with right truncation) BEGIN NOT ATOMIC DECLARE a VARCHAR(30) CHARACTER SET utf8; SET a=CAST(_utf8 0xD18FD18F AS CHAR(1) CHARACTER SET latin1); END; $$ -ERROR HY000: Cannot convert 'utf8' character 0xD18F to 'latin1' +ERROR HY000: Cannot convert 'utf8mb3' character 0xD18F to 'latin1' # CAST(number AS CHAR) escalates warnings to errors on truncation CREATE OR REPLACE TABLE t1 (a VARCHAR(10)); INSERT INTO t1 VALUES (CAST(123 AS CHAR(1))); |