68 lines
2.0 KiB
Plaintext
68 lines
2.0 KiB
Plaintext
-- source include/have_ndb.inc
|
|
|
|
# Turn on ndb_read_backup for this test since it tests
|
|
# the ndb_read_backup functionality
|
|
set @save_ndb_read_backup = @@global.ndb_read_backup;
|
|
set @@global.ndb_read_backup = ON;
|
|
|
|
create table t1 (a bigint, primary key (a)) engine=ndb;
|
|
show create table t1;
|
|
drop table t1;
|
|
|
|
create table t1 (a bigint, primary key (a)) engine=ndb
|
|
comment="junk";
|
|
show create table t1;
|
|
|
|
create table t2 (a bigint, primary key (a)) engine=ndb
|
|
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
|
|
show create table t2;
|
|
drop table t2;
|
|
|
|
create table t2 (a bigint, primary key (a)) engine=ndb
|
|
comment="before NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM after";
|
|
show create table t2;
|
|
|
|
create table t3 (a bigint, primary key (a)) engine=ndb
|
|
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM";
|
|
show create table t3;
|
|
|
|
create table t4 (a bigint, primary key (a)) engine=ndb
|
|
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_NODE";
|
|
show create table t4;
|
|
|
|
create table t5 (a bigint, primary key (a)) engine=ndb
|
|
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
|
|
show create table t5;
|
|
|
|
--let ndb_desc_opts= -d test t1 t2 t3 t4 t5
|
|
--source suite/ndb/include/ndb_desc_print.inc
|
|
|
|
drop table t1, t2, t3, t4, t5;
|
|
|
|
# Restore ndb_read_backup value
|
|
set @@global.ndb_read_backup = @save_ndb_read_backup;
|
|
|
|
set @save_ndb_fully_replicated = @@global.ndb_fully_replicated;
|
|
set @@global.ndb_fully_replicated = ON;
|
|
|
|
create table t1 (a bigint, primary key (a)) engine=ndb;
|
|
show create table t1;
|
|
drop table t1;
|
|
|
|
create table t1 (a bigint, primary key (a)) engine=ndb
|
|
comment="junk";
|
|
show create table t1;
|
|
|
|
create table t2 (a bigint, primary key (a)) engine=ndb
|
|
comment="before NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM after";
|
|
show create table t2;
|
|
|
|
create table t5 (a bigint, primary key (a)) engine=ndb
|
|
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
|
|
show create table t5;
|
|
|
|
drop table t1, t2, t5;
|
|
|
|
# Restore ndb_fully_replicated value
|
|
set @@global.ndb_fully_replicated = @save_ndb_fully_replicated;
|