1 files changed, 34 insertions, 0 deletions
diff --git a/mysql-test/main/invisible_binlog.test b/mysql-test/main/invisible_binlog.test
new file mode 100644
index 00000000..11b4be3a
--- /dev/null
+++ b/mysql-test/main/invisible_binlog.test
@@ -0,0 +1,34 @@
+--source include/master-slave.inc
+
+--disable_service_connection
+--connection master
+create table t1(a int , b int invisible);
+insert into t1 values(1);
+insert into t1(a,b) values(2,2);
+select a,b from t1;
+desc t1;
+
+create table t2(a int , b int invisible default 5);
+insert into t2 values(1);
+insert into t2(a,b) values(2,2);
+select a,b from t2;
+desc t2;
+
+
+--sync_slave_with_master
+select * from t1;
+select a,b from t1;
+desc t1;
+show create table t1;
+
+select * from t2;
+select a,b from t2;
+desc t2;
+show create table t2;
+
+
+--connection master
+drop table t1,t2;
+
+--source include/rpl_end.inc
+--enable_service_connection