revision-id: b0d21b7832cea92522d0f8d280ceb8b13b335cbf (mariadb-10.2.18-56-gb0d21b7) parent(s): 1c6b982e02eeaa75bb6c2f2a3c2b64491dd6d3c8 committer: Alexey Botchkov timestamp: 2018-11-04 09:14:40 +0400 message: MDEV-14567 Include full name of object in message about incorrect value for column. Put the full field name in the ER_TRUNCATED_WRONG_VALUE_FOR_FIELD error message. --- mysql-test/r/create.result | 6 +- mysql-test/r/ctype_big5.result | 128 ++++---- mysql-test/r/ctype_cp932_binlog_stm.result | 128 ++++---- mysql-test/r/ctype_eucjpms.result | 128 ++++---- mysql-test/r/ctype_euckr.result | 140 ++++----- mysql-test/r/ctype_gb2312.result | 128 ++++---- mysql-test/r/ctype_gbk.result | 454 ++++++++++++++--------------- mysql-test/r/ctype_latin1.result | 8 +- mysql-test/r/ctype_many.result | 4 +- mysql-test/r/ctype_recoding.result | 4 +- sql/field.cc | 32 +- 11 files changed, 593 insertions(+), 567 deletions(-) diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index 2159127..aa75d94 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -1225,7 +1225,7 @@ INSERT INTO t3 VALUES (0); SET sql_mode = TRADITIONAL; ALTER TABLE t3 ADD INDEX(c1); -ERROR 22007: Incorrect datetime value: '0000-00-00 00:00:00' for column 'c1' at row 1 +ERROR 22007: Incorrect datetime value: '0000-00-00 00:00:00' for column 'test.#sql-691c_15d.c1' at row 1 # -- Cleanup. SET sql_mode = ''; @@ -1783,12 +1783,12 @@ NULL 0000-00-00 0000-00-00 drop table t1; set @@session.sql_mode='STRICT_ALL_TABLES'; create table if not exists t1 (a int, b date, c date) select 1 as b, 2 as c; -ERROR 22007: Incorrect date value: '1' for column 'b' at row 1 +ERROR 22007: Incorrect date value: '1' for column 'test.t1.b' at row 1 select * from t1; ERROR 42S02: Table 'test.t1' doesn't exist create table if not exists t1 (a int, b date, c date) replace select 1 as b, 2 as c; -ERROR 22007: Incorrect date value: '1' for column 'b' at row 1 +ERROR 22007: Incorrect date value: '1' for column 'test.t1.b' at row 1 select * from t1; ERROR 42S02: Table 'test.t1' doesn't exist create table if not exists t1 (a int, b date, c date) diff --git a/mysql-test/r/ctype_big5.result b/mysql-test/r/ctype_big5.result index 2db4da5..1503953 100644 --- a/mysql-test/r/ctype_big5.result +++ b/mysql-test/r/ctype_big5.result @@ -565,70 +565,70 @@ COUNT(*) 28672 UPDATE IGNORE t1 SET a=unhex(code) ORDER BY code; Warnings: -Warning 1366 Incorrect string value: '\x80 ' for column 'a' at row 1 -Warning 1366 Incorrect string value: '\x80!' for column 'a' at row 2 -Warning 1366 Incorrect string value: '\x80"' for column 'a' at row 3 -Warning 1366 Incorrect string value: '\x80#' for column 'a' at row 4 -Warning 1366 Incorrect string value: '\x80$' for column 'a' at row 5 -Warning 1366 Incorrect string value: '\x80%' for column 'a' at row 6 -Warning 1366 Incorrect string value: '\x80&' for column 'a' at row 7 -Warning 1366 Incorrect string value: '\x80'' for column 'a' at row 8 -Warning 1366 Incorrect string value: '\x80(' for column 'a' at row 9 -Warning 1366 Incorrect string value: '\x80)' for column 'a' at row 10 -Warning 1366 Incorrect string value: '\x80*' for column 'a' at row 11 -Warning 1366 Incorrect string value: '\x80+' for column 'a' at row 12 -Warning 1366 Incorrect string value: '\x80,' for column 'a' at row 13 -Warning 1366 Incorrect string value: '\x80-' for column 'a' at row 14 -Warning 1366 Incorrect string value: '\x80.' for column 'a' at row 15 -Warning 1366 Incorrect string value: '\x80/' for column 'a' at row 16 -Warning 1366 Incorrect string value: '\x800' for column 'a' at row 17 -Warning 1366 Incorrect string value: '\x801' for column 'a' at row 18 -Warning 1366 Incorrect string value: '\x802' for column 'a' at row 19 -Warning 1366 Incorrect string value: '\x803' for column 'a' at row 20 -Warning 1366 Incorrect string value: '\x804' for column 'a' at row 21 -Warning 1366 Incorrect string value: '\x805' for column 'a' at row 22 -Warning 1366 Incorrect string value: '\x806' for column 'a' at row 23 -Warning 1366 Incorrect string value: '\x807' for column 'a' at row 24 -Warning 1366 Incorrect string value: '\x808' for column 'a' at row 25 -Warning 1366 Incorrect string value: '\x809' for column 'a' at row 26 -Warning 1366 Incorrect string value: '\x80:' for column 'a' at row 27 -Warning 1366 Incorrect string value: '\x80;' for column 'a' at row 28 -Warning 1366 Incorrect string value: '\x80<' for column 'a' at row 29 -Warning 1366 Incorrect string value: '\x80=' for column 'a' at row 30 -Warning 1366 Incorrect string value: '\x80>' for column 'a' at row 31 -Warning 1366 Incorrect string value: '\x80?' for column 'a' at row 32 -Warning 1366 Incorrect string value: '\x80@' for column 'a' at row 33 -Warning 1366 Incorrect string value: '\x80A' for column 'a' at row 34 -Warning 1366 Incorrect string value: '\x80B' for column 'a' at row 35 -Warning 1366 Incorrect string value: '\x80C' for column 'a' at row 36 -Warning 1366 Incorrect string value: '\x80D' for column 'a' at row 37 -Warning 1366 Incorrect string value: '\x80E' for column 'a' at row 38 -Warning 1366 Incorrect string value: '\x80F' for column 'a' at row 39 -Warning 1366 Incorrect string value: '\x80G' for column 'a' at row 40 -Warning 1366 Incorrect string value: '\x80H' for column 'a' at row 41 -Warning 1366 Incorrect string value: '\x80I' for column 'a' at row 42 -Warning 1366 Incorrect string value: '\x80J' for column 'a' at row 43 -Warning 1366 Incorrect string value: '\x80K' for column 'a' at row 44 -Warning 1366 Incorrect string value: '\x80L' for column 'a' at row 45 -Warning 1366 Incorrect string value: '\x80M' for column 'a' at row 46 -Warning 1366 Incorrect string value: '\x80N' for column 'a' at row 47 -Warning 1366 Incorrect string value: '\x80O' for column 'a' at row 48 -Warning 1366 Incorrect string value: '\x80P' for column 'a' at row 49 -Warning 1366 Incorrect string value: '\x80Q' for column 'a' at row 50 -Warning 1366 Incorrect string value: '\x80R' for column 'a' at row 51 -Warning 1366 Incorrect string value: '\x80S' for column 'a' at row 52 -Warning 1366 Incorrect string value: '\x80T' for column 'a' at row 53 -Warning 1366 Incorrect string value: '\x80U' for column 'a' at row 54 -Warning 1366 Incorrect string value: '\x80V' for column 'a' at row 55 -Warning 1366 Incorrect string value: '\x80W' for column 'a' at row 56 -Warning 1366 Incorrect string value: '\x80X' for column 'a' at row 57 -Warning 1366 Incorrect string value: '\x80Y' for column 'a' at row 58 -Warning 1366 Incorrect string value: '\x80Z' for column 'a' at row 59 -Warning 1366 Incorrect string value: '\x80[' for column 'a' at row 60 -Warning 1366 Incorrect string value: '\x80\' for column 'a' at row 61 -Warning 1366 Incorrect string value: '\x80]' for column 'a' at row 62 -Warning 1366 Incorrect string value: '\x80^' for column 'a' at row 63 -Warning 1366 Incorrect string value: '\x80_' for column 'a' at row 64 +Warning 1366 Incorrect string value: '\x80 ' for column 'test.t1.a' at row 1 +Warning 1366 Incorrect string value: '\x80!' for column 'test.t1.a' at row 2 +Warning 1366 Incorrect string value: '\x80"' for column 'test.t1.a' at row 3 +Warning 1366 Incorrect string value: '\x80#' for column 'test.t1.a' at row 4 +Warning 1366 Incorrect string value: '\x80$' for column 'test.t1.a' at row 5 +Warning 1366 Incorrect string value: '\x80%' for column 'test.t1.a' at row 6 +Warning 1366 Incorrect string value: '\x80&' for column 'test.t1.a' at row 7 +Warning 1366 Incorrect string value: '\x80'' for column 'test.t1.a' at row 8 +Warning 1366 Incorrect string value: '\x80(' for column 'test.t1.a' at row 9 +Warning 1366 Incorrect string value: '\x80)' for column 'test.t1.a' at row 10 +Warning 1366 Incorrect string value: '\x80*' for column 'test.t1.a' at row 11 +Warning 1366 Incorrect string value: '\x80+' for column 'test.t1.a' at row 12 +Warning 1366 Incorrect string value: '\x80,' for column 'test.t1.a' at row 13 +Warning 1366 Incorrect string value: '\x80-' for column 'test.t1.a' at row 14 +Warning 1366 Incorrect string value: '\x80.' for column 'test.t1.a' at row 15 +Warning 1366 Incorrect string value: '\x80/' for column 'test.t1.a' at row 16 +Warning 1366 Incorrect string value: '\x800' for column 'test.t1.a' at row 17 +Warning 1366 Incorrect string value: '\x801' for column 'test.t1.a' at row 18 +Warning 1366 Incorrect string value: '\x802' for column 'test.t1.a' at row 19 +Warning 1366 Incorrect string value: '\x803' for column 'test.t1.a' at row 20 +Warning 1366 Incorrect string value: '\x804' for column 'test.t1.a' at row 21 +Warning 1366 Incorrect string value: '\x805' for column 'test.t1.a' at row 22 +Warning 1366 Incorrect string value: '\x806' for column 'test.t1.a' at row 23 +Warning 1366 Incorrect string value: '\x807' for column 'test.t1.a' at row 24 +Warning 1366 Incorrect string value: '\x808' for column 'test.t1.a' at row 25 +Warning 1366 Incorrect string value: '\x809' for column 'test.t1.a' at row 26 +Warning 1366 Incorrect string value: '\x80:' for column 'test.t1.a' at row 27 +Warning 1366 Incorrect string value: '\x80;' for column 'test.t1.a' at row 28 +Warning 1366 Incorrect string value: '\x80<' for column 'test.t1.a' at row 29 +Warning 1366 Incorrect string value: '\x80=' for column 'test.t1.a' at row 30 +Warning 1366 Incorrect string value: '\x80>' for column 'test.t1.a' at row 31 +Warning 1366 Incorrect string value: '\x80?' for column 'test.t1.a' at row 32 +Warning 1366 Incorrect string value: '\x80@' for column 'test.t1.a' at row 33 +Warning 1366 Incorrect string value: '\x80A' for column 'test.t1.a' at row 34 +Warning 1366 Incorrect string value: '\x80B' for column 'test.t1.a' at row 35 +Warning 1366 Incorrect string value: '\x80C' for column 'test.t1.a' at row 36 +Warning 1366 Incorrect string value: '\x80D' for column 'test.t1.a' at row 37 +Warning 1366 Incorrect string value: '\x80E' for column 'test.t1.a' at row 38 +Warning 1366 Incorrect string value: '\x80F' for column 'test.t1.a' at row 39 +Warning 1366 Incorrect string value: '\x80G' for column 'test.t1.a' at row 40 +Warning 1366 Incorrect string value: '\x80H' for column 'test.t1.a' at row 41 +Warning 1366 Incorrect string value: '\x80I' for column 'test.t1.a' at row 42 +Warning 1366 Incorrect string value: '\x80J' for column 'test.t1.a' at row 43 +Warning 1366 Incorrect string value: '\x80K' for column 'test.t1.a' at row 44 +Warning 1366 Incorrect string value: '\x80L' for column 'test.t1.a' at row 45 +Warning 1366 Incorrect string value: '\x80M' for column 'test.t1.a' at row 46 +Warning 1366 Incorrect string value: '\x80N' for column 'test.t1.a' at row 47 +Warning 1366 Incorrect string value: '\x80O' for column 'test.t1.a' at row 48 +Warning 1366 Incorrect string value: '\x80P' for column 'test.t1.a' at row 49 +Warning 1366 Incorrect string value: '\x80Q' for column 'test.t1.a' at row 50 +Warning 1366 Incorrect string value: '\x80R' for column 'test.t1.a' at row 51 +Warning 1366 Incorrect string value: '\x80S' for column 'test.t1.a' at row 52 +Warning 1366 Incorrect string value: '\x80T' for column 'test.t1.a' at row 53 +Warning 1366 Incorrect string value: '\x80U' for column 'test.t1.a' at row 54 +Warning 1366 Incorrect string value: '\x80V' for column 'test.t1.a' at row 55 +Warning 1366 Incorrect string value: '\x80W' for column 'test.t1.a' at row 56 +Warning 1366 Incorrect string value: '\x80X' for column 'test.t1.a' at row 57 +Warning 1366 Incorrect string value: '\x80Y' for column 'test.t1.a' at row 58 +Warning 1366 Incorrect string value: '\x80Z' for column 'test.t1.a' at row 59 +Warning 1366 Incorrect string value: '\x80[' for column 'test.t1.a' at row 60 +Warning 1366 Incorrect string value: '\x80\' for column 'test.t1.a' at row 61 +Warning 1366 Incorrect string value: '\x80]' for column 'test.t1.a' at row 62 +Warning 1366 Incorrect string value: '\x80^' for column 'test.t1.a' at row 63 +Warning 1366 Incorrect string value: '\x80_' for column 'test.t1.a' at row 64 SELECT COUNT(*) FROM t1 WHERE a<>'?'; COUNT(*) 13973 diff --git a/mysql-test/r/ctype_cp932_binlog_stm.result b/mysql-test/r/ctype_cp932_binlog_stm.result index f49400b..ecb106e 100644 --- a/mysql-test/r/ctype_cp932_binlog_stm.result +++ b/mysql-test/r/ctype_cp932_binlog_stm.result @@ -98,70 +98,70 @@ t1 CREATE TABLE `t1` ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 UPDATE IGNORE t1 SET a=unhex(code) ORDER BY code; Warnings: -Warning 1366 Incorrect string value: '\x80 ' for column 'a' at row 1 -Warning 1366 Incorrect string value: '\x80!' for column 'a' at row 2 -Warning 1366 Incorrect string value: '\x80"' for column 'a' at row 3 -Warning 1366 Incorrect string value: '\x80#' for column 'a' at row 4 -Warning 1366 Incorrect string value: '\x80$' for column 'a' at row 5 -Warning 1366 Incorrect string value: '\x80%' for column 'a' at row 6 -Warning 1366 Incorrect string value: '\x80&' for column 'a' at row 7 -Warning 1366 Incorrect string value: '\x80'' for column 'a' at row 8 -Warning 1366 Incorrect string value: '\x80(' for column 'a' at row 9 -Warning 1366 Incorrect string value: '\x80)' for column 'a' at row 10 -Warning 1366 Incorrect string value: '\x80*' for column 'a' at row 11 -Warning 1366 Incorrect string value: '\x80+' for column 'a' at row 12 -Warning 1366 Incorrect string value: '\x80,' for column 'a' at row 13 -Warning 1366 Incorrect string value: '\x80-' for column 'a' at row 14 -Warning 1366 Incorrect string value: '\x80.' for column 'a' at row 15 -Warning 1366 Incorrect string value: '\x80/' for column 'a' at row 16 -Warning 1366 Incorrect string value: '\x800' for column 'a' at row 17 -Warning 1366 Incorrect string value: '\x801' for column 'a' at row 18 -Warning 1366 Incorrect string value: '\x802' for column 'a' at row 19 -Warning 1366 Incorrect string value: '\x803' for column 'a' at row 20 -Warning 1366 Incorrect string value: '\x804' for column 'a' at row 21 -Warning 1366 Incorrect string value: '\x805' for column 'a' at row 22 -Warning 1366 Incorrect string value: '\x806' for column 'a' at row 23 -Warning 1366 Incorrect string value: '\x807' for column 'a' at row 24 -Warning 1366 Incorrect string value: '\x808' for column 'a' at row 25 -Warning 1366 Incorrect string value: '\x809' for column 'a' at row 26 -Warning 1366 Incorrect string value: '\x80:' for column 'a' at row 27 -Warning 1366 Incorrect string value: '\x80;' for column 'a' at row 28 -Warning 1366 Incorrect string value: '\x80<' for column 'a' at row 29 -Warning 1366 Incorrect string value: '\x80=' for column 'a' at row 30 -Warning 1366 Incorrect string value: '\x80>' for column 'a' at row 31 -Warning 1366 Incorrect string value: '\x80?' for column 'a' at row 32 -Warning 1366 Incorrect string value: '\x80@' for column 'a' at row 33 -Warning 1366 Incorrect string value: '\x80A' for column 'a' at row 34 -Warning 1366 Incorrect string value: '\x80B' for column 'a' at row 35 -Warning 1366 Incorrect string value: '\x80C' for column 'a' at row 36 -Warning 1366 Incorrect string value: '\x80D' for column 'a' at row 37 -Warning 1366 Incorrect string value: '\x80E' for column 'a' at row 38 -Warning 1366 Incorrect string value: '\x80F' for column 'a' at row 39 -Warning 1366 Incorrect string value: '\x80G' for column 'a' at row 40 -Warning 1366 Incorrect string value: '\x80H' for column 'a' at row 41 -Warning 1366 Incorrect string value: '\x80I' for column 'a' at row 42 -Warning 1366 Incorrect string value: '\x80J' for column 'a' at row 43 -Warning 1366 Incorrect string value: '\x80K' for column 'a' at row 44 -Warning 1366 Incorrect string value: '\x80L' for column 'a' at row 45 -Warning 1366 Incorrect string value: '\x80M' for column 'a' at row 46 -Warning 1366 Incorrect string value: '\x80N' for column 'a' at row 47 -Warning 1366 Incorrect string value: '\x80O' for column 'a' at row 48 -Warning 1366 Incorrect string value: '\x80P' for column 'a' at row 49 -Warning 1366 Incorrect string value: '\x80Q' for column 'a' at row 50 -Warning 1366 Incorrect string value: '\x80R' for column 'a' at row 51 -Warning 1366 Incorrect string value: '\x80S' for column 'a' at row 52 -Warning 1366 Incorrect string value: '\x80T' for column 'a' at row 53 -Warning 1366 Incorrect string value: '\x80U' for column 'a' at row 54 -Warning 1366 Incorrect string value: '\x80V' for column 'a' at row 55 -Warning 1366 Incorrect string value: '\x80W' for column 'a' at row 56 -Warning 1366 Incorrect string value: '\x80X' for column 'a' at row 57 -Warning 1366 Incorrect string value: '\x80Y' for column 'a' at row 58 -Warning 1366 Incorrect string value: '\x80Z' for column 'a' at row 59 -Warning 1366 Incorrect string value: '\x80[' for column 'a' at row 60 -Warning 1366 Incorrect string value: '\x80\' for column 'a' at row 61 -Warning 1366 Incorrect string value: '\x80]' for column 'a' at row 62 -Warning 1366 Incorrect string value: '\x80^' for column 'a' at row 63 -Warning 1366 Incorrect string value: '\x80_' for column 'a' at row 64 +Warning 1366 Incorrect string value: '\x80 ' for column 'test.t1.a' at row 1 +Warning 1366 Incorrect string value: '\x80!' for column 'test.t1.a' at row 2 +Warning 1366 Incorrect string value: '\x80"' for column 'test.t1.a' at row 3 +Warning 1366 Incorrect string value: '\x80#' for column 'test.t1.a' at row 4 +Warning 1366 Incorrect string value: '\x80$' for column 'test.t1.a' at row 5 +Warning 1366 Incorrect string value: '\x80%' for column 'test.t1.a' at row 6 +Warning 1366 Incorrect string value: '\x80&' for column 'test.t1.a' at row 7 +Warning 1366 Incorrect string value: '\x80'' for column 'test.t1.a' at row 8 +Warning 1366 Incorrect string value: '\x80(' for column 'test.t1.a' at row 9 +Warning 1366 Incorrect string value: '\x80)' for column 'test.t1.a' at row 10 +Warning 1366 Incorrect string value: '\x80*' for column 'test.t1.a' at row 11 +Warning 1366 Incorrect string value: '\x80+' for column 'test.t1.a' at row 12 +Warning 1366 Incorrect string value: '\x80,' for column 'test.t1.a' at row 13 +Warning 1366 Incorrect string value: '\x80-' for column 'test.t1.a' at row 14 +Warning 1366 Incorrect string value: '\x80.' for column 'test.t1.a' at row 15 +Warning 1366 Incorrect string value: '\x80/' for column 'test.t1.a' at row 16 +Warning 1366 Incorrect string value: '\x800' for column 'test.t1.a' at row 17 +Warning 1366 Incorrect string value: '\x801' for column 'test.t1.a' at row 18 +Warning 1366 Incorrect string value: '\x802' for column 'test.t1.a' at row 19 +Warning 1366 Incorrect string value: '\x803' for column 'test.t1.a' at row 20 +Warning 1366 Incorrect string value: '\x804' for column 'test.t1.a' at row 21 +Warning 1366 Incorrect string value: '\x805' for column 'test.t1.a' at row 22 +Warning 1366 Incorrect string value: '\x806' for column 'test.t1.a' at row 23 +Warning 1366 Incorrect string value: '\x807' for column 'test.t1.a' at row 24 +Warning 1366 Incorrect string value: '\x808' for column 'test.t1.a' at row 25 +Warning 1366 Incorrect string value: '\x809' for column 'test.t1.a' at row 26 +Warning 1366 Incorrect string value: '\x80:' for column 'test.t1.a' at row 27 +Warning 1366 Incorrect string value: '\x80;' for column 'test.t1.a' at row 28 +Warning 1366 Incorrect string value: '\x80<' for column 'test.t1.a' at row 29 +Warning 1366 Incorrect string value: '\x80=' for column 'test.t1.a' at row 30 +Warning 1366 Incorrect string value: '\x80>' for column 'test.t1.a' at row 31 +Warning 1366 Incorrect string value: '\x80?' for column 'test.t1.a' at row 32 +Warning 1366 Incorrect string value: '\x80@' for column 'test.t1.a' at row 33 +Warning 1366 Incorrect string value: '\x80A' for column 'test.t1.a' at row 34 +Warning 1366 Incorrect string value: '\x80B' for column 'test.t1.a' at row 35 +Warning 1366 Incorrect string value: '\x80C' for column 'test.t1.a' at row 36 +Warning 1366 Incorrect string value: '\x80D' for column 'test.t1.a' at row 37 +Warning 1366 Incorrect string value: '\x80E' for column 'test.t1.a' at row 38 +Warning 1366 Incorrect string value: '\x80F' for column 'test.t1.a' at row 39 +Warning 1366 Incorrect string value: '\x80G' for column 'test.t1.a' at row 40 +Warning 1366 Incorrect string value: '\x80H' for column 'test.t1.a' at row 41 +Warning 1366 Incorrect string value: '\x80I' for column 'test.t1.a' at row 42 +Warning 1366 Incorrect string value: '\x80J' for column 'test.t1.a' at row 43 +Warning 1366 Incorrect string value: '\x80K' for column 'test.t1.a' at row 44 +Warning 1366 Incorrect string value: '\x80L' for column 'test.t1.a' at row 45 +Warning 1366 Incorrect string value: '\x80M' for column 'test.t1.a' at row 46 +Warning 1366 Incorrect string value: '\x80N' for column 'test.t1.a' at row 47 +Warning 1366 Incorrect string value: '\x80O' for column 'test.t1.a' at row 48 +Warning 1366 Incorrect string value: '\x80P' for column 'test.t1.a' at row 49 +Warning 1366 Incorrect string value: '\x80Q' for column 'test.t1.a' at row 50 +Warning 1366 Incorrect string value: '\x80R' for column 'test.t1.a' at row 51 +Warning 1366 Incorrect string value: '\x80S' for column 'test.t1.a' at row 52 +Warning 1366 Incorrect string value: '\x80T' for column 'test.t1.a' at row 53 +Warning 1366 Incorrect string value: '\x80U' for column 'test.t1.a' at row 54 +Warning 1366 Incorrect string value: '\x80V' for column 'test.t1.a' at row 55 +Warning 1366 Incorrect string value: '\x80W' for column 'test.t1.a' at row 56 +Warning 1366 Incorrect string value: '\x80X' for column 'test.t1.a' at row 57 +Warning 1366 Incorrect string value: '\x80Y' for column 'test.t1.a' at row 58 +Warning 1366 Incorrect string value: '\x80Z' for column 'test.t1.a' at row 59 +Warning 1366 Incorrect string value: '\x80[' for column 'test.t1.a' at row 60 +Warning 1366 Incorrect string value: '\x80\' for column 'test.t1.a' at row 61 +Warning 1366 Incorrect string value: '\x80]' for column 'test.t1.a' at row 62 +Warning 1366 Incorrect string value: '\x80^' for column 'test.t1.a' at row 63 +Warning 1366 Incorrect string value: '\x80_' for column 'test.t1.a' at row 64 SELECT COUNT(*) FROM t1; COUNT(*) 14623 diff --git a/mysql-test/r/ctype_eucjpms.result b/mysql-test/r/ctype_eucjpms.result index 507d002..52dee73 100644 --- a/mysql-test/r/ctype_eucjpms.result +++ b/mysql-test/r/ctype_eucjpms.result @@ -10042,70 +10042,70 @@ t1 CREATE TABLE `t1` ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 UPDATE IGNORE t1 SET a=unhex(code) ORDER BY code; Warnings: -Warning 1366 Incorrect string value: '\x80 ' for column 'a' at row 1 -Warning 1366 Incorrect string value: '\x80!' for column 'a' at row 2 -Warning 1366 Incorrect string value: '\x80"' for column 'a' at row 3 -Warning 1366 Incorrect string value: '\x80#' for column 'a' at row 4 -Warning 1366 Incorrect string value: '\x80$' for column 'a' at row 5 -Warning 1366 Incorrect string value: '\x80%' for column 'a' at row 6 -Warning 1366 Incorrect string value: '\x80&' for column 'a' at row 7 -Warning 1366 Incorrect string value: '\x80'' for column 'a' at row 8 -Warning 1366 Incorrect string value: '\x80(' for column 'a' at row 9 -Warning 1366 Incorrect string value: '\x80)' for column 'a' at row 10 -Warning 1366 Incorrect string value: '\x80*' for column 'a' at row 11 -Warning 1366 Incorrect string value: '\x80+' for column 'a' at row 12 -Warning 1366 Incorrect string value: '\x80,' for column 'a' at row 13 -Warning 1366 Incorrect string value: '\x80-' for column 'a' at row 14 -Warning 1366 Incorrect string value: '\x80.' for column 'a' at row 15 -Warning 1366 Incorrect string value: '\x80/' for column 'a' at row 16 -Warning 1366 Incorrect string value: '\x800' for column 'a' at row 17 -Warning 1366 Incorrect string value: '\x801' for column 'a' at row 18 -Warning 1366 Incorrect string value: '\x802' for column 'a' at row 19 -Warning 1366 Incorrect string value: '\x803' for column 'a' at row 20 -Warning 1366 Incorrect string value: '\x804' for column 'a' at row 21 -Warning 1366 Incorrect string value: '\x805' for column 'a' at row 22 -Warning 1366 Incorrect string value: '\x806' for column 'a' at row 23 -Warning 1366 Incorrect string value: '\x807' for column 'a' at row 24 -Warning 1366 Incorrect string value: '\x808' for column 'a' at row 25 -Warning 1366 Incorrect string value: '\x809' for column 'a' at row 26 -Warning 1366 Incorrect string value: '\x80:' for column 'a' at row 27 -Warning 1366 Incorrect string value: '\x80;' for column 'a' at row 28 -Warning 1366 Incorrect string value: '\x80<' for column 'a' at row 29 -Warning 1366 Incorrect string value: '\x80=' for column 'a' at row 30 -Warning 1366 Incorrect string value: '\x80>' for column 'a' at row 31 -Warning 1366 Incorrect string value: '\x80?' for column 'a' at row 32 -Warning 1366 Incorrect string value: '\x80@' for column 'a' at row 33 -Warning 1366 Incorrect string value: '\x80A' for column 'a' at row 34 -Warning 1366 Incorrect string value: '\x80B' for column 'a' at row 35 -Warning 1366 Incorrect string value: '\x80C' for column 'a' at row 36 -Warning 1366 Incorrect string value: '\x80D' for column 'a' at row 37 -Warning 1366 Incorrect string value: '\x80E' for column 'a' at row 38 -Warning 1366 Incorrect string value: '\x80F' for column 'a' at row 39 -Warning 1366 Incorrect string value: '\x80G' for column 'a' at row 40 -Warning 1366 Incorrect string value: '\x80H' for column 'a' at row 41 -Warning 1366 Incorrect string value: '\x80I' for column 'a' at row 42 -Warning 1366 Incorrect string value: '\x80J' for column 'a' at row 43 -Warning 1366 Incorrect string value: '\x80K' for column 'a' at row 44 -Warning 1366 Incorrect string value: '\x80L' for column 'a' at row 45 -Warning 1366 Incorrect string value: '\x80M' for column 'a' at row 46 -Warning 1366 Incorrect string value: '\x80N' for column 'a' at row 47 -Warning 1366 Incorrect string value: '\x80O' for column 'a' at row 48 -Warning 1366 Incorrect string value: '\x80P' for column 'a' at row 49 -Warning 1366 Incorrect string value: '\x80Q' for column 'a' at row 50 -Warning 1366 Incorrect string value: '\x80R' for column 'a' at row 51 -Warning 1366 Incorrect string value: '\x80S' for column 'a' at row 52 -Warning 1366 Incorrect string value: '\x80T' for column 'a' at row 53 -Warning 1366 Incorrect string value: '\x80U' for column 'a' at row 54 -Warning 1366 Incorrect string value: '\x80V' for column 'a' at row 55 -Warning 1366 Incorrect string value: '\x80W' for column 'a' at row 56 -Warning 1366 Incorrect string value: '\x80X' for column 'a' at row 57 -Warning 1366 Incorrect string value: '\x80Y' for column 'a' at row 58 -Warning 1366 Incorrect string value: '\x80Z' for column 'a' at row 59 -Warning 1366 Incorrect string value: '\x80[' for column 'a' at row 60 -Warning 1366 Incorrect string value: '\x80\' for column 'a' at row 61 -Warning 1366 Incorrect string value: '\x80]' for column 'a' at row 62 -Warning 1366 Incorrect string value: '\x80^' for column 'a' at row 63 -Warning 1366 Incorrect string value: '\x80_' for column 'a' at row 64 +Warning 1366 Incorrect string value: '\x80 ' for column 'test.t1.a' at row 1 +Warning 1366 Incorrect string value: '\x80!' for column 'test.t1.a' at row 2 +Warning 1366 Incorrect string value: '\x80"' for column 'test.t1.a' at row 3 +Warning 1366 Incorrect string value: '\x80#' for column 'test.t1.a' at row 4 +Warning 1366 Incorrect string value: '\x80$' for column 'test.t1.a' at row 5 +Warning 1366 Incorrect string value: '\x80%' for column 'test.t1.a' at row 6 +Warning 1366 Incorrect string value: '\x80&' for column 'test.t1.a' at row 7 +Warning 1366 Incorrect string value: '\x80'' for column 'test.t1.a' at row 8 +Warning 1366 Incorrect string value: '\x80(' for column 'test.t1.a' at row 9 +Warning 1366 Incorrect string value: '\x80)' for column 'test.t1.a' at row 10 +Warning 1366 Incorrect string value: '\x80*' for column 'test.t1.a' at row 11 +Warning 1366 Incorrect string value: '\x80+' for column 'test.t1.a' at row 12 +Warning 1366 Incorrect string value: '\x80,' for column 'test.t1.a' at row 13 +Warning 1366 Incorrect string value: '\x80-' for column 'test.t1.a' at row 14 +Warning 1366 Incorrect string value: '\x80.' for column 'test.t1.a' at row 15 +Warning 1366 Incorrect string value: '\x80/' for column 'test.t1.a' at row 16 +Warning 1366 Incorrect string value: '\x800' for column 'test.t1.a' at row 17 +Warning 1366 Incorrect string value: '\x801' for column 'test.t1.a' at row 18 +Warning 1366 Incorrect string value: '\x802' for column 'test.t1.a' at row 19 +Warning 1366 Incorrect string value: '\x803' for column 'test.t1.a' at row 20 +Warning 1366 Incorrect string value: '\x804' for column 'test.t1.a' at row 21 +Warning 1366 Incorrect string value: '\x805' for column 'test.t1.a' at row 22 +Warning 1366 Incorrect string value: '\x806' for column 'test.t1.a' at row 23 +Warning 1366 Incorrect string value: '\x807' for column 'test.t1.a' at row 24 +Warning 1366 Incorrect string value: '\x808' for column 'test.t1.a' at row 25 +Warning 1366 Incorrect string value: '\x809' for column 'test.t1.a' at row 26 +Warning 1366 Incorrect string value: '\x80:' for column 'test.t1.a' at row 27 +Warning 1366 Incorrect string value: '\x80;' for column 'test.t1.a' at row 28 +Warning 1366 Incorrect string value: '\x80<' for column 'test.t1.a' at row 29 +Warning 1366 Incorrect string value: '\x80=' for column 'test.t1.a' at row 30 +Warning 1366 Incorrect string value: '\x80>' for column 'test.t1.a' at row 31 +Warning 1366 Incorrect string value: '\x80?' for column 'test.t1.a' at row 32 +Warning 1366 Incorrect string value: '\x80@' for column 'test.t1.a' at row 33 +Warning 1366 Incorrect string value: '\x80A' for column 'test.t1.a' at row 34 +Warning 1366 Incorrect string value: '\x80B' for column 'test.t1.a' at row 35 +Warning 1366 Incorrect string value: '\x80C' for column 'test.t1.a' at row 36 +Warning 1366 Incorrect string value: '\x80D' for column 'test.t1.a' at row 37 +Warning 1366 Incorrect string value: '\x80E' for column 'test.t1.a' at row 38 +Warning 1366 Incorrect string value: '\x80F' for column 'test.t1.a' at row 39 +Warning 1366 Incorrect string value: '\x80G' for column 'test.t1.a' at row 40 +Warning 1366 Incorrect string value: '\x80H' for column 'test.t1.a' at row 41 +Warning 1366 Incorrect string value: '\x80I' for column 'test.t1.a' at row 42 +Warning 1366 Incorrect string value: '\x80J' for column 'test.t1.a' at row 43 +Warning 1366 Incorrect string value: '\x80K' for column 'test.t1.a' at row 44 +Warning 1366 Incorrect string value: '\x80L' for column 'test.t1.a' at row 45 +Warning 1366 Incorrect string value: '\x80M' for column 'test.t1.a' at row 46 +Warning 1366 Incorrect string value: '\x80N' for column 'test.t1.a' at row 47 +Warning 1366 Incorrect string value: '\x80O' for column 'test.t1.a' at row 48 +Warning 1366 Incorrect string value: '\x80P' for column 'test.t1.a' at row 49 +Warning 1366 Incorrect string value: '\x80Q' for column 'test.t1.a' at row 50 +Warning 1366 Incorrect string value: '\x80R' for column 'test.t1.a' at row 51 +Warning 1366 Incorrect string value: '\x80S' for column 'test.t1.a' at row 52 +Warning 1366 Incorrect string value: '\x80T' for column 'test.t1.a' at row 53 +Warning 1366 Incorrect string value: '\x80U' for column 'test.t1.a' at row 54 +Warning 1366 Incorrect string value: '\x80V' for column 'test.t1.a' at row 55 +Warning 1366 Incorrect string value: '\x80W' for column 'test.t1.a' at row 56 +Warning 1366 Incorrect string value: '\x80X' for column 'test.t1.a' at row 57 +Warning 1366 Incorrect string value: '\x80Y' for column 'test.t1.a' at row 58 +Warning 1366 Incorrect string value: '\x80Z' for column 'test.t1.a' at row 59 +Warning 1366 Incorrect string value: '\x80[' for column 'test.t1.a' at row 60 +Warning 1366 Incorrect string value: '\x80\' for column 'test.t1.a' at row 61 +Warning 1366 Incorrect string value: '\x80]' for column 'test.t1.a' at row 62 +Warning 1366 Incorrect string value: '\x80^' for column 'test.t1.a' at row 63 +Warning 1366 Incorrect string value: '\x80_' for column 'test.t1.a' at row 64 SELECT COUNT(*) FROM t1; COUNT(*) 56959 diff --git a/mysql-test/r/ctype_euckr.result b/mysql-test/r/ctype_euckr.result index cc50ddd..31eda4c 100644 --- a/mysql-test/r/ctype_euckr.result +++ b/mysql-test/r/ctype_euckr.result @@ -389,22 +389,22 @@ insert into t1 values (0xA181); insert into t1 values (0xA1FE); insert ignore into t1 values (0xA140); Warnings: -Warning 1366 Incorrect string value: '\xA1@' for column 's1' at row 1 +Warning 1366 Incorrect string value: '\xA1@' for column 'test.t1.s1' at row 1 insert ignore into t1 values (0xA15B); Warnings: -Warning 1366 Incorrect string value: '\xA1[' for column 's1' at row 1 +Warning 1366 Incorrect string value: '\xA1[' for column 'test.t1.s1' at row 1 insert ignore into t1 values (0xA160); Warnings: -Warning 1366 Incorrect string value: '\xA1`' for column 's1' at row 1 +Warning 1366 Incorrect string value: '\xA1`' for column 'test.t1.s1' at row 1 insert ignore into t1 values (0xA17B); Warnings: -Warning 1366 Incorrect string value: '\xA1{' for column 's1' at row 1 +Warning 1366 Incorrect string value: '\xA1{' for column 'test.t1.s1' at row 1 insert ignore into t1 values (0xA180); Warnings: -Warning 1366 Incorrect string value: '\xA1\x80' for column 's1' at row 1 +Warning 1366 Incorrect string value: '\xA1\x80' for column 'test.t1.s1' at row 1 insert ignore into t1 values (0xA1FF); Warnings: -Warning 1366 Incorrect string value: '\xA1\xFF' for column 's1' at row 1 +Warning 1366 Incorrect string value: '\xA1\xFF' for column 'test.t1.s1' at row 1 select hex(s1), hex(convert(s1 using utf8)) from t1 order by binary s1; hex(s1) hex(convert(s1 using utf8)) 3F3F 3F3F @@ -24428,70 +24428,70 @@ t1 CREATE TABLE `t1` ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 UPDATE IGNORE t1 SET a=unhex(code) ORDER BY code; Warnings: -Warning 1366 Incorrect string value: '\x80 ' for column 'a' at row 1 -Warning 1366 Incorrect string value: '\x80!' for column 'a' at row 2 -Warning 1366 Incorrect string value: '\x80"' for column 'a' at row 3 -Warning 1366 Incorrect string value: '\x80#' for column 'a' at row 4 -Warning 1366 Incorrect string value: '\x80$' for column 'a' at row 5 -Warning 1366 Incorrect string value: '\x80%' for column 'a' at row 6 -Warning 1366 Incorrect string value: '\x80&' for column 'a' at row 7 -Warning 1366 Incorrect string value: '\x80'' for column 'a' at row 8 -Warning 1366 Incorrect string value: '\x80(' for column 'a' at row 9 -Warning 1366 Incorrect string value: '\x80)' for column 'a' at row 10 -Warning 1366 Incorrect string value: '\x80*' for column 'a' at row 11 -Warning 1366 Incorrect string value: '\x80+' for column 'a' at row 12 -Warning 1366 Incorrect string value: '\x80,' for column 'a' at row 13 -Warning 1366 Incorrect string value: '\x80-' for column 'a' at row 14 -Warning 1366 Incorrect string value: '\x80.' for column 'a' at row 15 -Warning 1366 Incorrect string value: '\x80/' for column 'a' at row 16 -Warning 1366 Incorrect string value: '\x800' for column 'a' at row 17 -Warning 1366 Incorrect string value: '\x801' for column 'a' at row 18 -Warning 1366 Incorrect string value: '\x802' for column 'a' at row 19 -Warning 1366 Incorrect string value: '\x803' for column 'a' at row 20 -Warning 1366 Incorrect string value: '\x804' for column 'a' at row 21 -Warning 1366 Incorrect string value: '\x805' for column 'a' at row 22 -Warning 1366 Incorrect string value: '\x806' for column 'a' at row 23 -Warning 1366 Incorrect string value: '\x807' for column 'a' at row 24 -Warning 1366 Incorrect string value: '\x808' for column 'a' at row 25 -Warning 1366 Incorrect string value: '\x809' for column 'a' at row 26 -Warning 1366 Incorrect string value: '\x80:' for column 'a' at row 27 -Warning 1366 Incorrect string value: '\x80;' for column 'a' at row 28 -Warning 1366 Incorrect string value: '\x80<' for column 'a' at row 29 -Warning 1366 Incorrect string value: '\x80=' for column 'a' at row 30 -Warning 1366 Incorrect string value: '\x80>' for column 'a' at row 31 -Warning 1366 Incorrect string value: '\x80?' for column 'a' at row 32 -Warning 1366 Incorrect string value: '\x80@' for column 'a' at row 33 -Warning 1366 Incorrect string value: '\x80A' for column 'a' at row 34 -Warning 1366 Incorrect string value: '\x80B' for column 'a' at row 35 -Warning 1366 Incorrect string value: '\x80C' for column 'a' at row 36 -Warning 1366 Incorrect string value: '\x80D' for column 'a' at row 37 -Warning 1366 Incorrect string value: '\x80E' for column 'a' at row 38 -Warning 1366 Incorrect string value: '\x80F' for column 'a' at row 39 -Warning 1366 Incorrect string value: '\x80G' for column 'a' at row 40 -Warning 1366 Incorrect string value: '\x80H' for column 'a' at row 41 -Warning 1366 Incorrect string value: '\x80I' for column 'a' at row 42 -Warning 1366 Incorrect string value: '\x80J' for column 'a' at row 43 -Warning 1366 Incorrect string value: '\x80K' for column 'a' at row 44 -Warning 1366 Incorrect string value: '\x80L' for column 'a' at row 45 -Warning 1366 Incorrect string value: '\x80M' for column 'a' at row 46 -Warning 1366 Incorrect string value: '\x80N' for column 'a' at row 47 -Warning 1366 Incorrect string value: '\x80O' for column 'a' at row 48 -Warning 1366 Incorrect string value: '\x80P' for column 'a' at row 49 -Warning 1366 Incorrect string value: '\x80Q' for column 'a' at row 50 -Warning 1366 Incorrect string value: '\x80R' for column 'a' at row 51 -Warning 1366 Incorrect string value: '\x80S' for column 'a' at row 52 -Warning 1366 Incorrect string value: '\x80T' for column 'a' at row 53 -Warning 1366 Incorrect string value: '\x80U' for column 'a' at row 54 -Warning 1366 Incorrect string value: '\x80V' for column 'a' at row 55 -Warning 1366 Incorrect string value: '\x80W' for column 'a' at row 56 -Warning 1366 Incorrect string value: '\x80X' for column 'a' at row 57 -Warning 1366 Incorrect string value: '\x80Y' for column 'a' at row 58 -Warning 1366 Incorrect string value: '\x80Z' for column 'a' at row 59 -Warning 1366 Incorrect string value: '\x80[' for column 'a' at row 60 -Warning 1366 Incorrect string value: '\x80\' for column 'a' at row 61 -Warning 1366 Incorrect string value: '\x80]' for column 'a' at row 62 -Warning 1366 Incorrect string value: '\x80^' for column 'a' at row 63 -Warning 1366 Incorrect string value: '\x80_' for column 'a' at row 64 +Warning 1366 Incorrect string value: '\x80 ' for column 'test.t1.a' at row 1 +Warning 1366 Incorrect string value: '\x80!' for column 'test.t1.a' at row 2 +Warning 1366 Incorrect string value: '\x80"' for column 'test.t1.a' at row 3 +Warning 1366 Incorrect string value: '\x80#' for column 'test.t1.a' at row 4 +Warning 1366 Incorrect string value: '\x80$' for column 'test.t1.a' at row 5 +Warning 1366 Incorrect string value: '\x80%' for column 'test.t1.a' at row 6 +Warning 1366 Incorrect string value: '\x80&' for column 'test.t1.a' at row 7 +Warning 1366 Incorrect string value: '\x80'' for column 'test.t1.a' at row 8 +Warning 1366 Incorrect string value: '\x80(' for column 'test.t1.a' at row 9 +Warning 1366 Incorrect string value: '\x80)' for column 'test.t1.a' at row 10 +Warning 1366 Incorrect string value: '\x80*' for column 'test.t1.a' at row 11 +Warning 1366 Incorrect string value: '\x80+' for column 'test.t1.a' at row 12 +Warning 1366 Incorrect string value: '\x80,' for column 'test.t1.a' at row 13 +Warning 1366 Incorrect string value: '\x80-' for column 'test.t1.a' at row 14 +Warning 1366 Incorrect string value: '\x80.' for column 'test.t1.a' at row 15 +Warning 1366 Incorrect string value: '\x80/' for column 'test.t1.a' at row 16 +Warning 1366 Incorrect string value: '\x800' for column 'test.t1.a' at row 17 +Warning 1366 Incorrect string value: '\x801' for column 'test.t1.a' at row 18 +Warning 1366 Incorrect string value: '\x802' for column 'test.t1.a' at row 19 +Warning 1366 Incorrect string value: '\x803' for column 'test.t1.a' at row 20 +Warning 1366 Incorrect string value: '\x804' for column 'test.t1.a' at row 21 +Warning 1366 Incorrect string value: '\x805' for column 'test.t1.a' at row 22 +Warning 1366 Incorrect string value: '\x806' for column 'test.t1.a' at row 23 +Warning 1366 Incorrect string value: '\x807' for column 'test.t1.a' at row 24 +Warning 1366 Incorrect string value: '\x808' for column 'test.t1.a' at row 25 +Warning 1366 Incorrect string value: '\x809' for column 'test.t1.a' at row 26 +Warning 1366 Incorrect string value: '\x80:' for column 'test.t1.a' at row 27 +Warning 1366 Incorrect string value: '\x80;' for column 'test.t1.a' at row 28 +Warning 1366 Incorrect string value: '\x80<' for column 'test.t1.a' at row 29 +Warning 1366 Incorrect string value: '\x80=' for column 'test.t1.a' at row 30 +Warning 1366 Incorrect string value: '\x80>' for column 'test.t1.a' at row 31 +Warning 1366 Incorrect string value: '\x80?' for column 'test.t1.a' at row 32 +Warning 1366 Incorrect string value: '\x80@' for column 'test.t1.a' at row 33 +Warning 1366 Incorrect string value: '\x80A' for column 'test.t1.a' at row 34 +Warning 1366 Incorrect string value: '\x80B' for column 'test.t1.a' at row 35 +Warning 1366 Incorrect string value: '\x80C' for column 'test.t1.a' at row 36 +Warning 1366 Incorrect string value: '\x80D' for column 'test.t1.a' at row 37 +Warning 1366 Incorrect string value: '\x80E' for column 'test.t1.a' at row 38 +Warning 1366 Incorrect string value: '\x80F' for column 'test.t1.a' at row 39 +Warning 1366 Incorrect string value: '\x80G' for column 'test.t1.a' at row 40 +Warning 1366 Incorrect string value: '\x80H' for column 'test.t1.a' at row 41 +Warning 1366 Incorrect string value: '\x80I' for column 'test.t1.a' at row 42 +Warning 1366 Incorrect string value: '\x80J' for column 'test.t1.a' at row 43 +Warning 1366 Incorrect string value: '\x80K' for column 'test.t1.a' at row 44 +Warning 1366 Incorrect string value: '\x80L' for column 'test.t1.a' at row 45 +Warning 1366 Incorrect string value: '\x80M' for column 'test.t1.a' at row 46 +Warning 1366 Incorrect string value: '\x80N' for column 'test.t1.a' at row 47 +Warning 1366 Incorrect string value: '\x80O' for column 'test.t1.a' at row 48 +Warning 1366 Incorrect string value: '\x80P' for column 'test.t1.a' at row 49 +Warning 1366 Incorrect string value: '\x80Q' for column 'test.t1.a' at row 50 +Warning 1366 Incorrect string value: '\x80R' for column 'test.t1.a' at row 51 +Warning 1366 Incorrect string value: '\x80S' for column 'test.t1.a' at row 52 +Warning 1366 Incorrect string value: '\x80T' for column 'test.t1.a' at row 53 +Warning 1366 Incorrect string value: '\x80U' for column 'test.t1.a' at row 54 +Warning 1366 Incorrect string value: '\x80V' for column 'test.t1.a' at row 55 +Warning 1366 Incorrect string value: '\x80W' for column 'test.t1.a' at row 56 +Warning 1366 Incorrect string value: '\x80X' for column 'test.t1.a' at row 57 +Warning 1366 Incorrect string value: '\x80Y' for column 'test.t1.a' at row 58 +Warning 1366 Incorrect string value: '\x80Z' for column 'test.t1.a' at row 59 +Warning 1366 Incorrect string value: '\x80[' for column 'test.t1.a' at row 60 +Warning 1366 Incorrect string value: '\x80\' for column 'test.t1.a' at row 61 +Warning 1366 Incorrect string value: '\x80]' for column 'test.t1.a' at row 62 +Warning 1366 Incorrect string value: '\x80^' for column 'test.t1.a' at row 63 +Warning 1366 Incorrect string value: '\x80_' for column 'test.t1.a' at row 64 SELECT COUNT(*) FROM t1 WHERE a<>'?'; COUNT(*) 22428 diff --git a/mysql-test/r/ctype_gb2312.result b/mysql-test/r/ctype_gb2312.result index c3c2eee..ccfdd33 100644 --- a/mysql-test/r/ctype_gb2312.result +++ b/mysql-test/r/ctype_gb2312.result @@ -489,70 +489,70 @@ t1 CREATE TABLE `t1` ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 UPDATE IGNORE t1 SET a=unhex(code) ORDER BY code; Warnings: -Warning 1366 Incorrect string value: '\x80 ' for column 'a' at row 1 -Warning 1366 Incorrect string value: '\x80!' for column 'a' at row 2 -Warning 1366 Incorrect string value: '\x80"' for column 'a' at row 3 -Warning 1366 Incorrect string value: '\x80#' for column 'a' at row 4 -Warning 1366 Incorrect string value: '\x80$' for column 'a' at row 5 -Warning 1366 Incorrect string value: '\x80%' for column 'a' at row 6 -Warning 1366 Incorrect string value: '\x80&' for column 'a' at row 7 -Warning 1366 Incorrect string value: '\x80'' for column 'a' at row 8 -Warning 1366 Incorrect string value: '\x80(' for column 'a' at row 9 -Warning 1366 Incorrect string value: '\x80)' for column 'a' at row 10 -Warning 1366 Incorrect string value: '\x80*' for column 'a' at row 11 -Warning 1366 Incorrect string value: '\x80+' for column 'a' at row 12 -Warning 1366 Incorrect string value: '\x80,' for column 'a' at row 13 -Warning 1366 Incorrect string value: '\x80-' for column 'a' at row 14 -Warning 1366 Incorrect string value: '\x80.' for column 'a' at row 15 -Warning 1366 Incorrect string value: '\x80/' for column 'a' at row 16 -Warning 1366 Incorrect string value: '\x800' for column 'a' at row 17 -Warning 1366 Incorrect string value: '\x801' for column 'a' at row 18 -Warning 1366 Incorrect string value: '\x802' for column 'a' at row 19 -Warning 1366 Incorrect string value: '\x803' for column 'a' at row 20 -Warning 1366 Incorrect string value: '\x804' for column 'a' at row 21 -Warning 1366 Incorrect string value: '\x805' for column 'a' at row 22 -Warning 1366 Incorrect string value: '\x806' for column 'a' at row 23 -Warning 1366 Incorrect string value: '\x807' for column 'a' at row 24 -Warning 1366 Incorrect string value: '\x808' for column 'a' at row 25 -Warning 1366 Incorrect string value: '\x809' for column 'a' at row 26 -Warning 1366 Incorrect string value: '\x80:' for column 'a' at row 27 -Warning 1366 Incorrect string value: '\x80;' for column 'a' at row 28 -Warning 1366 Incorrect string value: '\x80<' for column 'a' at row 29 -Warning 1366 Incorrect string value: '\x80=' for column 'a' at row 30 -Warning 1366 Incorrect string value: '\x80>' for column 'a' at row 31 -Warning 1366 Incorrect string value: '\x80?' for column 'a' at row 32 -Warning 1366 Incorrect string value: '\x80@' for column 'a' at row 33 -Warning 1366 Incorrect string value: '\x80A' for column 'a' at row 34 -Warning 1366 Incorrect string value: '\x80B' for column 'a' at row 35 -Warning 1366 Incorrect string value: '\x80C' for column 'a' at row 36 -Warning 1366 Incorrect string value: '\x80D' for column 'a' at row 37 -Warning 1366 Incorrect string value: '\x80E' for column 'a' at row 38 -Warning 1366 Incorrect string value: '\x80F' for column 'a' at row 39 -Warning 1366 Incorrect string value: '\x80G' for column 'a' at row 40 -Warning 1366 Incorrect string value: '\x80H' for column 'a' at row 41 -Warning 1366 Incorrect string value: '\x80I' for column 'a' at row 42 -Warning 1366 Incorrect string value: '\x80J' for column 'a' at row 43 -Warning 1366 Incorrect string value: '\x80K' for column 'a' at row 44 -Warning 1366 Incorrect string value: '\x80L' for column 'a' at row 45 -Warning 1366 Incorrect string value: '\x80M' for column 'a' at row 46 -Warning 1366 Incorrect string value: '\x80N' for column 'a' at row 47 -Warning 1366 Incorrect string value: '\x80O' for column 'a' at row 48 -Warning 1366 Incorrect string value: '\x80P' for column 'a' at row 49 -Warning 1366 Incorrect string value: '\x80Q' for column 'a' at row 50 -Warning 1366 Incorrect string value: '\x80R' for column 'a' at row 51 -Warning 1366 Incorrect string value: '\x80S' for column 'a' at row 52 -Warning 1366 Incorrect string value: '\x80T' for column 'a' at row 53 -Warning 1366 Incorrect string value: '\x80U' for column 'a' at row 54 -Warning 1366 Incorrect string value: '\x80V' for column 'a' at row 55 -Warning 1366 Incorrect string value: '\x80W' for column 'a' at row 56 -Warning 1366 Incorrect string value: '\x80X' for column 'a' at row 57 -Warning 1366 Incorrect string value: '\x80Y' for column 'a' at row 58 -Warning 1366 Incorrect string value: '\x80Z' for column 'a' at row 59 -Warning 1366 Incorrect string value: '\x80[' for column 'a' at row 60 -Warning 1366 Incorrect string value: '\x80\' for column 'a' at row 61 -Warning 1366 Incorrect string value: '\x80]' for column 'a' at row 62 -Warning 1366 Incorrect string value: '\x80^' for column 'a' at row 63 -Warning 1366 Incorrect string value: '\x80_' for column 'a' at row 64 +Warning 1366 Incorrect string value: '\x80 ' for column 'test.t1.a' at row 1 +Warning 1366 Incorrect string value: '\x80!' for column 'test.t1.a' at row 2 +Warning 1366 Incorrect string value: '\x80"' for column 'test.t1.a' at row 3 +Warning 1366 Incorrect string value: '\x80#' for column 'test.t1.a' at row 4 +Warning 1366 Incorrect string value: '\x80$' for column 'test.t1.a' at row 5 +Warning 1366 Incorrect string value: '\x80%' for column 'test.t1.a' at row 6 +Warning 1366 Incorrect string value: '\x80&' for column 'test.t1.a' at row 7 +Warning 1366 Incorrect string value: '\x80'' for column 'test.t1.a' at row 8 +Warning 1366 Incorrect string value: '\x80(' for column 'test.t1.a' at row 9 +Warning 1366 Incorrect string value: '\x80)' for column 'test.t1.a' at row 10 +Warning 1366 Incorrect string value: '\x80*' for column 'test.t1.a' at row 11 +Warning 1366 Incorrect string value: '\x80+' for column 'test.t1.a' at row 12 +Warning 1366 Incorrect string value: '\x80,' for column 'test.t1.a' at row 13 +Warning 1366 Incorrect string value: '\x80-' for column 'test.t1.a' at row 14 +Warning 1366 Incorrect string value: '\x80.' for column 'test.t1.a' at row 15 +Warning 1366 Incorrect string value: '\x80/' for column 'test.t1.a' at row 16 +Warning 1366 Incorrect string value: '\x800' for column 'test.t1.a' at row 17 +Warning 1366 Incorrect string value: '\x801' for column 'test.t1.a' at row 18 +Warning 1366 Incorrect string value: '\x802' for column 'test.t1.a' at row 19 +Warning 1366 Incorrect string value: '\x803' for column 'test.t1.a' at row 20 +Warning 1366 Incorrect string value: '\x804' for column 'test.t1.a' at row 21 +Warning 1366 Incorrect string value: '\x805' for column 'test.t1.a' at row 22 +Warning 1366 Incorrect string value: '\x806' for column 'test.t1.a' at row 23 +Warning 1366 Incorrect string value: '\x807' for column 'test.t1.a' at row 24 +Warning 1366 Incorrect string value: '\x808' for column 'test.t1.a' at row 25 +Warning 1366 Incorrect string value: '\x809' for column 'test.t1.a' at row 26 +Warning 1366 Incorrect string value: '\x80:' for column 'test.t1.a' at row 27 +Warning 1366 Incorrect string value: '\x80;' for column 'test.t1.a' at row 28 +Warning 1366 Incorrect string value: '\x80<' for column 'test.t1.a' at row 29 +Warning 1366 Incorrect string value: '\x80=' for column 'test.t1.a' at row 30 +Warning 1366 Incorrect string value: '\x80>' for column 'test.t1.a' at row 31 +Warning 1366 Incorrect string value: '\x80?' for column 'test.t1.a' at row 32 +Warning 1366 Incorrect string value: '\x80@' for column 'test.t1.a' at row 33 +Warning 1366 Incorrect string value: '\x80A' for column 'test.t1.a' at row 34 +Warning 1366 Incorrect string value: '\x80B' for column 'test.t1.a' at row 35 +Warning 1366 Incorrect string value: '\x80C' for column 'test.t1.a' at row 36 +Warning 1366 Incorrect string value: '\x80D' for column 'test.t1.a' at row 37 +Warning 1366 Incorrect string value: '\x80E' for column 'test.t1.a' at row 38 +Warning 1366 Incorrect string value: '\x80F' for column 'test.t1.a' at row 39 +Warning 1366 Incorrect string value: '\x80G' for column 'test.t1.a' at row 40 +Warning 1366 Incorrect string value: '\x80H' for column 'test.t1.a' at row 41 +Warning 1366 Incorrect string value: '\x80I' for column 'test.t1.a' at row 42 +Warning 1366 Incorrect string value: '\x80J' for column 'test.t1.a' at row 43 +Warning 1366 Incorrect string value: '\x80K' for column 'test.t1.a' at row 44 +Warning 1366 Incorrect string value: '\x80L' for column 'test.t1.a' at row 45 +Warning 1366 Incorrect string value: '\x80M' for column 'test.t1.a' at row 46 +Warning 1366 Incorrect string value: '\x80N' for column 'test.t1.a' at row 47 +Warning 1366 Incorrect string value: '\x80O' for column 'test.t1.a' at row 48 +Warning 1366 Incorrect string value: '\x80P' for column 'test.t1.a' at row 49 +Warning 1366 Incorrect string value: '\x80Q' for column 'test.t1.a' at row 50 +Warning 1366 Incorrect string value: '\x80R' for column 'test.t1.a' at row 51 +Warning 1366 Incorrect string value: '\x80S' for column 'test.t1.a' at row 52 +Warning 1366 Incorrect string value: '\x80T' for column 'test.t1.a' at row 53 +Warning 1366 Incorrect string value: '\x80U' for column 'test.t1.a' at row 54 +Warning 1366 Incorrect string value: '\x80V' for column 'test.t1.a' at row 55 +Warning 1366 Incorrect string value: '\x80W' for column 'test.t1.a' at row 56 +Warning 1366 Incorrect string value: '\x80X' for column 'test.t1.a' at row 57 +Warning 1366 Incorrect string value: '\x80Y' for column 'test.t1.a' at row 58 +Warning 1366 Incorrect string value: '\x80Z' for column 'test.t1.a' at row 59 +Warning 1366 Incorrect string value: '\x80[' for column 'test.t1.a' at row 60 +Warning 1366 Incorrect string value: '\x80\' for column 'test.t1.a' at row 61 +Warning 1366 Incorrect string value: '\x80]' for column 'test.t1.a' at row 62 +Warning 1366 Incorrect string value: '\x80^' for column 'test.t1.a' at row 63 +Warning 1366 Incorrect string value: '\x80_' for column 'test.t1.a' at row 64 SELECT COUNT(*) FROM t1 WHERE a<>'?'; COUNT(*) 8178 diff --git a/mysql-test/r/ctype_gbk.result b/mysql-test/r/ctype_gbk.result index 4e5c969..408e79e 100644 --- a/mysql-test/r/ctype_gbk.result +++ b/mysql-test/r/ctype_gbk.result @@ -511,70 +511,70 @@ t1 CREATE TABLE `t1` ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 UPDATE IGNORE t1 SET a=unhex(code) ORDER BY code; Warnings: -Warning 1366 Incorrect string value: '\x80 ' for column 'a' at row 1 -Warning 1366 Incorrect string value: '\x80!' for column 'a' at row 2 -Warning 1366 Incorrect string value: '\x80"' for column 'a' at row 3 -Warning 1366 Incorrect string value: '\x80#' for column 'a' at row 4 -Warning 1366 Incorrect string value: '\x80$' for column 'a' at row 5 -Warning 1366 Incorrect string value: '\x80%' for column 'a' at row 6 -Warning 1366 Incorrect string value: '\x80&' for column 'a' at row 7 -Warning 1366 Incorrect string value: '\x80'' for column 'a' at row 8 -Warning 1366 Incorrect string value: '\x80(' for column 'a' at row 9 -Warning 1366 Incorrect string value: '\x80)' for column 'a' at row 10 -Warning 1366 Incorrect string value: '\x80*' for column 'a' at row 11 -Warning 1366 Incorrect string value: '\x80+' for column 'a' at row 12 -Warning 1366 Incorrect string value: '\x80,' for column 'a' at row 13 -Warning 1366 Incorrect string value: '\x80-' for column 'a' at row 14 -Warning 1366 Incorrect string value: '\x80.' for column 'a' at row 15 -Warning 1366 Incorrect string value: '\x80/' for column 'a' at row 16 -Warning 1366 Incorrect string value: '\x800' for column 'a' at row 17 -Warning 1366 Incorrect string value: '\x801' for column 'a' at row 18 -Warning 1366 Incorrect string value: '\x802' for column 'a' at row 19 -Warning 1366 Incorrect string value: '\x803' for column 'a' at row 20 -Warning 1366 Incorrect string value: '\x804' for column 'a' at row 21 -Warning 1366 Incorrect string value: '\x805' for column 'a' at row 22 -Warning 1366 Incorrect string value: '\x806' for column 'a' at row 23 -Warning 1366 Incorrect string value: '\x807' for column 'a' at row 24 -Warning 1366 Incorrect string value: '\x808' for column 'a' at row 25 -Warning 1366 Incorrect string value: '\x809' for column 'a' at row 26 -Warning 1366 Incorrect string value: '\x80:' for column 'a' at row 27 -Warning 1366 Incorrect string value: '\x80;' for column 'a' at row 28 -Warning 1366 Incorrect string value: '\x80<' for column 'a' at row 29 -Warning 1366 Incorrect string value: '\x80=' for column 'a' at row 30 -Warning 1366 Incorrect string value: '\x80>' for column 'a' at row 31 -Warning 1366 Incorrect string value: '\x80?' for column 'a' at row 32 -Warning 1366 Incorrect string value: '\x80@' for column 'a' at row 33 -Warning 1366 Incorrect string value: '\x80A' for column 'a' at row 34 -Warning 1366 Incorrect string value: '\x80B' for column 'a' at row 35 -Warning 1366 Incorrect string value: '\x80C' for column 'a' at row 36 -Warning 1366 Incorrect string value: '\x80D' for column 'a' at row 37 -Warning 1366 Incorrect string value: '\x80E' for column 'a' at row 38 -Warning 1366 Incorrect string value: '\x80F' for column 'a' at row 39 -Warning 1366 Incorrect string value: '\x80G' for column 'a' at row 40 -Warning 1366 Incorrect string value: '\x80H' for column 'a' at row 41 -Warning 1366 Incorrect string value: '\x80I' for column 'a' at row 42 -Warning 1366 Incorrect string value: '\x80J' for column 'a' at row 43 -Warning 1366 Incorrect string value: '\x80K' for column 'a' at row 44 -Warning 1366 Incorrect string value: '\x80L' for column 'a' at row 45 -Warning 1366 Incorrect string value: '\x80M' for column 'a' at row 46 -Warning 1366 Incorrect string value: '\x80N' for column 'a' at row 47 -Warning 1366 Incorrect string value: '\x80O' for column 'a' at row 48 -Warning 1366 Incorrect string value: '\x80P' for column 'a' at row 49 -Warning 1366 Incorrect string value: '\x80Q' for column 'a' at row 50 -Warning 1366 Incorrect string value: '\x80R' for column 'a' at row 51 -Warning 1366 Incorrect string value: '\x80S' for column 'a' at row 52 -Warning 1366 Incorrect string value: '\x80T' for column 'a' at row 53 -Warning 1366 Incorrect string value: '\x80U' for column 'a' at row 54 -Warning 1366 Incorrect string value: '\x80V' for column 'a' at row 55 -Warning 1366 Incorrect string value: '\x80W' for column 'a' at row 56 -Warning 1366 Incorrect string value: '\x80X' for column 'a' at row 57 -Warning 1366 Incorrect string value: '\x80Y' for column 'a' at row 58 -Warning 1366 Incorrect string value: '\x80Z' for column 'a' at row 59 -Warning 1366 Incorrect string value: '\x80[' for column 'a' at row 60 -Warning 1366 Incorrect string value: '\x80\' for column 'a' at row 61 -Warning 1366 Incorrect string value: '\x80]' for column 'a' at row 62 -Warning 1366 Incorrect string value: '\x80^' for column 'a' at row 63 -Warning 1366 Incorrect string value: '\x80_' for column 'a' at row 64 +Warning 1366 Incorrect string value: '\x80 ' for column 'test.t1.a' at row 1 +Warning 1366 Incorrect string value: '\x80!' for column 'test.t1.a' at row 2 +Warning 1366 Incorrect string value: '\x80"' for column 'test.t1.a' at row 3 +Warning 1366 Incorrect string value: '\x80#' for column 'test.t1.a' at row 4 +Warning 1366 Incorrect string value: '\x80$' for column 'test.t1.a' at row 5 +Warning 1366 Incorrect string value: '\x80%' for column 'test.t1.a' at row 6 +Warning 1366 Incorrect string value: '\x80&' for column 'test.t1.a' at row 7 +Warning 1366 Incorrect string value: '\x80'' for column 'test.t1.a' at row 8 +Warning 1366 Incorrect string value: '\x80(' for column 'test.t1.a' at row 9 +Warning 1366 Incorrect string value: '\x80)' for column 'test.t1.a' at row 10 +Warning 1366 Incorrect string value: '\x80*' for column 'test.t1.a' at row 11 +Warning 1366 Incorrect string value: '\x80+' for column 'test.t1.a' at row 12 +Warning 1366 Incorrect string value: '\x80,' for column 'test.t1.a' at row 13 +Warning 1366 Incorrect string value: '\x80-' for column 'test.t1.a' at row 14 +Warning 1366 Incorrect string value: '\x80.' for column 'test.t1.a' at row 15 +Warning 1366 Incorrect string value: '\x80/' for column 'test.t1.a' at row 16 +Warning 1366 Incorrect string value: '\x800' for column 'test.t1.a' at row 17 +Warning 1366 Incorrect string value: '\x801' for column 'test.t1.a' at row 18 +Warning 1366 Incorrect string value: '\x802' for column 'test.t1.a' at row 19 +Warning 1366 Incorrect string value: '\x803' for column 'test.t1.a' at row 20 +Warning 1366 Incorrect string value: '\x804' for column 'test.t1.a' at row 21 +Warning 1366 Incorrect string value: '\x805' for column 'test.t1.a' at row 22 +Warning 1366 Incorrect string value: '\x806' for column 'test.t1.a' at row 23 +Warning 1366 Incorrect string value: '\x807' for column 'test.t1.a' at row 24 +Warning 1366 Incorrect string value: '\x808' for column 'test.t1.a' at row 25 +Warning 1366 Incorrect string value: '\x809' for column 'test.t1.a' at row 26 +Warning 1366 Incorrect string value: '\x80:' for column 'test.t1.a' at row 27 +Warning 1366 Incorrect string value: '\x80;' for column 'test.t1.a' at row 28 +Warning 1366 Incorrect string value: '\x80<' for column 'test.t1.a' at row 29 +Warning 1366 Incorrect string value: '\x80=' for column 'test.t1.a' at row 30 +Warning 1366 Incorrect string value: '\x80>' for column 'test.t1.a' at row 31 +Warning 1366 Incorrect string value: '\x80?' for column 'test.t1.a' at row 32 +Warning 1366 Incorrect string value: '\x80@' for column 'test.t1.a' at row 33 +Warning 1366 Incorrect string value: '\x80A' for column 'test.t1.a' at row 34 +Warning 1366 Incorrect string value: '\x80B' for column 'test.t1.a' at row 35 +Warning 1366 Incorrect string value: '\x80C' for column 'test.t1.a' at row 36 +Warning 1366 Incorrect string value: '\x80D' for column 'test.t1.a' at row 37 +Warning 1366 Incorrect string value: '\x80E' for column 'test.t1.a' at row 38 +Warning 1366 Incorrect string value: '\x80F' for column 'test.t1.a' at row 39 +Warning 1366 Incorrect string value: '\x80G' for column 'test.t1.a' at row 40 +Warning 1366 Incorrect string value: '\x80H' for column 'test.t1.a' at row 41 +Warning 1366 Incorrect string value: '\x80I' for column 'test.t1.a' at row 42 +Warning 1366 Incorrect string value: '\x80J' for column 'test.t1.a' at row 43 +Warning 1366 Incorrect string value: '\x80K' for column 'test.t1.a' at row 44 +Warning 1366 Incorrect string value: '\x80L' for column 'test.t1.a' at row 45 +Warning 1366 Incorrect string value: '\x80M' for column 'test.t1.a' at row 46 +Warning 1366 Incorrect string value: '\x80N' for column 'test.t1.a' at row 47 +Warning 1366 Incorrect string value: '\x80O' for column 'test.t1.a' at row 48 +Warning 1366 Incorrect string value: '\x80P' for column 'test.t1.a' at row 49 +Warning 1366 Incorrect string value: '\x80Q' for column 'test.t1.a' at row 50 +Warning 1366 Incorrect string value: '\x80R' for column 'test.t1.a' at row 51 +Warning 1366 Incorrect string value: '\x80S' for column 'test.t1.a' at row 52 +Warning 1366 Incorrect string value: '\x80T' for column 'test.t1.a' at row 53 +Warning 1366 Incorrect string value: '\x80U' for column 'test.t1.a' at row 54 +Warning 1366 Incorrect string value: '\x80V' for column 'test.t1.a' at row 55 +Warning 1366 Incorrect string value: '\x80W' for column 'test.t1.a' at row 56 +Warning 1366 Incorrect string value: '\x80X' for column 'test.t1.a' at row 57 +Warning 1366 Incorrect string value: '\x80Y' for column 'test.t1.a' at row 58 +Warning 1366 Incorrect string value: '\x80Z' for column 'test.t1.a' at row 59 +Warning 1366 Incorrect string value: '\x80[' for column 'test.t1.a' at row 60 +Warning 1366 Incorrect string value: '\x80\' for column 'test.t1.a' at row 61 +Warning 1366 Incorrect string value: '\x80]' for column 'test.t1.a' at row 62 +Warning 1366 Incorrect string value: '\x80^' for column 'test.t1.a' at row 63 +Warning 1366 Incorrect string value: '\x80_' for column 'test.t1.a' at row 64 SELECT COUNT(*) FROM t1 WHERE a<>'?'; COUNT(*) 23940 @@ -5192,25 +5192,25 @@ INSERT IGNORE INTO t3 (b,c,comment) SELECT b,b,comment FROM t2 WHERE type1='tail' OR type1='bad' OR type2='bad' ORDER BY b; Warnings: -Warning 1366 Incorrect string value: '\xFF' for column 'c' at row 1 -Warning 1366 Incorrect string value: '\x80@' for column 'c' at row 2 -Warning 1366 Incorrect string value: '\x80\x80' for column 'c' at row 3 -Warning 1366 Incorrect string value: '\x80\x81' for column 'c' at row 4 -Warning 1366 Incorrect string value: '\x80\xA1@' for column 'c' at row 5 -Warning 1366 Incorrect string value: '\x80\xA1\xA3' for column 'c' at row 6 -Warning 1366 Incorrect string value: '\x80\xFE@' for column 'c' at row 7 -Warning 1366 Incorrect string value: '\x80\xFF' for column 'c' at row 8 -Warning 1366 Incorrect string value: '\x81\xFF' for column 'c' at row 9 -Warning 1366 Incorrect string value: '\xFF' for column 'c' at row 10 -Warning 1366 Incorrect string value: '\xFF' for column 'c' at row 11 -Warning 1366 Incorrect string value: '\xFF' for column 'c' at row 12 -Warning 1366 Incorrect string value: '\xFF@' for column 'c' at row 13 -Warning 1366 Incorrect string value: '\xFF\x80' for column 'c' at row 14 -Warning 1366 Incorrect string value: '\xFF\x81' for column 'c' at row 15 -Warning 1366 Incorrect string value: '\xFF\xA1@' for column 'c' at row 16 -Warning 1366 Incorrect string value: '\xFF\xA1\xA3' for column 'c' at row 17 -Warning 1366 Incorrect string value: '\xFF\xFE@' for column 'c' at row 18 -Warning 1366 Incorrect string value: '\xFF\xFF' for column 'c' at row 19 +Warning 1366 Incorrect string value: '\xFF' for column 'test.t3.c' at row 1 +Warning 1366 Incorrect string value: '\x80@' for column 'test.t3.c' at row 2 +Warning 1366 Incorrect string value: '\x80\x80' for column 'test.t3.c' at row 3 +Warning 1366 Incorrect string value: '\x80\x81' for column 'test.t3.c' at row 4 +Warning 1366 Incorrect string value: '\x80\xA1@' for column 'test.t3.c' at row 5 +Warning 1366 Incorrect string value: '\x80\xA1\xA3' for column 'test.t3.c' at row 6 +Warning 1366 Incorrect string value: '\x80\xFE@' for column 'test.t3.c' at row 7 +Warning 1366 Incorrect string value: '\x80\xFF' for column 'test.t3.c' at row 8 +Warning 1366 Incorrect string value: '\x81\xFF' for column 'test.t3.c' at row 9 +Warning 1366 Incorrect string value: '\xFF' for column 'test.t3.c' at row 10 +Warning 1366 Incorrect string value: '\xFF' for column 'test.t3.c' at row 11 +Warning 1366 Incorrect string value: '\xFF' for column 'test.t3.c' at row 12 +Warning 1366 Incorrect string value: '\xFF@' for column 'test.t3.c' at row 13 +Warning 1366 Incorrect string value: '\xFF\x80' for column 'test.t3.c' at row 14 +Warning 1366 Incorrect string value: '\xFF\x81' for column 'test.t3.c' at row 15 +Warning 1366 Incorrect string value: '\xFF\xA1@' for column 'test.t3.c' at row 16 +Warning 1366 Incorrect string value: '\xFF\xA1\xA3' for column 'test.t3.c' at row 17 +Warning 1366 Incorrect string value: '\xFF\xFE@' for column 'test.t3.c' at row 18 +Warning 1366 Incorrect string value: '\xFF\xFF' for column 'test.t3.c' at row 19 SELECT COUNT(*) FROM t3; COUNT(*) 19 @@ -5248,14 +5248,14 @@ WHERE (FIND_IN_SET('mb2',type1) OR FIND_IN_SET('ascii',type1)) AND (FIND_IN_SET('tail',type2) AND NOT FIND_IN_SET('ascii',type2)) ORDER BY b; Warnings: -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 1 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 2 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 3 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 4 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 5 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 6 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 7 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 8 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 1 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 2 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 3 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 4 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 5 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 6 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 7 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 8 SELECT COUNT(*) FROM t3; COUNT(*) 8 @@ -5278,7 +5278,7 @@ DELETE FROM t3; # INSERT INTO t3 (b,c,comment) SELECT b,b,comment FROM t2 ORDER BY b; Warnings: -Warning 1366 Incorrect string value: '\xA3' for column 'c' at row 5 +Warning 1366 Incorrect string value: '\xA3' for column 'test.t3.c' at row 5 SELECT COUNT(*) FROM t3; COUNT(*) 6 @@ -5401,70 +5401,70 @@ INSERT IGNORE INTO t3 (b,c,comment) SELECT b,b,comment FROM t2 WHERE type1='tail' OR type1='bad' OR type2='bad' OR type3='bad' ORDER BY b; Warnings: -Warning 1366 Incorrect string value: '\xFF' for column 'c' at row 1 -Warning 1366 Incorrect string value: '\x80\xFF' for column 'c' at row 2 -Warning 1366 Incorrect string value: '\x81\xFF' for column 'c' at row 3 -Warning 1366 Incorrect string value: '\xFF' for column 'c' at row 4 -Warning 1366 Incorrect string value: '\xFF' for column 'c' at row 5 -Warning 1366 Incorrect string value: '\xFF' for column 'c' at row 6 -Warning 1366 Incorrect string value: '\xFF@' for column 'c' at row 7 -Warning 1366 Incorrect string value: '\xFF\x80' for column 'c' at row 8 -Warning 1366 Incorrect string value: '\xFF\x81' for column 'c' at row 9 -Warning 1366 Incorrect string value: '\xFF\xA1@' for column 'c' at row 10 -Warning 1366 Incorrect string value: '\xFF\xA1\xA3' for column 'c' at row 11 -Warning 1366 Incorrect string value: '\xFF\xFE@' for column 'c' at row 12 -Warning 1366 Incorrect string value: '\xFF\xFF' for column 'c' at row 13 -Warning 1366 Incorrect string value: '\x80@@' for column 'c' at row 14 -Warning 1366 Incorrect string value: '\x80@\x80' for column 'c' at row 15 -Warning 1366 Incorrect string value: '\x80@\x81' for column 'c' at row 16 -Warning 1366 Incorrect string value: '\x80@\xA1@' for column 'c' at row 17 -Warning 1366 Incorrect string value: '\x80@\xA1\xA3' for column 'c' at row 18 -Warning 1366 Incorrect string value: '\x80@\xFE@' for column 'c' at row 19 -Warning 1366 Incorrect string value: '\x80@\xFF' for column 'c' at row 20 -Warning 1366 Incorrect string value: '\x80\x80@' for column 'c' at row 21 -Warning 1366 Incorrect string value: '\x80\x80\x80' for column 'c' at row 22 -Warning 1366 Incorrect string value: '\x80\x80\x81' for column 'c' at row 23 -Warning 1366 Incorrect string value: '\x80\x80\xA1@' for column 'c' at row 24 -Warning 1366 Incorrect string value: '\x80\x80\xA1\xA3' for column 'c' at row 25 -Warning 1366 Incorrect string value: '\x80\x80\xFE@' for column 'c' at row 26 -Warning 1366 Incorrect string value: '\x80\x80\xFF' for column 'c' at row 27 -Warning 1366 Incorrect string value: '\x80\x81@' for column 'c' at row 28 -Warning 1366 Incorrect string value: '\x80\x81\x80' for column 'c' at row 29 -Warning 1366 Incorrect string value: '\x80\x81\x81' for column 'c' at row 30 -Warning 1366 Incorrect string value: '\x80\x81\xA1@' for column 'c' at row 31 -Warning 1366 Incorrect string value: '\x80\x81\xA1\xA3' for column 'c' at row 32 -Warning 1366 Incorrect string value: '\x80\x81\xFE@' for column 'c' at row 33 -Warning 1366 Incorrect string value: '\x80\x81\xFF' for column 'c' at row 34 -Warning 1366 Incorrect string value: '\x80\xA1@@' for column 'c' at row 35 -Warning 1366 Incorrect string value: '\x80\xA1@\x80' for column 'c' at row 36 -Warning 1366 Incorrect string value: '\x80\xA1@\x81' for column 'c' at row 37 -Warning 1366 Incorrect string value: '\x80\xA1@\xA1@' for column 'c' at row 38 -Warning 1366 Incorrect string value: '\x80\xA1@\xA1\xA3' for column 'c' at row 39 -Warning 1366 Incorrect string value: '\x80\xA1@\xFE@' for column 'c' at row 40 -Warning 1366 Incorrect string value: '\x80\xA1@\xFF' for column 'c' at row 41 -Warning 1366 Incorrect string value: '\x80\xA1\xA3@' for column 'c' at row 42 -Warning 1366 Incorrect string value: '\x80\xA1\xA3\x80' for column 'c' at row 43 -Warning 1366 Incorrect string value: '\x80\xA1\xA3\x81' for column 'c' at row 44 -Warning 1366 Incorrect string value: '\x80\xA1\xA3\xA1@' for column 'c' at row 45 -Warning 1366 Incorrect string value: '\x80\xA1\xA3\xA1\xA3' for column 'c' at row 46 -Warning 1366 Incorrect string value: '\x80\xA1\xA3\xFE@' for column 'c' at row 47 -Warning 1366 Incorrect string value: '\x80\xA1\xA3\xFF' for column 'c' at row 48 -Warning 1366 Incorrect string value: '\x80\xFE@@' for column 'c' at row 49 -Warning 1366 Incorrect string value: '\x80\xFE@\x80' for column 'c' at row 50 -Warning 1366 Incorrect string value: '\x80\xFE@\x81' for column 'c' at row 51 -Warning 1366 Incorrect string value: '\x80\xFE@\xA1@' for column 'c' at row 52 -Warning 1366 Incorrect string value: '\x80\xFE@\xA1\xA3' for column 'c' at row 53 -Warning 1366 Incorrect string value: '\x80\xFE@\xFE@' for column 'c' at row 54 -Warning 1366 Incorrect string value: '\x80\xFE@\xFF' for column 'c' at row 55 -Warning 1366 Incorrect string value: '\x80\xFF@' for column 'c' at row 56 -Warning 1366 Incorrect string value: '\x80\xFF\x80' for column 'c' at row 57 -Warning 1366 Incorrect string value: '\x80\xFF\x81' for column 'c' at row 58 -Warning 1366 Incorrect string value: '\x80\xFF\xA1@' for column 'c' at row 59 -Warning 1366 Incorrect string value: '\x80\xFF\xA1\xA3' for column 'c' at row 60 -Warning 1366 Incorrect string value: '\x80\xFF\xFE@' for column 'c' at row 61 -Warning 1366 Incorrect string value: '\x80\xFF\xFF' for column 'c' at row 62 -Warning 1366 Incorrect string value: '\xFF' for column 'c' at row 63 -Warning 1366 Incorrect string value: '\xFF' for column 'c' at row 64 +Warning 1366 Incorrect string value: '\xFF' for column 'test.t3.c' at row 1 +Warning 1366 Incorrect string value: '\x80\xFF' for column 'test.t3.c' at row 2 +Warning 1366 Incorrect string value: '\x81\xFF' for column 'test.t3.c' at row 3 +Warning 1366 Incorrect string value: '\xFF' for column 'test.t3.c' at row 4 +Warning 1366 Incorrect string value: '\xFF' for column 'test.t3.c' at row 5 +Warning 1366 Incorrect string value: '\xFF' for column 'test.t3.c' at row 6 +Warning 1366 Incorrect string value: '\xFF@' for column 'test.t3.c' at row 7 +Warning 1366 Incorrect string value: '\xFF\x80' for column 'test.t3.c' at row 8 +Warning 1366 Incorrect string value: '\xFF\x81' for column 'test.t3.c' at row 9 +Warning 1366 Incorrect string value: '\xFF\xA1@' for column 'test.t3.c' at row 10 +Warning 1366 Incorrect string value: '\xFF\xA1\xA3' for column 'test.t3.c' at row 11 +Warning 1366 Incorrect string value: '\xFF\xFE@' for column 'test.t3.c' at row 12 +Warning 1366 Incorrect string value: '\xFF\xFF' for column 'test.t3.c' at row 13 +Warning 1366 Incorrect string value: '\x80@@' for column 'test.t3.c' at row 14 +Warning 1366 Incorrect string value: '\x80@\x80' for column 'test.t3.c' at row 15 +Warning 1366 Incorrect string value: '\x80@\x81' for column 'test.t3.c' at row 16 +Warning 1366 Incorrect string value: '\x80@\xA1@' for column 'test.t3.c' at row 17 +Warning 1366 Incorrect string value: '\x80@\xA1\xA3' for column 'test.t3.c' at row 18 +Warning 1366 Incorrect string value: '\x80@\xFE@' for column 'test.t3.c' at row 19 +Warning 1366 Incorrect string value: '\x80@\xFF' for column 'test.t3.c' at row 20 +Warning 1366 Incorrect string value: '\x80\x80@' for column 'test.t3.c' at row 21 +Warning 1366 Incorrect string value: '\x80\x80\x80' for column 'test.t3.c' at row 22 +Warning 1366 Incorrect string value: '\x80\x80\x81' for column 'test.t3.c' at row 23 +Warning 1366 Incorrect string value: '\x80\x80\xA1@' for column 'test.t3.c' at row 24 +Warning 1366 Incorrect string value: '\x80\x80\xA1\xA3' for column 'test.t3.c' at row 25 +Warning 1366 Incorrect string value: '\x80\x80\xFE@' for column 'test.t3.c' at row 26 +Warning 1366 Incorrect string value: '\x80\x80\xFF' for column 'test.t3.c' at row 27 +Warning 1366 Incorrect string value: '\x80\x81@' for column 'test.t3.c' at row 28 +Warning 1366 Incorrect string value: '\x80\x81\x80' for column 'test.t3.c' at row 29 +Warning 1366 Incorrect string value: '\x80\x81\x81' for column 'test.t3.c' at row 30 +Warning 1366 Incorrect string value: '\x80\x81\xA1@' for column 'test.t3.c' at row 31 +Warning 1366 Incorrect string value: '\x80\x81\xA1\xA3' for column 'test.t3.c' at row 32 +Warning 1366 Incorrect string value: '\x80\x81\xFE@' for column 'test.t3.c' at row 33 +Warning 1366 Incorrect string value: '\x80\x81\xFF' for column 'test.t3.c' at row 34 +Warning 1366 Incorrect string value: '\x80\xA1@@' for column 'test.t3.c' at row 35 +Warning 1366 Incorrect string value: '\x80\xA1@\x80' for column 'test.t3.c' at row 36 +Warning 1366 Incorrect string value: '\x80\xA1@\x81' for column 'test.t3.c' at row 37 +Warning 1366 Incorrect string value: '\x80\xA1@\xA1@' for column 'test.t3.c' at row 38 +Warning 1366 Incorrect string value: '\x80\xA1@\xA1\xA3' for column 'test.t3.c' at row 39 +Warning 1366 Incorrect string value: '\x80\xA1@\xFE@' for column 'test.t3.c' at row 40 +Warning 1366 Incorrect string value: '\x80\xA1@\xFF' for column 'test.t3.c' at row 41 +Warning 1366 Incorrect string value: '\x80\xA1\xA3@' for column 'test.t3.c' at row 42 +Warning 1366 Incorrect string value: '\x80\xA1\xA3\x80' for column 'test.t3.c' at row 43 +Warning 1366 Incorrect string value: '\x80\xA1\xA3\x81' for column 'test.t3.c' at row 44 +Warning 1366 Incorrect string value: '\x80\xA1\xA3\xA1@' for column 'test.t3.c' at row 45 +Warning 1366 Incorrect string value: '\x80\xA1\xA3\xA1\xA3' for column 'test.t3.c' at row 46 +Warning 1366 Incorrect string value: '\x80\xA1\xA3\xFE@' for column 'test.t3.c' at row 47 +Warning 1366 Incorrect string value: '\x80\xA1\xA3\xFF' for column 'test.t3.c' at row 48 +Warning 1366 Incorrect string value: '\x80\xFE@@' for column 'test.t3.c' at row 49 +Warning 1366 Incorrect string value: '\x80\xFE@\x80' for column 'test.t3.c' at row 50 +Warning 1366 Incorrect string value: '\x80\xFE@\x81' for column 'test.t3.c' at row 51 +Warning 1366 Incorrect string value: '\x80\xFE@\xA1@' for column 'test.t3.c' at row 52 +Warning 1366 Incorrect string value: '\x80\xFE@\xA1\xA3' for column 'test.t3.c' at row 53 +Warning 1366 Incorrect string value: '\x80\xFE@\xFE@' for column 'test.t3.c' at row 54 +Warning 1366 Incorrect string value: '\x80\xFE@\xFF' for column 'test.t3.c' at row 55 +Warning 1366 Incorrect string value: '\x80\xFF@' for column 'test.t3.c' at row 56 +Warning 1366 Incorrect string value: '\x80\xFF\x80' for column 'test.t3.c' at row 57 +Warning 1366 Incorrect string value: '\x80\xFF\x81' for column 'test.t3.c' at row 58 +Warning 1366 Incorrect string value: '\x80\xFF\xA1@' for column 'test.t3.c' at row 59 +Warning 1366 Incorrect string value: '\x80\xFF\xA1\xA3' for column 'test.t3.c' at row 60 +Warning 1366 Incorrect string value: '\x80\xFF\xFE@' for column 'test.t3.c' at row 61 +Warning 1366 Incorrect string value: '\x80\xFF\xFF' for column 'test.t3.c' at row 62 +Warning 1366 Incorrect string value: '\xFF' for column 'test.t3.c' at row 63 +Warning 1366 Incorrect string value: '\xFF' for column 'test.t3.c' at row 64 SELECT COUNT(*) FROM t3; COUNT(*) 163 @@ -5646,30 +5646,30 @@ WHERE (FIND_IN_SET('mb2',type1) OR FIND_IN_SET('ascii',type1)) AND type2='tail' ORDER BY b; Warnings: -Warning 1366 Incorrect string value: '\x80@' for column 'c' at row 1 -Warning 1366 Incorrect string value: '\x80\x80' for column 'c' at row 2 -Warning 1366 Incorrect string value: '\x80\x81' for column 'c' at row 3 -Warning 1366 Incorrect string value: '\x80\xA1@' for column 'c' at row 4 -Warning 1366 Incorrect string value: '\x80\xA1\xA3' for column 'c' at row 5 -Warning 1366 Incorrect string value: '\x80\xFE@' for column 'c' at row 6 -Warning 1366 Incorrect string value: '\x80@' for column 'c' at row 7 -Warning 1366 Incorrect string value: '\x80\x80' for column 'c' at row 8 -Warning 1366 Incorrect string value: '\x80\x81' for column 'c' at row 9 -Warning 1366 Incorrect string value: '\x80\xA1@' for column 'c' at row 10 -Warning 1366 Incorrect string value: '\x80\xA1\xA3' for column 'c' at row 11 -Warning 1366 Incorrect string value: '\x80\xFE@' for column 'c' at row 12 -Warning 1366 Incorrect string value: '\x80@' for column 'c' at row 13 -Warning 1366 Incorrect string value: '\x80\x80' for column 'c' at row 14 -Warning 1366 Incorrect string value: '\x80\x81' for column 'c' at row 15 -Warning 1366 Incorrect string value: '\x80\xA1@' for column 'c' at row 16 -Warning 1366 Incorrect string value: '\x80\xA1\xA3' for column 'c' at row 17 -Warning 1366 Incorrect string value: '\x80\xFE@' for column 'c' at row 18 -Warning 1366 Incorrect string value: '\x80@' for column 'c' at row 19 -Warning 1366 Incorrect string value: '\x80\x80' for column 'c' at row 20 -Warning 1366 Incorrect string value: '\x80\x81' for column 'c' at row 21 -Warning 1366 Incorrect string value: '\x80\xA1@' for column 'c' at row 22 -Warning 1366 Incorrect string value: '\x80\xA1\xA3' for column 'c' at row 23 -Warning 1366 Incorrect string value: '\x80\xFE@' for column 'c' at row 24 +Warning 1366 Incorrect string value: '\x80@' for column 'test.t3.c' at row 1 +Warning 1366 Incorrect string value: '\x80\x80' for column 'test.t3.c' at row 2 +Warning 1366 Incorrect string value: '\x80\x81' for column 'test.t3.c' at row 3 +Warning 1366 Incorrect string value: '\x80\xA1@' for column 'test.t3.c' at row 4 +Warning 1366 Incorrect string value: '\x80\xA1\xA3' for column 'test.t3.c' at row 5 +Warning 1366 Incorrect string value: '\x80\xFE@' for column 'test.t3.c' at row 6 +Warning 1366 Incorrect string value: '\x80@' for column 'test.t3.c' at row 7 +Warning 1366 Incorrect string value: '\x80\x80' for column 'test.t3.c' at row 8 +Warning 1366 Incorrect string value: '\x80\x81' for column 'test.t3.c' at row 9 +Warning 1366 Incorrect string value: '\x80\xA1@' for column 'test.t3.c' at row 10 +Warning 1366 Incorrect string value: '\x80\xA1\xA3' for column 'test.t3.c' at row 11 +Warning 1366 Incorrect string value: '\x80\xFE@' for column 'test.t3.c' at row 12 +Warning 1366 Incorrect string value: '\x80@' for column 'test.t3.c' at row 13 +Warning 1366 Incorrect string value: '\x80\x80' for column 'test.t3.c' at row 14 +Warning 1366 Incorrect string value: '\x80\x81' for column 'test.t3.c' at row 15 +Warning 1366 Incorrect string value: '\x80\xA1@' for column 'test.t3.c' at row 16 +Warning 1366 Incorrect string value: '\x80\xA1\xA3' for column 'test.t3.c' at row 17 +Warning 1366 Incorrect string value: '\x80\xFE@' for column 'test.t3.c' at row 18 +Warning 1366 Incorrect string value: '\x80@' for column 'test.t3.c' at row 19 +Warning 1366 Incorrect string value: '\x80\x80' for column 'test.t3.c' at row 20 +Warning 1366 Incorrect string value: '\x80\x81' for column 'test.t3.c' at row 21 +Warning 1366 Incorrect string value: '\x80\xA1@' for column 'test.t3.c' at row 22 +Warning 1366 Incorrect string value: '\x80\xA1\xA3' for column 'test.t3.c' at row 23 +Warning 1366 Incorrect string value: '\x80\xFE@' for column 'test.t3.c' at row 24 SELECT COUNT(*) FROM t3; COUNT(*) 24 @@ -5713,22 +5713,22 @@ WHERE (FIND_IN_SET('mb2',type1) OR FIND_IN_SET('ascii',type1)) AND type3='tail' ORDER BY b; Warnings: -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 1 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 2 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 3 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 4 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 5 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 6 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 7 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 8 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 9 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 10 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 11 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 12 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 13 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 14 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 15 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 16 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 1 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 2 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 3 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 4 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 5 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 6 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 7 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 8 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 9 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 10 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 11 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 12 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 13 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 14 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 15 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 16 SELECT COUNT(*) FROM t3; COUNT(*) 16 @@ -5764,15 +5764,15 @@ AND NOT FIND_IN_SET('ascii',type3) AND NOT FIND_IN_SET('mb2',type3) ORDER BY b; Warnings: -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 1 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 2 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 3 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 4 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 5 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 6 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 7 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 8 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 9 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 1 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 2 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 3 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 4 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 5 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 6 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 7 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 8 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 9 SELECT COUNT(*) FROM t3; COUNT(*) 9 @@ -5848,28 +5848,28 @@ DELETE FROM t2 WHERE b IN (SELECT b FROM t3); DELETE FROM t3; INSERT IGNORE INTO t3 (b,c,comment) SELECT b,b,comment FROM t2 ORDER BY b; Warnings: -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 1 -Warning 1366 Incorrect string value: '\xA3' for column 'c' at row 3 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 5 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 6 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 7 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 9 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 10 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 12 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 13 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 15 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 16 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 18 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 19 -Warning 1366 Incorrect string value: '\xA3' for column 'c' at row 27 -Warning 1366 Incorrect string value: '\x80' for column 'c' at row 30 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 31 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 35 -Warning 1366 Incorrect string value: '\xA3' for column 'c' at row 37 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 39 -Warning 1366 Incorrect string value: '\xA3' for column 'c' at row 41 -Warning 1366 Incorrect string value: '\x81' for column 'c' at row 43 -Warning 1366 Incorrect string value: '\xA3' for column 'c' at row 45 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 1 +Warning 1366 Incorrect string value: '\xA3' for column 'test.t3.c' at row 3 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 5 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 6 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 7 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 9 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 10 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 12 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 13 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 15 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 16 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 18 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 19 +Warning 1366 Incorrect string value: '\xA3' for column 'test.t3.c' at row 27 +Warning 1366 Incorrect string value: '\x80' for column 'test.t3.c' at row 30 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 31 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 35 +Warning 1366 Incorrect string value: '\xA3' for column 'test.t3.c' at row 37 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 39 +Warning 1366 Incorrect string value: '\xA3' for column 'test.t3.c' at row 41 +Warning 1366 Incorrect string value: '\x81' for column 'test.t3.c' at row 43 +Warning 1366 Incorrect string value: '\xA3' for column 'test.t3.c' at row 45 SELECT COUNT(*) FROM t3; COUNT(*) 46 diff --git a/mysql-test/r/ctype_latin1.result b/mysql-test/r/ctype_latin1.result index 9899342..4d496c7 100644 --- a/mysql-test/r/ctype_latin1.result +++ b/mysql-test/r/ctype_latin1.result @@ -7987,12 +7987,12 @@ SET NAMES utf8; CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1); INSERT IGNORE INTO t1 VALUES ('�'),('�#'); Warnings: -Warning 1366 Incorrect string value: '\xC2' for column 'a' at row 1 -Warning 1366 Incorrect string value: '\xC2#' for column 'a' at row 2 +Warning 1366 Incorrect string value: '\xC2' for column 'test.t1.a' at row 1 +Warning 1366 Incorrect string value: '\xC2#' for column 'test.t1.a' at row 2 SHOW WARNINGS; Level Code Message -Warning 1366 Incorrect string value: '\xC2' for column 'a' at row 1 -Warning 1366 Incorrect string value: '\xC2#' for column 'a' at row 2 +Warning 1366 Incorrect string value: '\xC2' for column 'test.t1.a' at row 1 +Warning 1366 Incorrect string value: '\xC2#' for column 'test.t1.a' at row 2 SELECT HEX(a),a FROM t1; HEX(a) a 3F ? diff --git a/mysql-test/r/ctype_many.result b/mysql-test/r/ctype_many.result index d73a478..ce05015 100644 --- a/mysql-test/r/ctype_many.result +++ b/mysql-test/r/ctype_many.result @@ -1767,8 +1767,8 @@ CREATE TABLE t2 (a VARCHAR(10) CHARACTER SET ucs2); INSERT INTO t1 VALUES (0x10082), (0x12345); INSERT IGNORE INTO t2 SELECT * FROM t1; Warnings: -Warning 1366 Incorrect string value: '\x00\x01\x00\x82' for column 'a' at row 1 -Warning 1366 Incorrect string value: '\x00\x01\x23\x45' for column 'a' at row 2 +Warning 1366 Incorrect string value: '\x00\x01\x00\x82' for column 'test.t2.a' at row 1 +Warning 1366 Incorrect string value: '\x00\x01\x23\x45' for column 'test.t2.a' at row 2 SELECT HEX(a) FROM t2; HEX(a) 003F diff --git a/mysql-test/r/ctype_recoding.result b/mysql-test/r/ctype_recoding.result index 806d9dc..40c67ad 100644 --- a/mysql-test/r/ctype_recoding.result +++ b/mysql-test/r/ctype_recoding.result @@ -171,8 +171,8 @@ create table t1 (a char(10) character set koi8r, b text character set koi8r); insert into t1 values ('test','test'); insert ignore into t1 values ('����','����'); Warnings: -Warning 1366 Incorrect string value: '\xCA\xC3\xD5\xCB' for column 'a' at row 1 -Warning 1366 Incorrect string value: '\xCA\xC3\xD5\xCB' for column 'b' at row 1 +Warning 1366 Incorrect string value: '\xCA\xC3\xD5\xCB' for column 'test.t1.a' at row 1 +Warning 1366 Incorrect string value: '\xCA\xC3\xD5\xCB' for column 'test.t1.b' at row 1 drop table t1; set names koi8r; create table t1 (a char(10) character set cp1251); diff --git a/sql/field.cc b/sql/field.cc index caa84dc..5a97deb 100644 --- a/sql/field.cc +++ b/sql/field.cc @@ -8599,6 +8599,24 @@ int Field_geom::store_decimal(const my_decimal *) } +static char *long_field_name(char *buf, size_t buf_len, + const TABLE_SHARE *s, const char *field_name) +{ + bool is_temp= !s|| + (tmp_file_prefix_length < s->table_name.length && + memcmp(s->table_name.str, + tmp_file_prefix, tmp_file_prefix_length) == 0); + + if (is_temp) + strxnmov(buf, buf_len, "{temporary}.", field_name, NullS); + else + strxnmov(buf, buf_len, + s->db.str, ".", s->table_name.str, ".", field_name, NullS); + + return buf; +} + + int Field_geom::store(const char *from, uint length, CHARSET_INFO *cs) { if (!length) @@ -8620,10 +8638,11 @@ int Field_geom::store(const char *from, uint length, CHARSET_INFO *cs) geom_type != Field::GEOM_GEOMETRYCOLLECTION && (uint32) geom_type != wkb_type) { + char buf[193]; my_error(ER_TRUNCATED_WRONG_VALUE_FOR_FIELD, MYF(0), Geometry::ci_collection[geom_type]->m_name.str, Geometry::ci_collection[wkb_type]->m_name.str, - field_name, + long_field_name(buf, sizeof(buf), table->s, field_name), (ulong) table->in_use->get_stmt_da()-> current_row_for_warning()); goto err_exit; @@ -10787,7 +10806,11 @@ void Field::set_datetime_warning(Sql_condition::enum_warning_level level, { THD *thd= get_thd(); if (thd->really_abort_on_warning() && level >= Sql_condition::WARN_LEVEL_WARN) - make_truncated_value_warning(thd, level, str, ts_type, field_name); + { + char buf[193]; + make_truncated_value_warning(thd, level, str, ts_type, + long_field_name(buf, sizeof(buf), table->s, field_name)); + } else set_warning(level, code, cuted_increment); } @@ -10797,10 +10820,13 @@ void Field::set_warning_truncated_wrong_value(const char *type_arg, const char *value) { THD *thd= get_thd(); + char buf[193]; + push_warning_printf(thd, Sql_condition::WARN_LEVEL_WARN, ER_TRUNCATED_WRONG_VALUE_FOR_FIELD, ER_THD(thd, ER_TRUNCATED_WRONG_VALUE_FOR_FIELD), - type_arg, value, field_name, + type_arg, value, + long_field_name(buf, sizeof(buf), table->s, field_name), static_cast<ulong>(thd->get_stmt_da()-> current_row_for_warning())); }