Debian Codegraph @

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

raw
1 --source include/have_binlog_format_mixed.inc
2 --source include/master-slave.inc
3
4 --echo #
5 --echo # MDEV-16229 Replication aborts with ER_VIEW_SELECT_TMPTABLE after
6 --echo # half-failed RENAME
7 --echo #
8
9 CREATE TABLE t1 (a INT);
10 CREATE TEMPORARY TABLE t1 (b INT);
11 RENAME TABLE t1 TO tmp, tmp TO t1;
12 SHOW CREATE TABLE t1;
13 --error ER_VIEW_SELECT_TMPTABLE
14 CREATE VIEW v AS SELECT * FROM t1;
15
16 RENAME TABLE t1 TO tmp, t1 TO t2;
17 SHOW CREATE TABLE tmp;
18 SHOW CREATE TABLE t2;
19 --error ER_VIEW_SELECT_TMPTABLE
20 CREATE VIEW v AS SELECT * FROM tmp;
21 CREATE VIEW v AS SELECT * FROM t2;
22
23 --sync_slave_with_master
24
25 # Cleanup
26
27 --connection master
28
29 DROP VIEW v;
30 DROP TABLE tmp;
31 DROP TABLE t2;
32
33 --source include/rpl_end.inc