339 lines
12 KiB
Plaintext
339 lines
12 KiB
Plaintext
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;
|