From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 14:24:36 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/main/invisible_binlog.test | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 mysql-test/main/invisible_binlog.test (limited to 'mysql-test/main/invisible_binlog.test') 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 -- cgit v1.2.3