Debian Codegraph @

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

raw
1 ################################################################################
2 # WL10905 - Support for INVISIBLE columns. #
3 # #
4 # Test case verify that the contents of a table is preserved in replication, #
5 # even if the table has an invisible column. #
6 ################################################################################
7 --source include/master-slave.inc
8
9 CREATE TABLE t1 (f1 INT PRIMARY KEY AUTO_INCREMENT INVISIBLE,
10 f2 INT INVISIBLE DEFAULT 5, f3 INT);
11 SHOW CREATE TABLE t1;
12 INSERT INTO t1 VALUES (10), (20);
13
14 --source include/sync_slave_sql_with_master.inc
15
16 --echo # check that t1 exists and has same values in both servers.
17 --let $diff_tables=master:t1, slave:t1
18 --source include/diff_tables.inc
19
20 --source include/rpl_connection_master.inc
21 DROP TABLE t1;
22
23 --source include/rpl_reset.inc
24 --source include/rpl_end.inc