Debian Codegraph @

mysql-test/suite/rpl/t/rpl_row_utf32.test

raw
1 --source include/not_group_replication_plugin.inc
2 -- source include/have_binlog_format_row.inc
3 -- source include/master-slave.inc
4
5 # Max key length in InnoDB is 3072, whereas, in MyISAM it is 1000 # WL#6921
6 --let $key_length_innodb=3072
7
8 #
9 # BUG#51787 Assertion `(n % 4) == 0' on slave upon INSERT into a table with UTF32
10 #
11
12 SET SQL_LOG_BIN=0;
13 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
14 --replace_result $key_length_innodb 1000
15 CREATE TABLE t1 (c1 char(255) DEFAULT NULL, KEY c1 (c1))
16 ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf32;
17 SET sql_mode = default;
18 SET SQL_LOG_BIN=1;
19
20 -- connection slave
21
22 SET @saved_replica_type_conversions= @@global.replica_type_conversions;
23
24 #
25 # Force test to cover conversion execution path in the
26 # slave, which also makes use of sql_type method, thence
27 # can ultimately trigger the assertion.
28 #
29 -- source include/stop_slave.inc
30 SET GLOBAL REPLICA_TYPE_CONVERSIONS='ALL_NON_LOSSY';
31 -- source include/start_slave.inc
32
33 SET SQL_LOG_BIN=0;
34 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
35 --replace_result $key_length_innodb 1000
36 CREATE TABLE t1 ( c1 varchar(255) DEFAULT NULL, KEY c1 (c1))
37 ROW_FORMAT=DYNAMIC DEFAULT CHARSET=utf32;
38 SET sql_mode = default;
39 SET SQL_LOG_BIN=1;
40
41 -- connection master
42
43 INSERT INTO t1(c1) VALUES ('insert into t1');
44 DROP TABLE t1;
45
46 --source include/sync_slave_sql_with_master.inc
47
48 # assertion: the slave woul hit an/several assertions:
49 # before and during slave conversion procedure
50 # Now that is fixed, it wont.
51
52 SET GLOBAL REPLICA_TYPE_CONVERSIONS= @saved_replica_type_conversions;
53 -- source include/stop_slave.inc
54 -- source include/start_slave.inc
55 -- connection master
56 --source include/rpl_end.inc