diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2015-09-03 12:58:41 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2015-09-03 12:58:41 +0200 |
| commit | 530a6e74819ec14b5fdc42aa588b236ecb9f2fcd (patch) | |
| tree | a4d45b1fd0e434c23577507364fa443226676eb5 /mysql-test/r | |
| parent | 5088cbf4ed7224698678f3eaf406361c6e7db4b8 (diff) | |
| parent | 4b41e3c7f33714186c97a6cc2e6d3bb93b050c61 (diff) | |
| download | mariadb-git-530a6e74819ec14b5fdc42aa588b236ecb9f2fcd.tar.gz | |
Merge branch '10.0' into 10.1
referenced_by_foreign_key2(), needed for InnoDB to compile,
was taken from 10.0-galera
Diffstat (limited to 'mysql-test/r')
34 files changed, 1872 insertions, 1309 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index 2d482aa3365..2c2275462cc 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -1782,8 +1782,8 @@ ALTER TABLE tm1 DROP INDEX im3; affected rows: 2 info: Records: 2 Duplicates: 0 Warnings: 0 ALTER TABLE ti1 DROP COLUMN d2; -affected rows: 2 -info: Records: 2 Duplicates: 0 Warnings: 0 +affected rows: 0 +info: Records: 0 Duplicates: 0 Warnings: 0 ALTER TABLE tm1 DROP COLUMN d2; affected rows: 2 info: Records: 2 Duplicates: 0 Warnings: 0 diff --git a/mysql-test/r/blackhole_plugin.result b/mysql-test/r/blackhole_plugin.result index 4ef9fa0fa47..dd1b95ab0d9 100644 --- a/mysql-test/r/blackhole_plugin.result +++ b/mysql-test/r/blackhole_plugin.result @@ -5,7 +5,7 @@ Warning 1266 Using storage engine MyISAM for table 't1' DROP TABLE t1; INSTALL PLUGIN blackhole SONAME 'ha_blackhole.so'; INSTALL PLUGIN BLACKHOLE SONAME 'ha_blackhole.so'; -ERROR HY000: Function 'BLACKHOLE' already exists +ERROR HY000: Plugin 'BLACKHOLE' already installed UNINSTALL PLUGIN blackhole; INSTALL PLUGIN blackhole SONAME 'ha_blackhole.so'; CREATE TABLE t1(a int) ENGINE=BLACKHOLE; diff --git a/mysql-test/r/create_drop_binlog.result b/mysql-test/r/create_drop_binlog.result index 4a6fa7a8d14..8f6b35a7c8c 100644 --- a/mysql-test/r/create_drop_binlog.result +++ b/mysql-test/r/create_drop_binlog.result @@ -187,11 +187,11 @@ DROP ROLE r1; CREATE ROLE IF NOT EXISTS r1; CREATE ROLE IF NOT EXISTS r1; Warnings: -Note 1974 Can't create role 'r1'; it already exists +Note 1975 Can't create role 'r1'; it already exists DROP ROLE IF EXISTS r1; DROP ROLE IF EXISTS r1; Warnings: -Note 1975 Can't drop role 'r1'; it doesn't exist +Note 1976 Can't drop role 'r1'; it doesn't exist SHOW BINLOG EVENTS; Log_name Pos Event_type Server_id End_log_pos Info # # Format_desc 1 # VER @@ -218,11 +218,11 @@ DROP USER u1@localhost; CREATE USER IF NOT EXISTS u1@localhost; CREATE USER IF NOT EXISTS u1@localhost; Warnings: -Note 1972 Can't create user 'u1'@'localhost'; it already exists +Note 1973 Can't create user 'u1'@'localhost'; it already exists DROP USER IF EXISTS u1@localhost; DROP USER IF EXISTS u1@localhost; Warnings: -Note 1973 Can't drop user 'u1'@'localhost'; it doesn't exist +Note 1974 Can't drop user 'u1'@'localhost'; it doesn't exist SHOW BINLOG EVENTS; Log_name Pos Event_type Server_id End_log_pos Info # # Format_desc 1 # VER diff --git a/mysql-test/r/create_drop_role.result b/mysql-test/r/create_drop_role.result index 7fc969cbe5a..6e05900264d 100644 --- a/mysql-test/r/create_drop_role.result +++ b/mysql-test/r/create_drop_role.result @@ -20,7 +20,7 @@ Host User Role Admin_option CREATE ROLE IF NOT EXISTS role1 WITH ADMIN user4; Warnings: Note 1449 The user specified as a definer ('user4'@'%') does not exist -Note 1974 Can't create role 'role1'; it already exists +Note 1975 Can't create role 'role1'; it already exists SELECT * FROM mysql.roles_mapping WHERE Role='role1'; Host User Role Admin_option % user3 role1 Y @@ -29,11 +29,11 @@ SELECT * FROM mysql.roles_mapping WHERE Role='role1'; Host User Role Admin_option DROP ROLE IF EXISTS role1; Warnings: -Note 1975 Can't drop role 'role1'; it doesn't exist +Note 1976 Can't drop role 'role1'; it doesn't exist CREATE ROLE role_1; CREATE ROLE IF NOT EXISTS role_1; Warnings: -Note 1974 Can't create role 'role_1'; it already exists +Note 1975 Can't create role 'role_1'; it already exists CREATE OR REPLACE ROLE role_1; CREATE OR REPLACE ROLE IF NOT EXISTS role_1; ERROR HY000: Incorrect usage of OR REPLACE and IF NOT EXISTS @@ -69,7 +69,7 @@ SET ROLE NONE; DROP ROLE role_1; DROP ROLE IF EXISTS role_1; Warnings: -Note 1975 Can't drop role 'role_1'; it doesn't exist +Note 1976 Can't drop role 'role_1'; it doesn't exist DROP ROLE role_1; ERROR HY000: Operation DROP ROLE failed for 'role_1' DROP USER u1@localhost; diff --git a/mysql-test/r/create_drop_user.result b/mysql-test/r/create_drop_user.result index 3c388545199..dd75d1c257a 100644 --- a/mysql-test/r/create_drop_user.result +++ b/mysql-test/r/create_drop_user.result @@ -4,7 +4,7 @@ password *2B602296A79E0A8784ACC5C88D92E46588CCA3C3 CREATE USER IF NOT EXISTS u1@localhost IDENTIFIED BY 'pw2'; Warnings: -Note 1972 Can't create user 'u1'@'localhost'; it already exists +Note 1973 Can't create user 'u1'@'localhost'; it already exists SELECT password FROM mysql.user WHERE user='u1'; password *2B602296A79E0A8784ACC5C88D92E46588CCA3C3 @@ -20,7 +20,7 @@ password DROP USER IF EXISTS u1@localhost; DROP USER IF EXISTS u1@localhost; Warnings: -Note 1973 Can't drop user 'u1'@'localhost'; it doesn't exist +Note 1974 Can't drop user 'u1'@'localhost'; it doesn't exist DROP USER u1@localhost; ERROR HY000: Operation DROP USER failed for 'u1'@'localhost' CREATE OR REPLACE USER u1@localhost; @@ -38,6 +38,6 @@ CREATE OR REPLACE USER u1 IDENTIFIED BY PASSWORD 'abcdefghijklmnop', u2; DROP USER u1; DROP USER IF EXISTS u1, u2; Warnings: -Note 1973 Can't drop user 'u1'@'%'; it doesn't exist +Note 1974 Can't drop user 'u1'@'%'; it doesn't exist DROP USER u2; ERROR HY000: Operation DROP USER failed for 'u2'@'%' diff --git a/mysql-test/r/ctype_big5.result b/mysql-test/r/ctype_big5.result index a5e52106926..f97d060d26a 100644 --- a/mysql-test/r/ctype_big5.result +++ b/mysql-test/r/ctype_big5.result @@ -512,7 +512,7 @@ select hex(convert(_big5 0xC84041 using ucs2)); hex(convert(_big5 0xC84041 using ucs2)) 003F0041 Warnings: -Warning 1976 Cannot convert 'big5' character 0xC840 to 'ucs2' +Warning 1977 Cannot convert 'big5' character 0xC840 to 'ucs2' End of 4.1 tests set names big5; create table t1 (a blob); @@ -789,70 +789,70 @@ A2C0 Ⅷ A2C1 Ⅸ A2C2 Ⅹ Warnings: -Warning 1976 Cannot convert 'big5' character 0xA3C0 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C0 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C1 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C1 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C2 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C2 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C3 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C3 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C4 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C4 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C5 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C5 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C6 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C6 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C7 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C7 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C8 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C8 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C9 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C9 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CA to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CA to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CB to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CB to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CC to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CC to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CD to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CD to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CE to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CE to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CF to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CF to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D0 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D0 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D1 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D1 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D2 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D2 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D3 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D3 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D4 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D4 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D5 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D5 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D6 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D6 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D7 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D7 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D8 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D8 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D9 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D9 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DA to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DA to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DB to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DB to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DC to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DC to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DD to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DD to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DE to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DE to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DF to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DF to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C0 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C0 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C1 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C1 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C2 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C2 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C3 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C3 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C4 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C4 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C5 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C5 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C6 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C6 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C7 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C7 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C8 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C8 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C9 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C9 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CA to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CA to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CB to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CB to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CC to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CC to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CD to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CD to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CE to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CE to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CF to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CF to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D0 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D0 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D1 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D1 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D2 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D2 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D3 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D3 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D4 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D4 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D5 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D5 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D6 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D6 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D7 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D7 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D8 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D8 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D9 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D9 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DA to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DA to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DB to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DB to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DC to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DC to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DD to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DD to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DE to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DE to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DF to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DF to 'utf8' SELECT * FROM t1 WHERE HEX(CAST(UPPER(a) AS CHAR CHARACTER SET utf8)) <> HEX(UPPER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; @@ -868,70 +868,70 @@ C7D9 р C7DA с C7DB т Warnings: -Warning 1976 Cannot convert 'big5' character 0xA3C0 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C0 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C1 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C1 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C2 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C2 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C3 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C3 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C4 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C4 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C5 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C5 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C6 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C6 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C7 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C7 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C8 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C8 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C9 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3C9 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CA to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CA to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CB to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CB to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CC to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CC to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CD to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CD to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CE to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CE to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CF to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3CF to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D0 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D0 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D1 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D1 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D2 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D2 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D3 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D3 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D4 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D4 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D5 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D5 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D6 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D6 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D7 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D7 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D8 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D8 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D9 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3D9 to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DA to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DA to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DB to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DB to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DC to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DC to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DD to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DD to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DE to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DE to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DF to 'utf8' -Warning 1976 Cannot convert 'big5' character 0xA3DF to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C0 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C0 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C1 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C1 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C2 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C2 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C3 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C3 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C4 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C4 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C5 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C5 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C6 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C6 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C7 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C7 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C8 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C8 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C9 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3C9 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CA to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CA to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CB to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CB to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CC to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CC to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CD to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CD to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CE to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CE to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CF to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3CF to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D0 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D0 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D1 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D1 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D2 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D2 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D3 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D3 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D4 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D4 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D5 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D5 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D6 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D6 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D7 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D7 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D8 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D8 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D9 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3D9 to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DA to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DA to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DB to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DB to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DC to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DC to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DD to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DD to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DE to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DE to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DF to 'utf8' +Warning 1977 Cannot convert 'big5' character 0xA3DF to 'utf8' DROP TABLE t1; # # End of 5.5 tests diff --git a/mysql-test/r/ctype_cp1251.result b/mysql-test/r/ctype_cp1251.result index 9d6185a9420..92678f200bd 100644 --- a/mysql-test/r/ctype_cp1251.result +++ b/mysql-test/r/ctype_cp1251.result @@ -386,7 +386,7 @@ FD FD FD D18D FD FE FE FE D18E FE FF FF FF D18F FF Warnings: -Warning 1976 Cannot convert 'cp1251' character 0x98 to 'utf8' +Warning 1977 Cannot convert 'cp1251' character 0x98 to 'utf8' DROP TABLE t1; set global LC_TIME_NAMES=convert((-8388608) using cp1251); ERROR HY000: Unknown locale: '-8388608' diff --git a/mysql-test/r/ctype_cp932_binlog_stm.result b/mysql-test/r/ctype_cp932_binlog_stm.result index 3916f427920..75d05aa9f0a 100644 --- a/mysql-test/r/ctype_cp932_binlog_stm.result +++ b/mysql-test/r/ctype_cp932_binlog_stm.result @@ -387,139 +387,139 @@ HEX(LOWER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; code a 81F0 Å Warnings: -Warning 1976 Cannot convert 'cp932' character 0x81AD to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AD to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AE to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AE to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AF to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AF to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81CF to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81CF to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D8 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D8 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D9 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D9 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81E9 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81E9 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81EA to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81EA to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AD to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AD to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AE to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AE to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AF to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AF to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81CF to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81CF to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D8 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D8 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D9 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D9 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81E9 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81E9 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81EA to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81EA to 'utf8' SELECT * FROM t1 WHERE HEX(CAST(UPPER(a) AS CHAR CHARACTER SET utf8)) <> HEX(UPPER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; code a Warnings: -Warning 1976 Cannot convert 'cp932' character 0x81AD to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AD to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AE to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AE to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AF to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AF to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81CF to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81CF to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D8 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D8 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D9 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D9 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81E9 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81E9 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81EA to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81EA to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AD to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AD to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AE to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AE to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AF to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AF to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81CF to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81CF to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D8 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D8 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D9 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D9 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81E9 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81E9 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81EA to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81EA to 'utf8' # # WL#3090 Japanese Character Set adjustments # Test cp932->Unicode conversion @@ -10195,70 +10195,70 @@ FC49 EFA8AD FC4A E9B899 FC4B E9BB91 Warnings: -Warning 1976 Cannot convert 'cp932' character 0x81AD to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AE to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81AF to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81B7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81C7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81CF to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D0 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D1 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D2 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D3 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D4 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D5 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D6 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D7 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D8 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81D9 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81E9 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81EA to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81EB to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81EC to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81ED to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81EE to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81EF to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81F8 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81F9 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81FA to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x81FB to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x8240 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x8241 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x8242 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x8243 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x8244 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x8245 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x8246 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x8247 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x8248 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x8249 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x824A to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x824B to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x824C to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x824D to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x824E to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x8259 to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x825A to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x825B to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x825C to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x825D to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x825E to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x825F to 'utf8' -Warning 1976 Cannot convert 'cp932' character 0x827A to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AD to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AE to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81AF to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81B7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81C7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81CF to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D0 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D1 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D2 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D3 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D4 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D5 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D6 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D7 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D8 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81D9 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81E9 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81EA to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81EB to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81EC to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81ED to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81EE to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81EF to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81F8 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81F9 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81FA to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x81FB to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x8240 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x8241 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x8242 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x8243 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x8244 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x8245 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x8246 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x8247 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x8248 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x8249 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x824A to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x824B to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x824C to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x824D to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x824E to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x8259 to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x825A to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x825B to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x825C to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x825D to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x825E to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x825F to 'utf8' +Warning 1977 Cannot convert 'cp932' character 0x827A to 'utf8' DROP TABLE t1; # # WL#3090 Japanese Character Set adjustments diff --git a/mysql-test/r/ctype_eucjpms.result b/mysql-test/r/ctype_eucjpms.result index f791ef67671..f9cb4f1eecc 100644 --- a/mysql-test/r/ctype_eucjpms.result +++ b/mysql-test/r/ctype_eucjpms.result @@ -10017,12 +10017,12 @@ select hex(convert(_eucjpms 0xA5FE41 using ucs2)); hex(convert(_eucjpms 0xA5FE41 using ucs2)) 003F0041 Warnings: -Warning 1976 Cannot convert 'eucjpms' character 0xA5FE to 'ucs2' +Warning 1977 Cannot convert 'eucjpms' character 0xA5FE to 'ucs2' select hex(convert(_eucjpms 0x8FABF841 using ucs2)); hex(convert(_eucjpms 0x8FABF841 using ucs2)) 003F0041 Warnings: -Warning 1976 Cannot convert 'eucjpms' character 0x8FABF8 to 'ucs2' +Warning 1977 Cannot convert 'eucjpms' character 0x8FABF8 to 'ucs2' set global LC_TIME_NAMES=convert((convert((0x63) using eucjpms)) using utf8); ERROR HY000: Unknown locale: 'c' # @@ -10589,70 +10589,70 @@ HEX(LOWER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; code a 8FAABC Ģ Warnings: -Warning 1976 Cannot convert 'eucjpms' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2DA to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2DA to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2DB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2DB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EC to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2DA to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2DA to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2DB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2DB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EC to 'utf8' SELECT * FROM t1 WHERE HEX(CAST(UPPER(a) AS CHAR CHARACTER SET utf8)) <> HEX(UPPER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; @@ -10660,70 +10660,70 @@ code a 8FA9C3 ð 8FABB9 ǵ Warnings: -Warning 1976 Cannot convert 'eucjpms' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2DA to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2DA to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2DB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2DB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EC to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2DA to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2DA to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2DB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2DB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EC to 'utf8' # # WL#3090 Japanese Character Set adjustments # Test sjis->Unicode conversion @@ -25810,70 +25810,70 @@ FEFC EE8EA9 FEFD EE8EAA FEFE EE8EAB Warnings: -Warning 1976 Cannot convert 'eucjpms' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2B9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2C9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2D9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2DA to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2DB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EC to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2ED to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EE to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2EF to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2F0 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2F1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2FA to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2FB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2FC to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA2FD to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3A1 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3A2 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3A3 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3A4 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3A5 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3A6 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3A7 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3A8 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3A9 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3AA to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3AB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3AC to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3AD to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3AE to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3AF to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3BA to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3BB to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3BC to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3BD to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3BE to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3BF to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3C0 to 'utf8' -Warning 1976 Cannot convert 'eucjpms' character 0xA3DB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2B9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2C9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2D9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2DA to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2DB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2ED to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EE to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2EF to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2F0 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2F1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2FA to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2FB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2FC to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA2FD to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3A1 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3A2 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3A3 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3A4 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3A5 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3A6 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3A7 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3A8 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3A9 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3AA to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3AB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3AC to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3AD to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3AE to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3AF to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3BA to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3BB to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3BC to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3BD to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3BE to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3BF to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3C0 to 'utf8' +Warning 1977 Cannot convert 'eucjpms' character 0xA3DB to 'utf8' DROP TABLE t1; # # WL#3090 Japanese Character Set adjustments diff --git a/mysql-test/r/ctype_euckr.result b/mysql-test/r/ctype_euckr.result index 847ce5a7e46..90353c6af2a 100644 --- a/mysql-test/r/ctype_euckr.result +++ b/mysql-test/r/ctype_euckr.result @@ -24737,70 +24737,70 @@ HEX(LOWER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; code a A1CA Å Warnings: -Warning 1976 Cannot convert 'euckr' character 0xA2E8 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2E8 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2E9 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2E9 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2ED to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2ED to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EF to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EF to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F0 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F0 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F1 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F1 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F2 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F2 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F3 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F3 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F4 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F4 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F5 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F5 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F6 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F6 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F7 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F7 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F8 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F8 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F9 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F9 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FD to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FD to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AD to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AD to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AF to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AF to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BD to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2E8 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2E8 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2E9 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2E9 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2ED to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2ED to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EF to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EF to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F0 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F0 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F1 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F1 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F2 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F2 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F3 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F3 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F4 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F4 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F5 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F5 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F6 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F6 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F7 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F7 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F8 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F8 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F9 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F9 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AF to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AF to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BD to 'utf8' SELECT * FROM t1 WHERE HEX(CAST(UPPER(a) AS CHAR CHARACTER SET utf8)) <> HEX(UPPER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; @@ -24833,70 +24833,70 @@ A8E5 ⓨ A8E6 ⓩ A9A2 đ Warnings: -Warning 1976 Cannot convert 'euckr' character 0xA2E8 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2E8 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2E9 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2E9 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2ED to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2ED to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EF to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2EF to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F0 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F0 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F1 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F1 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F2 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F2 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F3 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F3 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F4 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F4 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F5 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F5 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F6 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F6 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F7 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F7 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F8 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F8 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F9 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2F9 to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FD to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FD to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA2FE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AD to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AD to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AE to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AF to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5AF to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BA to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BB to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BC to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BD to 'utf8' -Warning 1976 Cannot convert 'euckr' character 0xA5BD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2E8 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2E8 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2E9 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2E9 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2ED to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2ED to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EF to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2EF to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F0 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F0 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F1 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F1 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F2 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F2 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F3 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F3 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F4 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F4 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F5 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F5 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F6 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F6 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F7 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F7 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F8 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F8 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F9 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2F9 to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA2FE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AE to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AF to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5AF to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BA to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BB to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BC to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BD to 'utf8' +Warning 1977 Cannot convert 'euckr' character 0xA5BD to 'utf8' DROP TABLE t1; # # End of 5.5 tests diff --git a/mysql-test/r/ctype_gb2312.result b/mysql-test/r/ctype_gb2312.result index 656d3e357d0..f9f37c00a79 100644 --- a/mysql-test/r/ctype_gb2312.result +++ b/mysql-test/r/ctype_gb2312.result @@ -765,70 +765,70 @@ A2FA Ⅹ A2FB Ⅺ A2FC Ⅻ Warnings: -Warning 1976 Cannot convert 'gb2312' character 0xA2A1 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A1 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A2 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A2 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A3 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A3 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A5 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A5 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A6 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A6 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A7 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A7 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A8 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A8 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A9 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A9 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AA to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AA to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AB to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AB to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AC to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AC to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AD to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AD to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AE to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AE to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2E3 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2E3 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2E4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2E4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2EF to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2EF to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2F0 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2F0 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2FD to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2FD to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2FE to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2FE to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F5 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F5 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F6 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F6 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F7 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F7 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F8 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F8 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F9 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F9 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FA to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FA to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FB to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FB to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FC to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FC to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FD to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A1 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A1 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A2 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A2 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A3 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A3 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A5 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A5 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A6 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A6 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A7 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A7 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A8 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A8 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A9 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A9 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AA to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AA to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AB to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AB to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AC to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AC to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AE to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AE to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2E3 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2E3 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2E4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2E4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2EF to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2EF to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2F0 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2F0 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2FD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2FD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2FE to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2FE to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F5 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F5 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F6 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F6 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F7 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F7 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F8 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F8 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F9 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F9 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FA to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FA to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FB to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FB to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FC to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FC to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FD to 'utf8' SELECT * FROM t1 WHERE HEX(CAST(UPPER(a) AS CHAR CHARACTER SET utf8)) <> HEX(UPPER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; @@ -860,70 +860,70 @@ A8B8 ǜ A8B9 ü A8BA ê Warnings: -Warning 1976 Cannot convert 'gb2312' character 0xA2A1 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A1 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A2 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A2 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A3 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A3 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A5 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A5 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A6 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A6 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A7 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A7 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A8 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A8 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A9 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2A9 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AA to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AA to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AB to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AB to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AC to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AC to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AD to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AD to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AE to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AE to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2E3 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2E3 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2E4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2E4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2EF to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2EF to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2F0 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2F0 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2FD to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2FD to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2FE to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA2FE to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F4 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F5 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F5 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F6 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F6 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F7 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F7 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F8 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F8 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F9 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4F9 to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FA to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FA to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FB to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FB to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FC to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FC to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FD to 'utf8' -Warning 1976 Cannot convert 'gb2312' character 0xA4FD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A1 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A1 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A2 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A2 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A3 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A3 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A5 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A5 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A6 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A6 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A7 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A7 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A8 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A8 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A9 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2A9 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AA to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AA to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AB to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AB to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AC to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AC to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AE to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AE to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2E3 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2E3 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2E4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2E4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2EF to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2EF to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2F0 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2F0 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2FD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2FD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2FE to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA2FE to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F4 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F5 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F5 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F6 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F6 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F7 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F7 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F8 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F8 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F9 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4F9 to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FA to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FA to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FB to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FB to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FC to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FC to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FD to 'utf8' +Warning 1977 Cannot convert 'gb2312' character 0xA4FD to 'utf8' DROP TABLE t1; # # End of 5.5 tests diff --git a/mysql-test/r/ctype_gbk.result b/mysql-test/r/ctype_gbk.result index e0c9d60c059..b5774548d85 100644 --- a/mysql-test/r/ctype_gbk.result +++ b/mysql-test/r/ctype_gbk.result @@ -489,7 +489,7 @@ select hex(convert(_gbk 0xA14041 using ucs2)); hex(convert(_gbk 0xA14041 using ucs2)) 003F0041 Warnings: -Warning 1976 Cannot convert 'gbk' character 0xA140 to 'ucs2' +Warning 1977 Cannot convert 'gbk' character 0xA140 to 'ucs2' create table t1 (c1 text not null, c2 text not null) character set gbk; alter table t1 change c1 c1 mediumtext character set gbk not null; show create table t1; @@ -797,70 +797,70 @@ code a A2FB Ⅺ A2FC Ⅻ Warnings: -Warning 1976 Cannot convert 'gbk' character 0xA140 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA140 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA141 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA141 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA142 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA142 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA143 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA143 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA144 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA144 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA145 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA145 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA146 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA146 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA147 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA147 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA148 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA148 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA149 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA149 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14A to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14A to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14B to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14B to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14C to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14C to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14D to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14D to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14E to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14E to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14F to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14F to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA150 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA150 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA151 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA151 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA152 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA152 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA153 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA153 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA154 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA154 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA155 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA155 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA156 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA156 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA157 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA157 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA158 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA158 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA159 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA159 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15A to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15A to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15B to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15B to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15C to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15C to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15D to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15D to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15E to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15E to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15F to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15F to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA140 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA140 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA141 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA141 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA142 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA142 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA143 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA143 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA144 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA144 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA145 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA145 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA146 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA146 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA147 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA147 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA148 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA148 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA149 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA149 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14A to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14A to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14B to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14B to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14C to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14C to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14D to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14D to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14E to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14E to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14F to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14F to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA150 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA150 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA151 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA151 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA152 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA152 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA153 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA153 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA154 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA154 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA155 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA155 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA156 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA156 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA157 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA157 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA158 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA158 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA159 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA159 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15A to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15A to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15B to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15B to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15C to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15C to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15D to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15D to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15E to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15E to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15F to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15F to 'utf8' SELECT * FROM t1 WHERE HEX(CAST(UPPER(a) AS CHAR CHARACTER SET utf8)) <> HEX(UPPER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; @@ -894,70 +894,70 @@ A8BA ê A8BD ń A8BE ň Warnings: -Warning 1976 Cannot convert 'gbk' character 0xA140 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA140 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA141 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA141 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA142 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA142 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA143 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA143 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA144 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA144 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA145 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA145 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA146 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA146 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA147 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA147 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA148 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA148 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA149 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA149 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14A to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14A to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14B to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14B to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14C to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14C to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14D to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14D to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14E to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14E to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14F to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA14F to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA150 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA150 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA151 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA151 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA152 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA152 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA153 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA153 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA154 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA154 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA155 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA155 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA156 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA156 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA157 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA157 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA158 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA158 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA159 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA159 to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15A to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15A to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15B to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15B to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15C to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15C to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15D to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15D to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15E to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15E to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15F to 'utf8' -Warning 1976 Cannot convert 'gbk' character 0xA15F to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA140 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA140 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA141 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA141 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA142 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA142 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA143 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA143 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA144 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA144 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA145 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA145 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA146 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA146 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA147 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA147 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA148 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA148 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA149 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA149 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14A to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14A to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14B to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14B to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14C to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14C to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14D to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14D to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14E to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14E to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14F to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA14F to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA150 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA150 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA151 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA151 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA152 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA152 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA153 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA153 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA154 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA154 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA155 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA155 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA156 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA156 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA157 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA157 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA158 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA158 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA159 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA159 to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15A to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15A to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15B to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15B to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15C to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15C to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15D to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15D to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15E to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15E to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15F to 'utf8' +Warning 1977 Cannot convert 'gbk' character 0xA15F to 'utf8' DROP TABLE t1; # # End of 5.5 tests diff --git a/mysql-test/r/ctype_sjis.result b/mysql-test/r/ctype_sjis.result index cde7493789a..46686933298 100644 --- a/mysql-test/r/ctype_sjis.result +++ b/mysql-test/r/ctype_sjis.result @@ -686,139 +686,139 @@ HEX(LOWER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; code a 81F0 Å Warnings: -Warning 1976 Cannot convert 'sjis' character 0x81AD to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AD to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AE to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AE to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AF to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AF to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81CF to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81CF to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D8 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D8 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D9 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D9 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81E9 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81E9 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81EA to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81EA to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AD to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AD to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AE to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AE to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AF to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AF to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81CF to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81CF to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D8 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D8 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D9 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D9 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81E9 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81E9 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81EA to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81EA to 'utf8' SELECT * FROM t1 WHERE HEX(CAST(UPPER(a) AS CHAR CHARACTER SET utf8)) <> HEX(UPPER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; code a Warnings: -Warning 1976 Cannot convert 'sjis' character 0x81AD to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AD to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AE to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AE to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AF to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AF to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81CF to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81CF to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D8 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D8 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D9 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D9 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81E9 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81E9 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81EA to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81EA to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AD to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AD to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AE to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AE to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AF to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AF to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81CF to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81CF to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D8 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D8 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D9 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D9 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81E9 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81E9 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81EA to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81EA to 'utf8' # # WL#3090 Japanese Character Set adjustments # Test sjis->Unicode conversion @@ -7769,70 +7769,70 @@ EAA2 E791A4 EAA3 E5879C EAA4 E78699 Warnings: -Warning 1976 Cannot convert 'sjis' character 0x81AD to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AE to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81AF to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81B7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81C7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81CF to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D0 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D1 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D2 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D3 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D4 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D5 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D6 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D7 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D8 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81D9 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81E9 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81EA to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81EB to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81EC to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81ED to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81EE to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81EF to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81F8 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81F9 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81FA to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x81FB to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x8240 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x8241 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x8242 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x8243 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x8244 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x8245 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x8246 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x8247 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x8248 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x8249 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x824A to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x824B to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x824C to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x824D to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x824E to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x8259 to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x825A to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x825B to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x825C to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x825D to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x825E to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x825F to 'utf8' -Warning 1976 Cannot convert 'sjis' character 0x827A to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AD to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AE to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81AF to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81B7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81C7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81CF to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D0 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D1 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D2 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D3 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D4 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D5 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D6 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D7 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D8 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81D9 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81E9 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81EA to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81EB to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81EC to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81ED to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81EE to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81EF to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81F8 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81F9 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81FA to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x81FB to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x8240 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x8241 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x8242 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x8243 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x8244 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x8245 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x8246 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x8247 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x8248 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x8249 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x824A to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x824B to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x824C to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x824D to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x824E to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x8259 to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x825A to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x825B to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x825C to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x825D to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x825E to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x825F to 'utf8' +Warning 1977 Cannot convert 'sjis' character 0x827A to 'utf8' DROP TABLE t1; # # WL#3090 Japanese Character Set adjustments diff --git a/mysql-test/r/ctype_ujis.result b/mysql-test/r/ctype_ujis.result index d70f0d59f12..4deabb7513f 100644 --- a/mysql-test/r/ctype_ujis.result +++ b/mysql-test/r/ctype_ujis.result @@ -2505,12 +2505,12 @@ select hex(convert(_ujis 0xA5FE41 using ucs2)); hex(convert(_ujis 0xA5FE41 using ucs2)) 003F0041 Warnings: -Warning 1976 Cannot convert 'ujis' character 0xA5FE to 'ucs2' +Warning 1977 Cannot convert 'ujis' character 0xA5FE to 'ucs2' select hex(convert(_ujis 0x8FABF841 using ucs2)); hex(convert(_ujis 0x8FABF841 using ucs2)) 003F0041 Warnings: -Warning 1976 Cannot convert 'ujis' character 0x8FABF8 to 'ucs2' +Warning 1977 Cannot convert 'ujis' character 0x8FABF8 to 'ucs2' DROP TABLE IF EXISTS t1, t2; DROP PROCEDURE IF EXISTS sp1; set names ujis; @@ -3081,70 +3081,70 @@ HEX(LOWER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; code a 8FAABC Ģ Warnings: -Warning 1976 Cannot convert 'ujis' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2DA to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2DA to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2DB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2DB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EC to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2DA to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2DA to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2DB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2DB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EC to 'utf8' SELECT * FROM t1 WHERE HEX(CAST(UPPER(a) AS CHAR CHARACTER SET utf8)) <> HEX(UPPER(CAST(a AS CHAR CHARACTER SET utf8))) ORDER BY code; @@ -3152,70 +3152,70 @@ code a 8FA9C3 ð 8FABB9 ǵ Warnings: -Warning 1976 Cannot convert 'ujis' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2DA to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2DA to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2DB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2DB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EC to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2DA to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2DA to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2DB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2DB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EC to 'utf8' # # WL#3090 Japanese Character Set adjustments # Test sjis->Unicode conversion @@ -18113,70 +18113,70 @@ FEFC EE8EA9 FEFD EE8EAA FEFE EE8EAB Warnings: -Warning 1976 Cannot convert 'ujis' character 0xA2AF to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B0 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2B9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2C9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2D9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2DA to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2DB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EC to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2ED to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EE to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2EF to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2F0 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2F1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2FA to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2FB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2FC to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA2FD to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3A1 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3A2 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3A3 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3A4 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3A5 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3A6 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3A7 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3A8 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3A9 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3AA to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3AB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3AC to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3AD to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3AE to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3AF to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3BA to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3BB to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3BC to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3BD to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3BE to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3BF to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3C0 to 'utf8' -Warning 1976 Cannot convert 'ujis' character 0xA3DB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2AF to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B0 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2B9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2C9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2D9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2DA to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2DB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EC to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2ED to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EE to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2EF to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2F0 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2F1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2FA to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2FB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2FC to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA2FD to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3A1 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3A2 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3A3 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3A4 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3A5 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3A6 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3A7 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3A8 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3A9 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3AA to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3AB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3AC to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3AD to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3AE to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3AF to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3BA to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3BB to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3BC to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3BD to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3BE to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3BF to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3C0 to 'utf8' +Warning 1977 Cannot convert 'ujis' character 0xA3DB to 'utf8' DROP TABLE t1; # # WL#3090 Japanese Character Set adjustments diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index b34415a7822..bb1e4d51dd6 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -566,7 +566,31 @@ insert into t1 (accountId,balance) values update t1 set balance=(select sum(balance) from (SELECT balance FROM t1 where accountId like 'dealer%') AS copied) where accountId = 'OPERATOR'; set optimizer_switch=@save_derived_optimizer_switch_bug; drop table t1; -set optimizer_switch=@save_derived_optimizer_switch; +# +# MDEV-6219:Server crashes in Bitmap<64u>::merge +# (this=0x180, map2=...) on 2nd execution of PS with INSERT .. SELECT, +# derived_merge +# +CREATE TABLE t1 (a VARCHAR(8)) ENGINE=MyISAM; +INSERT INTO t1 VALUES ('foo'),('bar'); +create procedure p1() +INSERT INTO t1 SELECT * FROM ( +SELECT * FROM t1 +) AS sq +WHERE sq.a IN ( SELECT 'baz' FROM DUAL ); +call p1(); +call p1(); +drop procedure p1; +PREPARE stmt FROM " + INSERT INTO t1 SELECT * FROM ( + SELECT * FROM t1 + ) AS sq + WHERE sq.a IN ( SELECT 'baz' FROM DUAL ) +"; +EXECUTE stmt; +EXECUTE stmt; +deallocate prepare stmt; +drop table t1; # # MDEV-6892: WHERE does not apply # @@ -579,3 +603,4 @@ select x.id, message from (select id from t1) x left join where coalesce(message,0) <> 0; id message drop table t1,t2; +set optimizer_switch=@save_derived_optimizer_switch; diff --git a/mysql-test/r/empty_server_name-8224.result b/mysql-test/r/empty_server_name-8224.result index 6423114470d..4bf592c8932 100644 --- a/mysql-test/r/empty_server_name-8224.result +++ b/mysql-test/r/empty_server_name-8224.result @@ -1 +1,2 @@ create server '' foreign data wrapper w2 options (host '127.0.0.1'); +drop server ''; diff --git a/mysql-test/r/func_gconcat.result b/mysql-test/r/func_gconcat.result index f12a0c1127a..0bc31a5e85b 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -1103,3 +1103,19 @@ ORDER BY field; field c,c drop table t3, t2, t1; +# +# MDEV-7821 - Server crashes in Item_func_group_concat::fix_fields on 2nd +# execution of PS +# +CREATE TABLE t1(a INT); +INSERT INTO t1 VALUES(1),(2); +PREPARE stmt FROM "SELECT GROUP_CONCAT(t1a.a ORDER BY 1, t1a.a=0) FROM t1 AS t1a, t1 AS t1b GROUP BY t1a.a"; +EXECUTE stmt; +GROUP_CONCAT(t1a.a ORDER BY 1, t1a.a=0) +1,1 +2,2 +EXECUTE stmt; +GROUP_CONCAT(t1a.a ORDER BY 1, t1a.a=0) +1,1 +2,2 +DROP TABLE t1; diff --git a/mysql-test/r/func_misc.result b/mysql-test/r/func_misc.result index ceec5df148b..62138819b0a 100644 --- a/mysql-test/r/func_misc.result +++ b/mysql-test/r/func_misc.result @@ -361,6 +361,19 @@ set optimizer_switch=@optimizer_switch_save; drop view v_merge, vm; drop table t1,tv; # +# MDEV-4017 - GET_LOCK() with negative timeouts has strange behavior +# +SELECT GET_LOCK('ul1', NULL); +GET_LOCK('ul1', NULL) +NULL +Warnings: +Warning 1411 Incorrect timeout value: 'NULL' for function get_lock +SELECT GET_LOCK('ul1', -1); +GET_LOCK('ul1', -1) +NULL +Warnings: +Warning 1411 Incorrect timeout value: '-1' for function get_lock +# # GET_LOCK, RELEASE_LOCK, IS_USED_LOCK functions test # # IS_USED_LOCK, IS_FREE_LOCK: the lock is not acquired diff --git a/mysql-test/r/grant.result b/mysql-test/r/grant.result index 6c769e60780..499251ec3fc 100644 --- a/mysql-test/r/grant.result +++ b/mysql-test/r/grant.result @@ -1695,6 +1695,7 @@ Assigning privileges without procs_priv table. CREATE DATABASE mysqltest1; CREATE PROCEDURE mysqltest1.test() SQL SECURITY DEFINER SELECT 1; +CREATE FUNCTION mysqltest1.test() RETURNS INT RETURN 1; GRANT EXECUTE ON FUNCTION mysqltest1.test TO mysqltest_1@localhost; ERROR 42S02: Table 'mysql.procs_priv' doesn't exist GRANT ALL PRIVILEGES ON test.* TO mysqltest_1@localhost; @@ -2557,3 +2558,25 @@ ERROR 42000: Access denied for user 'untrusted'@'localhost' to database 'secret' # Connection default DROP USER untrusted@localhost; DROP DATABASE secret; +# +# BUG#11759114 - '51401: GRANT TREATS NONEXISTENT FUNCTIONS/PRIVILEGES +# DIFFERENTLY'. +# +drop database if exists mysqltest_db1; +create database mysqltest_db1; +create user mysqltest_u1; +# Both GRANT statements below should fail with the same error. +grant execute on function mysqltest_db1.f1 to mysqltest_u1; +ERROR 42000: FUNCTION or PROCEDURE f1 does not exist +grant execute on procedure mysqltest_db1.p1 to mysqltest_u1; +ERROR 42000: FUNCTION or PROCEDURE p1 does not exist +# Let us show that GRANT behaviour for routines is consistent +# with GRANT behaviour for tables. Attempt to grant privilege +# on non-existent table also results in an error. +grant select on mysqltest_db1.t1 to mysqltest_u1; +ERROR 42S02: Table 'mysqltest_db1.t1' doesn't exist +show grants for mysqltest_u1; +Grants for mysqltest_u1@% +GRANT USAGE ON *.* TO 'mysqltest_u1'@'%' +drop database mysqltest_db1; +drop user mysqltest_u1; diff --git a/mysql-test/r/innodb_load_xa.result b/mysql-test/r/innodb_load_xa.result index bcf1dad6806..515c820b40c 100644 --- a/mysql-test/r/innodb_load_xa.result +++ b/mysql-test/r/innodb_load_xa.result @@ -14,3 +14,5 @@ Variable_name Value Handler_prepare 0 drop table t1; uninstall plugin innodb; +Warnings: +Warning 1620 Plugin is busy and will be uninstalled on shutdown diff --git a/mysql-test/r/max_statement_time.result b/mysql-test/r/max_statement_time.result index 30060e78aff..1ad2de7f7e3 100644 --- a/mysql-test/r/max_statement_time.result +++ b/mysql-test/r/max_statement_time.result @@ -114,7 +114,7 @@ UPDATE t1 SET a = 2; ERROR 70100: Query execution was interrupted (max_statement_time exceeded) SHOW WARNINGS; Level Code Message -Error 1968 Query execution was interrupted (max_statement_time exceeded) +Error 1969 Query execution was interrupted (max_statement_time exceeded) ROLLBACK; DROP TABLE t1; diff --git a/mysql-test/r/mdev-504.result b/mysql-test/r/mdev-504.result index e178127cf2a..4d93e77c6e8 100644 --- a/mysql-test/r/mdev-504.result +++ b/mysql-test/r/mdev-504.result @@ -1,3 +1,4 @@ +SET GLOBAL net_write_timeout = 900; CREATE TABLE A ( pk INTEGER AUTO_INCREMENT PRIMARY KEY, fdate DATE @@ -19,3 +20,4 @@ DROP TABLE A; DROP PROCEDURE p_analyze; DROP FUNCTION rnd3; SET GLOBAL use_stat_tables = DEFAULT; +SET GLOBAL net_write_timeout = DEFAULT; diff --git a/mysql-test/r/merge_recover.result b/mysql-test/r/myisam_recover.result index 871c12ca4c0..0829c1e8b82 100644 --- a/mysql-test/r/merge_recover.result +++ b/mysql-test/r/myisam_recover.result @@ -1,5 +1,7 @@ # -# Test of MyISAM MRG tables with corrupted children. +# Tests for corrupted MyISAM tables and MyISAMMRG tables with corrupted +# children.. +# # Run with --myisam-recover=force option. # # Preparation: we need to make sure that the merge parent @@ -44,20 +46,20 @@ drop procedure p_create; # Switching to connection 'default' # # -# We have to disable the ps-protocol, to avoid +# We have to disable the ps-protocol, to avoid # "Prepared statement needs to be re-prepared" errors # -- table def versions change all the time with full table cache. -# +# drop table if exists t1, t1_mrg, t1_copy; # # Prepare a MERGE engine table, that refers to a corrupted # child. -# +# create table t1 (a int, key(a)) engine=myisam; create table t1_mrg (a int) union (t1) engine=merge; # # Create a table with a corrupted index file: -# save an old index file, insert more rows, +# save an old index file, insert more rows, # overwrite the new index file with the old one. # insert into t1 (a) values (1), (2), (3); @@ -101,3 +103,48 @@ execute stmt; deallocate prepare stmt; set @@global.table_definition_cache=default; set @@global.table_open_cache=default; +# +# 18075170 - sql node restart required to avoid deadlock after +# restore +# +# Check that auto-repair for MyISAM tables can now happen in the +# middle of transaction, without aborting it. +create table t1 (a int, key(a)) engine=myisam; +create table t2 (a int); +insert into t2 values (1); +# Create a table with a corrupted index file: +# save an old index file, insert more rows, +# overwrite the new index file with the old one. +insert into t1 (a) values (1); +flush table t1; +insert into t1 (a) values (4); +flush table t1; +# Check table is needed to mark the table as crashed. +check table t1; +Table Op Msg_type Msg_text +test.t1 check warning Size of datafile is: 14 Should be: 7 +test.t1 check error Record-count is not ok; is 2 Should be: 1 +test.t1 check warning Found 2 key parts. Should be: 1 +test.t1 check error Corrupt +# At this point we have a corrupt t1 +set autocommit = 0; +select * from t2; +a +1 +# Without fix select from t1 will break the transaction. After the fix +# transaction should be active and should hold lock on table t2. Alter +# table from con2 will wait only if the transaction is not broken. +select * from t1; +a +1 +4 +Warnings: +Error 145 Table 't1' is marked as crashed and should be repaired +Error 1194 Table 't1' is marked as crashed and should be repaired +Error 1034 Number of rows changed from 1 to 2 +ALTER TABLE t2 ADD val INT; +# With fix we should have alter table waiting for t2 lock here. +ROLLBACK; +SET autocommit = 1; +# Cleanup +drop table t1, t2; diff --git a/mysql-test/r/mysqld--help.result b/mysql-test/r/mysqld--help.result index fc22af6b9be..65a0fad4a84 100644 --- a/mysql-test/r/mysqld--help.result +++ b/mysql-test/r/mysqld--help.result @@ -667,6 +667,9 @@ The following options may be given as the first argument: --performance-schema-max-cond-instances=# Maximum number of instrumented condition objects. Use 0 to disable, -1 for automated sizing. + --performance-schema-max-digest-length=# + Maximum length considered for digest text, when stored in + performance_schema tables. --performance-schema-max-file-classes=# Maximum number of file instruments. --performance-schema-max-file-handles=# @@ -1316,6 +1319,7 @@ performance-schema-hosts-size -1 performance-schema-instrument performance-schema-max-cond-classes 80 performance-schema-max-cond-instances -1 +performance-schema-max-digest-length 1024 performance-schema-max-file-classes 50 performance-schema-max-file-handles 32768 performance-schema-max-file-instances -1 diff --git a/mysql-test/r/plugin.result b/mysql-test/r/plugin.result index 74b312359a8..b92881ae7bc 100644 --- a/mysql-test/r/plugin.result +++ b/mysql-test/r/plugin.result @@ -5,7 +5,7 @@ Warning 1266 Using storage engine MyISAM for table 't1' DROP TABLE t1; INSTALL PLUGIN example SONAME 'ha_example'; INSTALL PLUGIN EXAMPLE SONAME 'ha_example'; -ERROR HY000: Function 'EXAMPLE' already exists +ERROR HY000: Plugin 'EXAMPLE' already installed UNINSTALL PLUGIN example; INSTALL SONAME 'ha_example'; select * from information_schema.plugins where plugin_library like 'ha_example%'; diff --git a/mysql-test/r/sp-group.result b/mysql-test/r/sp-group.result new file mode 100644 index 00000000000..2e30b697103 --- /dev/null +++ b/mysql-test/r/sp-group.result @@ -0,0 +1,156 @@ +drop table if exists t1; +Warnings: +Note 1051 Unknown table 'test.t1' +drop view if exists view_t1; +Warnings: +Note 1051 Unknown table 'test.view_t1' +SET sql_mode=ONLY_FULL_GROUP_BY; +CREATE TABLE t1 ( +pk INT, +f0 INT, f1 INT, f2 INT, f3 INT, f4 INT, +f5 INT, f6 INT, f7 INT, f8 INT, f9 INT, +PRIMARY KEY (pk) +); +CREATE VIEW view_t1 AS SELECT * FROM t1; +CREATE PROCEDURE s1() +SELECT * FROM ( +INFORMATION_SCHEMA.`INNODB_BUFFER_PAGE_LRU` AS table1 +LEFT JOIN test.view_t1 AS table2 +ON ( table2.`f6` = table1.FREE_PAGE_CLOCK) +) +ORDER BY table1.NUMBER_RECORDS +LIMIT 0 +; +CALL s1; +POOL_ID LRU_POSITION SPACE PAGE_NUMBER PAGE_TYPE FLUSH_TYPE FIX_COUNT IS_HASHED NEWEST_MODIFICATION OLDEST_MODIFICATION ACCESS_TIME TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE COMPRESSED_SIZE COMPRESSED IO_FIX IS_OLD FREE_PAGE_CLOCK pk f0 f1 f2 f3 f4 f5 f6 f7 f8 f9 +CALL s1; +POOL_ID LRU_POSITION SPACE PAGE_NUMBER PAGE_TYPE FLUSH_TYPE FIX_COUNT IS_HASHED NEWEST_MODIFICATION OLDEST_MODIFICATION ACCESS_TIME TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE COMPRESSED_SIZE COMPRESSED IO_FIX IS_OLD FREE_PAGE_CLOCK pk f0 f1 f2 f3 f4 f5 f6 f7 f8 f9 +drop table t1; +drop view view_t1; +drop procedure s1; +CREATE TABLE A ( +pk INTEGER AUTO_INCREMENT, +col_int_key INTEGER, +col_varchar_key VARCHAR(1), +PRIMARY KEY (pk) +) ENGINE=MyISAM; +CREATE VIEW view_A AS SELECT * FROM A; +CREATE TABLE C ( +pk INTEGER AUTO_INCREMENT, +col_int_nokey INTEGER, +col_int_key INTEGER, +col_date_key DATE, +col_date_nokey DATE, +col_time_key TIME, +col_time_nokey TIME, +col_datetime_key DATETIME, +col_datetime_nokey DATETIME, +col_varchar_key VARCHAR(1), +col_varchar_nokey VARCHAR(1), +PRIMARY KEY (pk) +) ENGINE=MyISAM; +CREATE VIEW view_C AS SELECT * FROM C; +CREATE TABLE AA ( +pk INTEGER AUTO_INCREMENT, +col_int_nokey INTEGER, +col_int_key INTEGER, +col_date_key DATE, +col_date_nokey DATE, +col_time_key TIME, +col_time_nokey TIME, +col_datetime_key DATETIME, +col_datetime_nokey DATETIME, +col_varchar_key VARCHAR(1), +col_varchar_nokey VARCHAR(1), +PRIMARY KEY (pk), +KEY (col_varchar_key, col_int_key) +) ENGINE=MyISAM; +CREATE VIEW view_AA AS SELECT * FROM AA; +CREATE TABLE BB ( +pk INTEGER AUTO_INCREMENT, +col_int_key INTEGER, +col_varchar_key VARCHAR(1), +col_varchar_nokey VARCHAR(1), +PRIMARY KEY (pk), +KEY (col_varchar_key, col_int_key) +) ENGINE=MyISAM; +CREATE VIEW view_BB AS SELECT * FROM BB; +CREATE TABLE DD ( +pk INTEGER AUTO_INCREMENT, +col_int_key INTEGER, +col_date_key DATE, +col_time_key TIME, +col_datetime_key DATETIME, +col_varchar_key VARCHAR(1), +PRIMARY KEY (pk), +KEY (col_varchar_key, col_int_key) +) ENGINE=MyISAM; +CREATE VIEW view_DD AS SELECT * FROM DD; +CREATE TRIGGER k BEFORE INSERT ON `DD` FOR EACH ROW INSERT INTO `view_BB` SELECT * FROM `view_A` LIMIT 0 ; +CREATE TRIGGER r BEFORE INSERT ON `A` FOR EACH ROW INSERT INTO `view_AA` SELECT * FROM `view_C` LIMIT 0 ; +ALTER TABLE `DD` DROP PRIMARY KEY; +ERROR 42000: Incorrect table definition; there can be only one auto column and it must be defined as a key +INSERT INTO `view_A` ( `pk` ) VALUES (NULL); +INSERT INTO `DD` ( `pk` ) VALUES (NULL); +INSERT INTO `A` ( `pk` ) VALUES (NULL); +INSERT INTO `view_DD` ( `pk` ) VALUES (NULL); +drop trigger r; +drop trigger k; +drop view view_A,view_AA,view_C,view_BB,view_DD; +drop table A,C,AA,BB,DD; +CREATE TABLE A ( +i INT, +i1 INT, +i2 INT, +d1 DATE, +d2 DATE, +col_time_nokey1 TIME, +col_time_nokey2 TIME, +col_datetime_nokey1 DATETIME, +col_datetime_nokey2 DATETIME, +col_varchar_nokey1 VARCHAR(1), +col_varchar_nokey2 VARCHAR(1) +) ENGINE=MyISAM; +CREATE VIEW view_A AS SELECT * FROM A; +CREATE TABLE B ( +col_varchar_nokey VARCHAR(1) +) ENGINE=MyISAM; +CREATE TABLE AA ( +i INT, +i1 INT, +i2 INT, +d1 DATE, +d2 DATE, +col_time_nokey1 TIME, +col_time_nokey2 TIME, +col_datetime_nokey1 DATETIME, +col_datetime_nokey2 DATETIME, +col_varchar_nokey1 VARCHAR(1), +col_varchar_nokey2 VARCHAR(1) +) ENGINE=MyISAM; +CREATE VIEW view_AA AS SELECT * FROM AA; +CREATE TABLE DD ( +i INT, +i1 INT, +i2 INT, +d1 DATE, +d2 DATE, +col_time_nokey1 TIME, +col_time_nokey2 TIME, +col_datetime_nokey1 DATETIME, +col_datetime_nokey2 DATETIME, +col_varchar_nokey1 VARCHAR(1), +col_varchar_nokey2 VARCHAR(1) +) ENGINE=MyISAM; +CREATE VIEW view_DD AS SELECT * FROM DD; +CREATE TRIGGER tr1 BEFORE INSERT ON `AA` FOR EACH ROW INSERT INTO `view_A` SELECT * FROM `view_AA` LIMIT 0 ; +CREATE TRIGGER tr2 BEFORE INSERT ON `B` FOR EACH ROW INSERT INTO `D` SELECT * FROM `A` LIMIT 0 ; +INSERT INTO `view_AA` ( `i` ) VALUES (1); +INSERT INTO `AA` ( `i` ) VALUES (2); +DELETE FROM `B`; +INSERT INTO `view_DD` ( `i` ) VALUES (1); +INSERT INTO `view_AA` ( `i` ) VALUES (3); +drop trigger tr1; +drop trigger tr2; +drop view view_A, view_AA,view_DD; +drop table A,B,AA,DD; diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index c8b7e8ebb00..27a21e190fd 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -7861,6 +7861,60 @@ v1 DROP PROCEDURE p1; DROP TABLE t1; # End of 5.5 test +# +# MDEV-7040: Crash in field_conv, memcpy_field_possible, part#2 +# +create table t1 ( +col1 bigint(20), +col2 char(1), +col3 char(2) +); +insert into t1 values (1,'a','a'), (2,'b','b'); +create table t2 as select * from t1; +create table t3 as select * from t1; +create table t4 as select * from t1; +create table t5 as select * from t1; +create table t6 as select * from t1; +flush tables; +CREATE PROCEDURE p1() +begin +DECLARE _var1 bigint(20) UNSIGNED; +DECLARE _var2 CHAR(1) DEFAULT NULL; +DECLARE _var3 CHAR(1) DEFAULT NULL; +DECLARE _done BOOLEAN DEFAULT 0; +declare cur1 cursor for +select col1, col2, col3 +from t1 +where +col1 in (select t2.col1 from t2 where t2.col2=t1.col2) or +col2 in (select t3.col3 from t3 where t3.col3=t1.col2) ; +DECLARE CONTINUE HANDLER FOR NOT FOUND SET _done = 1; +OPEN cur1; +set _var1 = (select _var1 from t4 limit 1); +set _var1 = (select _var1 from t5 limit 1); +set _var1 = (select _var1 from t6 limit 1); +label1: +LOOP +SET _done = 0; +FETCH cur1 INTO _var1, _var2, _var3; +IF _done THEN +LEAVE label1; +END IF; +END LOOP label1; +CLOSE cur1; +end| +set @tmp_toc= @@table_open_cache; +set @tmp_tdc= @@table_definition_cache; +set global table_open_cache=1; +set global table_definition_cache=1; +Warnings: +Warning 1292 Truncated incorrect table_definition_cache value: '1' +call p1(); +set global table_open_cache= @tmp_toc; +set global table_definition_cache= @tmp_tdc; +drop procedure p1; +drop table t1,t2,t3,t4,t5,t6; +# End of 10.0 test CREATE FUNCTION f(f1 VARCHAR(64) COLLATE latin1_german2_ci) RETURNS VARCHAR(64) BEGIN diff --git a/mysql-test/r/subselect_mat.result b/mysql-test/r/subselect_mat.result index 40c0c21ae40..b201ac6a44c 100644 --- a/mysql-test/r/subselect_mat.result +++ b/mysql-test/r/subselect_mat.result @@ -2145,6 +2145,24 @@ drop database mysqltest1; drop database mysqltest2; drop database mysqltest3; drop database mysqltest4; +# +# MDEV-7810 Wrong result on execution of a query as a PS +# (both 1st and further executions) +CREATE TABLE t1 (a INT NOT NULL) ENGINE=MyISAM; +INSERT INTO t1 VALUES (0),(8); +SELECT a FROM (SELECT DISTINCT * FROM t1) AS sq WHERE a IN (SELECT MIN(t2.a) FROM (t1 AS t2)); +a +0 +PREPARE stmt FROM " +SELECT a FROM (SELECT DISTINCT * FROM t1) AS sq WHERE a IN (SELECT MIN(t2.a) FROM (t1 AS t2)) +"; +execute stmt; +a +0 +execute stmt; +a +0 +drop table t1; # End of 5.5 tests # # MDEV-7220: Materialization strategy is not used for REPLACE ... SELECT @@ -2197,6 +2215,24 @@ Handler_read_rnd_next 6003 Handler_tmp_write 2000 Handler_write 1000 drop table t0,t1,t2,t3; +# +# MDEV-7971: Assertion `name != __null' failed in ACL_internal_schema_registry::lookup +# on 2nd execution os PS with multi-table update +# +CREATE TABLE t1 (f1 INT); +INSERT INTO t1 VALUES (1),(2); +CREATE TABLE t2 (f2 INT); +INSERT INTO t2 VALUES (3),(4); +CREATE TABLE t3 (f3 INT); +INSERT INTO t3 VALUES (5),(6); +PREPARE stmt FROM ' + UPDATE t1, t2 + SET f1 = 5 + WHERE 8 IN ( SELECT MIN(f3) FROM t3 ) +'; +EXECUTE stmt; +EXECUTE stmt; +DROP TABLE t1,t2,t3; set @subselect_mat_test_optimizer_switch_value=null; set @@optimizer_switch='materialization=on,in_to_exists=off,semijoin=off'; set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on'; diff --git a/mysql-test/r/subselect_sj2.result b/mysql-test/r/subselect_sj2.result index 1cef7f5a46f..21d97b3faea 100644 --- a/mysql-test/r/subselect_sj2.result +++ b/mysql-test/r/subselect_sj2.result @@ -1283,5 +1283,38 @@ id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY T2_0_ ref FK_T2_T1Id FK_T2_T1Id 8 test.T2_1_.t1idref 1 Using index; End temporary drop table t3,t2,t1; set optimizer_search_depth=@tmp7474; +# +# +# +CREATE TABLE t1 ( +id int(16) NOT NULL AUTO_INCREMENT, +PRIMARY KEY (id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +CREATE TABLE t2 ( +id int(16) NOT NULL AUTO_INCREMENT, +t3_id int(16) NOT NULL DEFAULT '0', +t1_id int(16) NOT NULL DEFAULT '0', +PRIMARY KEY (id), +KEY t3_idx (t3_id), +KEY t1_idx (t1_id) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +CREATE TABLE t3 ( +id int(16) NOT NULL AUTO_INCREMENT, +PRIMARY KEY (id) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +INSERT INTO t3 VALUES (1); +INSERT INTO t2 VALUES (1, 1, 1); +INSERT INTO t2 VALUES (2, 1, 2); +INSERT INTO t2 VALUES (3, 1, 2); +INSERT INTO t2 VALUES (4, 1, 1); +INSERT INTO t1 VALUES (1); +INSERT INTO t1 VALUES (2); +SELECT * FROM t1 WHERE t1.id IN ( +SELECT t2.t1_id FROM t3 JOIN t2 ON t3.id = t2.t3_id WHERE t3.id = 1 +); +id +1 +2 +drop table t1,t2,t3; # This must be the last in the file: set optimizer_switch=@subselect_sj2_tmp; diff --git a/mysql-test/r/subselect_sj2_jcl6.result b/mysql-test/r/subselect_sj2_jcl6.result index b7c9fc8f28c..eb91fe6d61b 100644 --- a/mysql-test/r/subselect_sj2_jcl6.result +++ b/mysql-test/r/subselect_sj2_jcl6.result @@ -1298,6 +1298,39 @@ id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY T2_0_ ref FK_T2_T1Id FK_T2_T1Id 8 test.T2_1_.t1idref 1 Using index; End temporary drop table t3,t2,t1; set optimizer_search_depth=@tmp7474; +# +# +# +CREATE TABLE t1 ( +id int(16) NOT NULL AUTO_INCREMENT, +PRIMARY KEY (id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +CREATE TABLE t2 ( +id int(16) NOT NULL AUTO_INCREMENT, +t3_id int(16) NOT NULL DEFAULT '0', +t1_id int(16) NOT NULL DEFAULT '0', +PRIMARY KEY (id), +KEY t3_idx (t3_id), +KEY t1_idx (t1_id) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +CREATE TABLE t3 ( +id int(16) NOT NULL AUTO_INCREMENT, +PRIMARY KEY (id) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +INSERT INTO t3 VALUES (1); +INSERT INTO t2 VALUES (1, 1, 1); +INSERT INTO t2 VALUES (2, 1, 2); +INSERT INTO t2 VALUES (3, 1, 2); +INSERT INTO t2 VALUES (4, 1, 1); +INSERT INTO t1 VALUES (1); +INSERT INTO t1 VALUES (2); +SELECT * FROM t1 WHERE t1.id IN ( +SELECT t2.t1_id FROM t3 JOIN t2 ON t3.id = t2.t3_id WHERE t3.id = 1 +); +id +1 +2 +drop table t1,t2,t3; # This must be the last in the file: set optimizer_switch=@subselect_sj2_tmp; # diff --git a/mysql-test/r/subselect_sj2_mat.result b/mysql-test/r/subselect_sj2_mat.result index 0edfe08213e..16e8f88168d 100644 --- a/mysql-test/r/subselect_sj2_mat.result +++ b/mysql-test/r/subselect_sj2_mat.result @@ -1285,6 +1285,39 @@ id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY T2_0_ ref FK_T2_T1Id FK_T2_T1Id 8 test.T2_1_.t1idref 1 Using index; End temporary drop table t3,t2,t1; set optimizer_search_depth=@tmp7474; +# +# +# +CREATE TABLE t1 ( +id int(16) NOT NULL AUTO_INCREMENT, +PRIMARY KEY (id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +CREATE TABLE t2 ( +id int(16) NOT NULL AUTO_INCREMENT, +t3_id int(16) NOT NULL DEFAULT '0', +t1_id int(16) NOT NULL DEFAULT '0', +PRIMARY KEY (id), +KEY t3_idx (t3_id), +KEY t1_idx (t1_id) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +CREATE TABLE t3 ( +id int(16) NOT NULL AUTO_INCREMENT, +PRIMARY KEY (id) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +INSERT INTO t3 VALUES (1); +INSERT INTO t2 VALUES (1, 1, 1); +INSERT INTO t2 VALUES (2, 1, 2); +INSERT INTO t2 VALUES (3, 1, 2); +INSERT INTO t2 VALUES (4, 1, 1); +INSERT INTO t1 VALUES (1); +INSERT INTO t1 VALUES (2); +SELECT * FROM t1 WHERE t1.id IN ( +SELECT t2.t1_id FROM t3 JOIN t2 ON t3.id = t2.t3_id WHERE t3.id = 1 +); +id +1 +2 +drop table t1,t2,t3; # This must be the last in the file: set optimizer_switch=@subselect_sj2_tmp; set optimizer_switch=default; diff --git a/mysql-test/r/subselect_sj_mat.result b/mysql-test/r/subselect_sj_mat.result index d5150f047d7..2dce6569d67 100644 --- a/mysql-test/r/subselect_sj_mat.result +++ b/mysql-test/r/subselect_sj_mat.result @@ -2185,6 +2185,24 @@ drop database mysqltest1; drop database mysqltest2; drop database mysqltest3; drop database mysqltest4; +# +# MDEV-7810 Wrong result on execution of a query as a PS +# (both 1st and further executions) +CREATE TABLE t1 (a INT NOT NULL) ENGINE=MyISAM; +INSERT INTO t1 VALUES (0),(8); +SELECT a FROM (SELECT DISTINCT * FROM t1) AS sq WHERE a IN (SELECT MIN(t2.a) FROM (t1 AS t2)); +a +0 +PREPARE stmt FROM " +SELECT a FROM (SELECT DISTINCT * FROM t1) AS sq WHERE a IN (SELECT MIN(t2.a) FROM (t1 AS t2)) +"; +execute stmt; +a +0 +execute stmt; +a +0 +drop table t1; # End of 5.5 tests # # MDEV-7220: Materialization strategy is not used for REPLACE ... SELECT @@ -2237,3 +2255,21 @@ Handler_read_rnd_next 6003 Handler_tmp_write 2000 Handler_write 1000 drop table t0,t1,t2,t3; +# +# MDEV-7971: Assertion `name != __null' failed in ACL_internal_schema_registry::lookup +# on 2nd execution os PS with multi-table update +# +CREATE TABLE t1 (f1 INT); +INSERT INTO t1 VALUES (1),(2); +CREATE TABLE t2 (f2 INT); +INSERT INTO t2 VALUES (3),(4); +CREATE TABLE t3 (f3 INT); +INSERT INTO t3 VALUES (5),(6); +PREPARE stmt FROM ' + UPDATE t1, t2 + SET f1 = 5 + WHERE 8 IN ( SELECT MIN(f3) FROM t3 ) +'; +EXECUTE stmt; +EXECUTE stmt; +DROP TABLE t1,t2,t3; diff --git a/mysql-test/r/type_binary.result b/mysql-test/r/type_binary.result index b00d1585b29..9d44d718a02 100644 --- a/mysql-test/r/type_binary.result +++ b/mysql-test/r/type_binary.result @@ -146,3 +146,37 @@ hex(f2) hex(f3) 0000 drop table t1; End of 5.0 tests +# +# Start of 10.0 tests +# +# +# MDEV-8472 BINARY, VARBINARY and BLOB return different warnings on CAST to DECIMAL +# +SET NAMES utf8; +CREATE TABLE t1 (a BINARY(30)); +INSERT INTO t1 VALUES ('1äÖüß@µ*$'); +SELECT CAST(a AS DECIMAL) FROM t1; +CAST(a AS DECIMAL) +1 +Warnings: +Warning 1292 Truncated incorrect DECIMAL value: '1\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00' +DROP TABLE t1; +CREATE TABLE t1 (a VARBINARY(30)); +INSERT INTO t1 VALUES ('1äÖüß@µ*$'); +SELECT CAST(a AS DECIMAL) FROM t1; +CAST(a AS DECIMAL) +1 +Warnings: +Warning 1292 Truncated incorrect DECIMAL value: '1\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$' +DROP TABLE t1; +CREATE TABLE t1 (a BLOB); +INSERT INTO t1 VALUES ('1äÖüß@µ*$'); +SELECT CAST(a AS DECIMAL) FROM t1; +CAST(a AS DECIMAL) +1 +Warnings: +Warning 1292 Truncated incorrect DECIMAL value: '1\xC3\xA4\xC3\x96\xC3\xBC\xC3\x9F@\xC2\xB5*$' +DROP TABLE t1; +# +# End of 10.0 tests +# diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index d8b71fb119c..4a39eb9d57a 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -5428,6 +5428,21 @@ View Create View character_set_client collation_connection v2 CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select (`t1`.`b` + 1) AS `c` from `t1` latin1 latin1_swedish_ci drop view v2; drop table t1; +# +# MDEV-8554: Server crashes in base_list_iterator::next_fast on 1st execution of PS with a multi-table update +# +CREATE TABLE t1 (a INT) ENGINE=MyISAM; +INSERT INTO t1 VALUES (1),(2); +CREATE TABLE t2 (b INT) ENGINE=MyISAM; +INSERT INTO t2 VALUES (3),(4); +CREATE TABLE t3 (c INT) ENGINE=MyISAM; +INSERT INTO t3 VALUES (5),(6); +CREATE OR REPLACE ALGORITHM=MERGE VIEW v3 AS SELECT * FROM t3; +PREPARE stmt FROM 'UPDATE t1, t2 SET a = 1 WHERE a IN ( SELECT 0 FROM t3 )'; +UPDATE t1, t2 SET a = 1 WHERE a IN ( SELECT 0 FROM v3 ); +EXECUTE stmt; +DROP TABLE t1, t2, t3; +DROP VIEW v3; # ----------------------------------------------------------------- # -- End of 5.5 tests. # ----------------------------------------------------------------- |