Debian Codegraph @

mysql-test/suite/ndb/r/ndb_import2.result

raw
1 # large ndb_import tests
2 # node failure test
3 create table t1 (
4 a int not null,
5 b int not null,
6 primary key using hash (a)
7 ) engine ndb;
8 create table t1ver like t1;
9 create table t2 (
10 b int not null,
11 # unique key would turn into pk
12 key (b)
13 ) engine ndb;
14 create table t2ver like t2;
15 # load t1ver, t2ver
16 # import t1, t2
17 Waiting for started
18 # verify t1, t2
19 select count(*) from t1;
20 count(*)
21 400000
22 select count(*) from t1ver;
23 count(*)
24 400000
25 select count(*) from t1 x, t1ver y
26 where x.a = y.a and x.b = y.b;
27 count(*)
28 400000
29 select count(*) from t2;
30 count(*)
31 400000
32 select count(*) from t2ver;
33 count(*)
34 400000
35 select count(*) from t2 x, t2ver y
36 where x.b = y.b;
37 count(*)
38 400000
39 drop table t1, t1ver, t2, t2ver;