Debian Codegraph @

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

raw
1 # Testing table creations for row-based replication.
2
3 --source include/have_binlog_format_row.inc
4 --source include/master-slave.inc
5
6 --echo #
7 --echo # BUG#17994219: CREATE TABLE .. SELECT PRODUCES INVALID STRUCTURE,
8 --echo # BREAKS RBR
9 --echo #
10
11 connection master;
12 --echo #After the patch, the display width is set to a default
13 --echo #value of 21.
14 SET STATEMENT sql_mode = 'NO_ENGINE_SUBSTITUTION' FOR
15 CREATE TABLE t1 AS SELECT REPEAT('A', 1000) DIV 1 AS a;
16 SHOW CREATE TABLE t1;
17
18 SET STATEMENT sql_mode = 'NO_ENGINE_SUBSTITUTION' FOR
19 CREATE TABLE t2 AS SELECT CONVERT(REPEAT('A', 255) USING UCS2) DIV 1 AS a;
20 SHOW CREATE TABLE t2;
21
22 --echo #After the patch, no error is reported.
23 sync_slave_with_master;
24
25 connection master;
26 DROP TABLE t1;
27 DROP TABLE t2;
28
29 --source include/rpl_end.inc
30