Debian Codegraph @

mysql-test/suite/ndb_binlog/r/ndb_autodiscover3.result

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