Debian Codegraph @

mysql-test/suite/rpl_nogtid/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 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
11 connection master;
12 --echo #After the patch, the display width is set to a default
13 --echo #value of 21.
14 CREATE TABLE t1 AS SELECT REPEAT('A', 1000) DIV 1 AS a;
15 SHOW CREATE TABLE t1;
16
17 CREATE TABLE t2 AS SELECT CONVERT(REPEAT('A', 255) USING UCS2) DIV 1 AS a;
18 SHOW CREATE TABLE t2;
19
20 --echo #After the patch, no error is reported.
21 sync_slave_with_master;
22
23 connection master;
24 DROP TABLE t1;
25 DROP TABLE t2;
26 SET sql_mode = default;
27 --source include/rpl_end.inc