Debian Codegraph @

mysql-test/suite/ndb/t/ndb_rb_fragment_count_desc.test

raw
1 -- source include/have_ndb.inc
2
3 # Turn on ndb_read_backup for this test since it tests
4 # the ndb_read_backup functionality
5 set @save_ndb_read_backup = @@global.ndb_read_backup;
6 set @@global.ndb_read_backup = ON;
7
8 create table t1 (a bigint, primary key (a)) engine=ndb;
9 show create table t1;
10 drop table t1;
11
12 create table t1 (a bigint, primary key (a)) engine=ndb
13 comment="junk";
14 show create table t1;
15
16 create table t2 (a bigint, primary key (a)) engine=ndb
17 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
18 show create table t2;
19 drop table t2;
20
21 create table t2 (a bigint, primary key (a)) engine=ndb
22 comment="before NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM after";
23 show create table t2;
24
25 create table t3 (a bigint, primary key (a)) engine=ndb
26 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM";
27 show create table t3;
28
29 create table t4 (a bigint, primary key (a)) engine=ndb
30 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_NODE";
31 show create table t4;
32
33 create table t5 (a bigint, primary key (a)) engine=ndb
34 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
35 show create table t5;
36
37 --let $ndb_describe_table= t1
38 --source suite/ndb/include/ndb_describe_table.inc
39 --let $ndb_describe_table= t2
40 --source suite/ndb/include/ndb_describe_table.inc
41 --let $ndb_describe_table= t3
42 --source suite/ndb/include/ndb_describe_table.inc
43 --let $ndb_describe_table= t4
44 --source suite/ndb/include/ndb_describe_table.inc
45 --let $ndb_describe_table= t5
46 --source suite/ndb/include/ndb_describe_table.inc
47
48 drop table t1, t2, t3, t4, t5;
49
50 # Restore ndb_read_backup value
51 set @@global.ndb_read_backup = @save_ndb_read_backup;
52
53 set @save_ndb_fully_replicated = @@global.ndb_fully_replicated;
54 set @@global.ndb_fully_replicated = ON;
55
56 create table t1 (a bigint, primary key (a)) engine=ndb;
57 show create table t1;
58 drop table t1;
59
60 create table t1 (a bigint, primary key (a)) engine=ndb
61 comment="junk";
62 show create table t1;
63
64 create table t2 (a bigint, primary key (a)) engine=ndb
65 comment="before NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM after";
66 show create table t2;
67
68 create table t5 (a bigint, primary key (a)) engine=ndb
69 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
70 show create table t5;
71
72 drop table t1, t2, t5;
73
74 # Restore ndb_fully_replicated value
75 set @@global.ndb_fully_replicated = @save_ndb_fully_replicated;