1 drop table if exists t1;
3 set character_set_database = cp932;
5 CREATE TABLE t1(f1 blob);
6 PREPARE stmt1 FROM 'INSERT INTO t1 VALUES(?)';
8 EXECUTE stmt1 USING @var1;
9 show binlog events from <binlog_start>;
10 Log_name Pos Event_type Server_id End_log_pos Info
11 master-bin.000001 # Query # # use `test`; CREATE TABLE t1(f1 blob)
12 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES(0x8300)
13 SELECT HEX(f1) FROM t1;
17 CREATE TABLE t4 (s1 CHAR(50) CHARACTER SET latin1,
18 s2 CHAR(50) CHARACTER SET cp932,
20 CREATE PROCEDURE bug18293 (IN ins1 CHAR(50),
21 IN ins2 CHAR(50) CHARACTER SET cp932,
24 INSERT INTO t4 VALUES (ins1, ins2, ind);
26 CALL bug18293("Foo's a Bar", _cp932 0xED40ED41ED42, 47.93)|
27 SELECT HEX(s1),HEX(s2),d FROM t4|
29 466F6F2773206120426172 ED40ED41ED42 47.93
30 DROP PROCEDURE bug18293|
32 show binlog events from <binlog_start>|
33 Log_name Pos Event_type Server_id End_log_pos Info
34 master-bin.000001 # Query # # use `test`; CREATE TABLE t4 (s1 CHAR(50) CHARACTER SET latin1,
35 s2 CHAR(50) CHARACTER SET cp932,
37 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `bug18293`(IN ins1 CHAR(50),
38 IN ins2 CHAR(50) CHARACTER SET cp932,
41 INSERT INTO t4 VALUES (ins1, ins2, ind);
43 master-bin.000001 # Query # # use `test`; INSERT INTO t4 VALUES ( NAME_CONST('ins1',_latin1 0x466F6F2773206120426172 COLLATE 'latin1_swedish_ci'), NAME_CONST('ins2',_cp932 0xED40ED41ED42 COLLATE 'cp932_japanese_ci'), NAME_CONST('ind',47.93))
44 master-bin.000001 # Query # # use `test`; DROP PROCEDURE bug18293
45 master-bin.000001 # Query # # use `test`; DROP TABLE t4
47 call mtr.add_suppression("Error in Log_event::read_log_event\\\(\\\): 'Sanity check failed', data_len: 258, event_type: 49");
48 SHOW BINLOG EVENTS FROM 365;
49 ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Wrong offset or I/O error
50 Bug#44352 UPPER/LOWER function doesn't work correctly on cp932 and sjis environment.
51 CREATE TABLE t1 (a varchar(16)) character set cp932;
52 INSERT INTO t1 VALUES (0x8372835E),(0x8352835E);
53 SELECT hex(a), hex(lower(a)), hex(upper(a)) FROM t1 ORDER BY binary(a);
54 hex(a) hex(lower(a)) hex(upper(a))
55 8352835E 8352835E 8352835E
56 8372835E 8372835E 8372835E