show variables like 'log_bin';
Variable_name	Value
log_bin	ON
show variables like 'log_bin';
Variable_name	Value
log_bin	ON
show variables like 'log_bin';
Variable_name	Value
log_bin	OFF
show variables like 'log_bin';
Variable_name	Value
log_bin	OFF
create table t1 (a int) engine=ndbcluster;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
rename table t1 to t2;
drop table t2;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
rename table t1 to t2;
drop table t2;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
alter table t1 algorithm=copy, add column b int default 77;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
alter table t1 algorithm=copy, add column b int default 77;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int primary key) engine=ndbcluster
partition by list(a) (partition p0 values in (0));
alter table t1 algorithm=copy, add partition (partition p1 values in (1));
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int primary key) engine=ndbcluster
partition by list(a) (partition p0 values in (0));
alter table t1 algorithm=copy, add partition (partition p1 values in (1));
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int primary key) engine=ndbcluster;
alter table t1 algorithm=inplace, add column b int column_format dynamic;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int primary key) engine=ndbcluster;
alter table t1 algorithm=copy, add column b int column_format dynamic;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
create table t2 (a int) engine=ndbcluster;
rename table t1 to tmp, t2 to t1, tmp to t2;
drop table t1, t2;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
create table t2 (a int) engine=ndbcluster;
rename table t1 to tmp, t2 to t1, tmp to t2;
drop table t1, t2;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=innodb;
create table t1 (a int) engine=innodb;
create table t1 (a int) engine = ndb;
Warnings:
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
drop table t1;
Warnings:
Warning	1296	Node <nodeid> 'Distribution of DROP TABLE 't1' failed'
Warning	1296	Node <nodeid> 'Distribution of DROP TABLE 't1' failed'
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine = ndb;
Warnings:
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
drop table t1;
Warnings:
Warning	1296	Node <nodeid> 'Distribution of DROP TABLE 't1' failed'
Warning	1296	Node <nodeid> 'Distribution of DROP TABLE 't1' failed'
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine = ndb;
Warnings:
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
drop table t1;
select * from t1 /* force discovery */;
a
drop table t1;
select * from t1 /* force discovery */;
a
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=innodb;
create table t1 (a int) engine=innodb;
create table t1 (a int) engine = ndb;
Warnings:
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
alter table t1 algorithm=copy, add column b int column_format dynamic;
Warnings:
Warning	1296	Node <nodeid> 'Distribution of ALTER TABLE 't1' failed'
Warning	1296	Node <nodeid> 'Distribution of ALTER TABLE 't1' failed'
drop table t1;
select * from t1 /* force discovery */;
a	b
drop table t1;
select * from t1 /* force discovery */;
a	b
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=innodb;
create table t1 (a int) engine=innodb;
create table t1 (a int primary key) engine = ndb;
Warnings:
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
alter table t1 algorithm=inplace, add column b int column_format dynamic;
Warnings:
Warning	1296	Node <nodeid> 'Distribution of ALTER TABLE 't1' failed'
Warning	1296	Node <nodeid> 'Distribution of ALTER TABLE 't1' failed'
drop table t1;
select * from t1 /* force discovery */;
a	b
drop table t1;
select * from t1 /* force discovery */;
a	b
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=innodb;
create table t1 (a int) engine=innodb;
create table t1 (a int) engine = ndb;
Warnings:
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
Warning	1296	Node <nodeid> 'Distribution of CREATE TABLE 't1' failed'
rename table t1 to t2;
select * from t2 /* force discovery */;
a
select * from t2 /* force discovery */;
a
drop table t2;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
drop table t1;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
create table if not exists t1 (a int) engine=ndbcluster;
drop table t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
drop table if exists t1;
drop table if exists t1;
drop table if exists t1;
drop table if exists t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
drop table if exists t1;
drop table if exists t1;
drop table if exists t1;
drop table if exists t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
drop table if exists t1;
drop table if exists t1;
drop table if exists t1;
drop table if exists t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
drop table if exists t1;
drop table if exists t1;
drop table if exists t1;
drop table if exists t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
drop table if exists t1;
drop table if exists t1;
drop table if exists t1;
drop table if exists t1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
create table t2 (a int) engine=ndbcluster;
select * from t1 /* force discovery */;
a
select * from t2 /* force discovery */;
a
select * from t1 /* force discovery */;
a
select * from t2 /* force discovery */;
a
select * from t1 /* force discovery */;
a
select * from t2 /* force discovery */;
a
select * from t1 /* force discovery */;
a
select * from t2 /* force discovery */;
a
drop table t1, t2;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
create table t1 (a int) engine=ndbcluster;
create table t2 (a int) engine=ndbcluster;
select * from t1 /* force discovery */;
ERROR 42S02: Table 'test.t1' doesn't exist
select * from t2 /* force discovery */;
ERROR 42S02: Table 'test.t2' doesn't exist
select * from t1 /* force discovery */;
ERROR 42S02: Table 'test.t1' doesn't exist
select * from t2 /* force discovery */;
ERROR 42S02: Table 'test.t2' doesn't exist
select * from t1 /* force discovery */;
ERROR 42S02: Table 'test.t1' doesn't exist
select * from t2 /* force discovery */;
ERROR 42S02: Table 'test.t2' doesn't exist
select * from t1 /* force discovery */;
ERROR 42S02: Table 'test.t1' doesn't exist
select * from t2 /* force discovery */;
ERROR 42S02: Table 'test.t2' doesn't exist
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;
set global ndb_dbg_check_shares=1;