ndb_autodiscover3.result 1.19 KB
Newer Older
1
drop table if exists t1, t2;
2 3 4 5
create table t1 (a int key) engine=ndbcluster;
begin;
insert into t1 values (1);
insert into t1 values (2);
6
ERROR HY000: Got temporary error 4025 'Node failure caused abort of transaction' from NDBCLUSTER
7
commit;
8
ERROR HY000: Got error 4350 'Transaction already aborted' from NDBCLUSTER
9
drop table t1;
10 11 12 13 14 15 16
create table t2 (a int, b int, primary key(a,b)) engine=ndbcluster;
insert into t2 values (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1);
select * from t2 order by a limit 3;
a	b
1	1
2	1
3	1
17 18
select * from t2;
ERROR 42S02: Table 'test.t2' doesn't exist
19 20
show tables like 't2';
Tables_in_test (t2)
21
reset master;
22 23 24 25 26 27 28 29 30 31 32 33
create table t2 (a int key) engine=ndbcluster;
insert into t2 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
select * from t2 order by a limit 3;
a
1
2
3
select * from t2 order by a limit 3;
a
1
2
3
34
reset master;
35 36
select * from t2;
ERROR 42S02: Table 'test.t2' doesn't exist
37 38
show tables like 't2';
Tables_in_test (t2)
39
reset master;
40 41 42 43 44 45 46 47 48 49 50 51
create table t2 (a int key) engine=ndbcluster;
insert into t2 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
select * from t2 order by a limit 3;
a
1
2
3
select * from t2 order by a limit 3;
a
1
2
3
52
reset master;
53
drop table t2;