################################################################################
# WL10905 - Support for INVISIBLE columns.                                     #
#                                                                              #
# Test case verify that the contents of a table is preserved in replication,   #
# even if the table has an invisible column.                                   #
################################################################################
--source include/master-slave.inc

CREATE TABLE t1 (f1 INT PRIMARY KEY AUTO_INCREMENT INVISIBLE,
                 f2 INT INVISIBLE DEFAULT 5, f3 INT);
SHOW CREATE TABLE t1;
INSERT INTO t1 VALUES (10), (20);

--source include/sync_slave_sql_with_master.inc

--echo # check that t1 exists and has same values in both servers.
--let $diff_tables=master:t1, slave:t1
--source include/diff_tables.inc

--source include/rpl_connection_master.inc
DROP TABLE t1;

--source include/rpl_reset.inc
--source include/rpl_end.inc