diff options
Diffstat (limited to 'mysql-test/r/ctype_utf8mb4_innodb.result')
-rw-r--r-- | mysql-test/r/ctype_utf8mb4_innodb.result | 40 |
1 files changed, 31 insertions, 9 deletions
diff --git a/mysql-test/r/ctype_utf8mb4_innodb.result b/mysql-test/r/ctype_utf8mb4_innodb.result index 28b566c19eb..045723960e6 100644 --- a/mysql-test/r/ctype_utf8mb4_innodb.result +++ b/mysql-test/r/ctype_utf8mb4_innodb.result @@ -156,6 +156,7 @@ F0CFCEC5C4C5CCD8CEC9CB Понедельник drop table t1; set LC_TIME_NAMES='en_US'; set names koi8r; +set sql_mode = 'NO_ENGINE_SUBSTITUTION'; create table t1 (s1 char(1) character set utf8mb4) engine InnoDB; insert into t1 values (_koi8r''); Warnings: @@ -219,6 +220,8 @@ length(s1) char_length(s1) 65535 43690 65535 65535 drop table t1; +set sql_mode = default; +set sql_mode = 'NO_ENGINE_SUBSTITUTION'; create table t1 (s1 char(10) character set utf8mb4) engine InnoDB; insert into t1 values (0x41FF); Warnings: @@ -243,6 +246,7 @@ select hex(s1) from t1; hex(s1) 413F drop table t1; +set sql_mode = default; create table t1 (a text character set utf8mb4, primary key(a(371))) engine InnoDB; ERROR 42000: Specified key was too long; max key length is 767 bytes CREATE TABLE t1 ( a varchar(10) ) CHARACTER SET utf8mb4 ENGINE InnoDB; @@ -901,8 +905,8 @@ create table t2 engine InnoDB select concat(a,_utf8mb4'') as a, concat(b,_utf8mb show create table t2; Table Create Table t2 CREATE TABLE `t2` ( - `a` varchar(5) CHARACTER SET utf8mb4 NOT NULL, - `b` varchar(15) CHARACTER SET utf8mb4 NOT NULL + `a` varchar(5) CHARACTER SET utf8mb4 DEFAULT NULL, + `b` varchar(15) CHARACTER SET utf8mb4 DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 drop table t2; drop table t1; @@ -1126,7 +1130,7 @@ CREATE TABLE t1 AS SELECT REPEAT('a',1) AS a, 1 AS b LIMIT 0; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `a` varchar(1) CHARACTER SET utf8mb4 NOT NULL, + `a` varchar(1) CHARACTER SET utf8mb4 DEFAULT NULL, `b` int(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 INSERT INTO t1 VALUES ('s',0),(_latin1 0xDF,1); @@ -1333,6 +1337,7 @@ ERROR 42000: Invalid default value for 'x' create table t1 (x enum('A', 'B') default 0) character set utf8mb4 engine InnoDB; ERROR 42000: Invalid default value for 'x' SET NAMES UTF8; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; CREATE TABLE t1 ( `id` int(20) NOT NULL auto_increment, `country` varchar(100) NOT NULL default '', @@ -1366,12 +1371,15 @@ content msisdn ERR Имри.Афимим.Аеимимримдмримрмрирор имримримримр имридм ирбднримрфмририримрфмфмим.Ад.Д имдимримрад.Адимримримрмдиримримримр м.Дадимфшьмримд им.Адимимрн имадми 1234567890 11 g 1234567890 DROP TABLE t1,t2; +SET sql_mode = DEFAULT; create table t1 (a char(20) character set utf8mb4) engine InnoDB; insert into t1 values ('123456'),('андрей'); +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; alter table t1 modify a char(2) character set utf8mb4; Warnings: Warning 1265 Data truncated for column 'a' at row 1 Warning 1265 Data truncated for column 'a' at row 2 +SET sql_mode = DEFAULT; select char_length(a), length(a), a from t1 order by a; char_length(a) length(a) a 2 2 12 @@ -1841,6 +1849,7 @@ aa xxx yyy DROP TABLE t1; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; create table t1 ( a varchar(26) not null ) default character set utf8mb4 ENGINE InnoDB; @@ -1884,6 +1893,7 @@ select length(a) from t1; length(a) 3000 drop table t1; +SET sql_mode = DEFAULT; set names utf8mb4; select hex(char(1 using utf8mb4)); hex(char(1 using utf8mb4)) @@ -1899,12 +1909,12 @@ char(53647 using utf8mb4) я select char(0xff,0x8f using utf8mb4); char(0xff,0x8f using utf8mb4) - +NULL Warnings: Warning 1300 Invalid utf8mb4 character string: 'FF8F' select convert(char(0xff,0x8f) using utf8mb4); convert(char(0xff,0x8f) using utf8mb4) -?? +NULL Warnings: Warning 1300 Invalid utf8mb4 character string: '\xFF\x8F' set sql_mode=traditional; @@ -2113,12 +2123,12 @@ ERROR HY000: Invalid utf8mb4 character string: 'FF' set sql_mode=default; select hex(char(0xFF using utf8mb4)); hex(char(0xFF using utf8mb4)) - +NULL Warnings: Warning 1300 Invalid utf8mb4 character string: 'FF' select hex(convert(0xFF using utf8mb4)); hex(convert(0xFF using utf8mb4)) -3F +NULL Warnings: Warning 1300 Invalid utf8mb4 character string: '\xFF' select hex(_utf8mb4 0x616263FF); @@ -2281,6 +2291,8 @@ Testing [F0][90..BF][80..BF][80..BF] insert into t1 values (0xF0908080); insert into t1 values (0xF0BFBFBF); insert into t1 values (0xF08F8080); +ERROR 22007: Incorrect string value: '\xF0\x8F\x80\x80' for column 'utf8mb4' at row 1 +insert ignore into t1 values (0xF08F8080); Warnings: Warning 1366 Incorrect string value: '\xF0\x8F\x80\x80' for column 'utf8mb4' at row 1 select hex(utf8mb4) from t1; @@ -2301,6 +2313,8 @@ Testing [F4][80..8F][80..BF][80..BF] insert into t1 values (0xF4808080); insert into t1 values (0xF48F8080); insert into t1 values (0xF4908080); +ERROR 22007: Incorrect string value: '\xF4\x90\x80\x80' for column 'utf8mb4' at row 1 +insert ignore into t1 values (0xF4908080); Warnings: Warning 1366 Incorrect string value: '\xF4\x90\x80\x80' for column 'utf8mb4' at row 1 select hex(utf8mb4) from t1; @@ -2378,7 +2392,7 @@ INSERT INTO t1 VALUES (119040, x'f09d8480'), (917999, x'f3a087af'); INSERT INTO t1 VALUES (119070, x'f09d849ef09d859ef09d859ef09d8480f09d859ff09d859ff09d859ff09d85a0f09d85a0f09d8480'); INSERT INTO t1 VALUES (65131, x'efb9abf09d849ef09d859ef09d859ef09d8480f09d859fefb9abefb9abf09d85a0efb9ab'); -INSERT INTO t1 VALUES (119070, x'f09d849ef09d859ef09d859ef09d8480f09d859ff09d859ff09d859ff09d85a0f09d85a0f09d8480f09d85a0'); +INSERT IGNORE INTO t1 VALUES (119070, x'f09d849ef09d859ef09d859ef09d8480f09d859ff09d859ff09d859ff09d85a0f09d85a0f09d8480f09d85a0'); Warnings: Warning 1265 Data truncated for column 'utf8mb4_encoding' at row 1 SELECT u_decimal, hex(utf8mb4_encoding) FROM t1 ORDER BY utf8mb4_encoding COLLATE utf8mb4_general_ci, BINARY utf8mb4_encoding; @@ -2395,6 +2409,8 @@ u_decimal hex(utf8mb4_encoding) 65131 EFB9ABF09D849EF09D859EF09D859EF09D8480F09D859FEFB9ABEFB9ABF09D85A0EFB9AB 917999 F3A087AF INSERT INTO t1 VALUES (1114111, x'f5808080'); +ERROR 22007: Incorrect string value: '\xF5\x80\x80\x80' for column 'utf8mb4_encoding' at row 1 +INSERT IGNORE INTO t1 VALUES (1114111, x'f5808080'); Warnings: Warning 1366 Incorrect string value: '\xF5\x80\x80\x80' for column 'utf8mb4_encoding' at row 1 SELECT character_maximum_length, character_octet_length FROM information_schema.columns WHERE @@ -2409,6 +2425,8 @@ utf8mb3_encoding VARCHAR(10) NOT NULL INSERT INTO t2 VALUES (42856, x'ea9da8'); INSERT INTO t2 VALUES (65131, x'efb9ab'); INSERT INTO t2 VALUES (1114111, x'f48fbfbf'); +ERROR 22007: Incorrect string value: '\xF4\x8F\xBF\xBF' for column 'utf8mb3_encoding' at row 1 +INSERT IGNORE INTO t2 VALUES (1114111, x'f48fbfbf'); Warnings: Warning 1366 Incorrect string value: '\xF4\x8F\xBF\xBF' for column 'utf8mb3_encoding' at row 1 SELECT character_maximum_length, character_octet_length FROM information_schema.columns WHERE @@ -2416,6 +2434,8 @@ table_name= 't2' AND column_name= 'utf8mb3_encoding'; character_maximum_length character_octet_length 10 30 UPDATE t2 SET utf8mb3_encoding= x'f48fbfbd' where u_decimal= 42856; +ERROR 22007: Incorrect string value: '\xF4\x8F\xBF\xBD' for column 'utf8mb3_encoding' at row 1 +UPDATE IGNORE t2 SET utf8mb3_encoding= x'f48fbfbd' where u_decimal= 42856; Warnings: Warning 1366 Incorrect string value: '\xF4\x8F\xBF\xBD' for column 'utf8mb3_encoding' at row 1 UPDATE t2 SET utf8mb3_encoding= _utf8mb4 x'ea9da8' where u_decimal= 42856; @@ -2475,7 +2495,9 @@ SELECT count(*) FROM t1, t2 WHERE t1.utf8mb4_encoding > t2.utf8mb3_encoding; count(*) 33 +set sql_mode = 'NO_ENGINE_SUBSTITUTION'; ALTER TABLE t1 CONVERT TO CHARACTER SET utf8; +set sql_mode = default; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( @@ -2615,7 +2637,7 @@ Table Create Table t3 CREATE TEMPORARY TABLE `t3` ( `utf8mb4` varchar(10) CHARACTER SET utf8mb4 NOT NULL, `utf8mb3` varchar(10) CHARACTER SET utf8 NOT NULL, - `concat(utf8mb4,utf8mb3)` varchar(20) CHARACTER SET utf8mb4 NOT NULL + `concat(utf8mb4,utf8mb3)` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DROP TEMPORARY TABLE t3; SELECT * FROM t1, t2 WHERE t1.utf8mb4 > t2.utf8mb3; |