1
drop table if exists t1, t2, t3, t4;
3
drop table if exists t1, t2, t3, t4;
5
create table t1 (a int) engine=ndbcluster;
6
create table t2 (a int) engine=ndbcluster;
7
insert into t1 value (2);
8
insert into t2 value (3);
15
show status like 'handler_discover%';
22
create table t1 (a int) engine=ndbcluster;
23
insert into t1 value (2);
27
show status like 'handler_discover%';
31
create table t1 (a int) engine=ndbcluster;
32
insert into t1 value (2);
43
update t1 set a=3 where a=2;
44
show status like 'handler_discover%';
47
create table t3 (a int not null primary key, b varchar(22),
48
c int, last_col text) engine=ndb;
49
insert into t3 values(1, 'Hi!', 89, 'Longtext column');
50
create table t4 (pk int primary key, b int) engine=ndb;
56
1 Hi! 89 Longtext column
57
show tables like 't4';
66
drop table t1, t2, t3, t4;
67
create table t1(c1 int key)ENGINE=MyISAM;
68
insert into t1 values(1),(3),(5);
69
select * from t1 order by c1;
76
create table t1(c1 int key)ENGINE=MyISAM;
77
insert into t1 values(100),(344),(533);
78
select * from t1 order by c1;
83
alter table t1 engine=ndb;
88
Warning 1050 Local table test.t1 shadows ndb table
89
select * from t1 order by c1;
95
select * from t1 order by c1;
103
create table t1(x int) engine=ndb;
110
ERROR 42000: Unknown database 'db'
113
create table t1(x int) engine=ndb;
115
create table t2(x int) engine=myisam;
126
create table `test`.`t1$EX`
127
(server_id int unsigned,
128
master_server_id int unsigned,
129
master_epoch bigint unsigned,
131
primary key(server_id, master_server_id,
132
master_epoch, count))
134
show tables like '%$%';
138
show tables like '%$%';
141
drop table `test`.`t1$EX`;
142
show tables like '%$%';
144
show tables like '%$%';