Debian Codegraph @

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

raw
1 use test;
2 Create a table with some heavy indexing
3 create table t1 (a int primary key, b int, c varchar(100), d int,
4 key (a,b,c,d),
5 key (b,a),
6 key (b,c),
7 key (b,d),
8 key (c,a),
9 key (c,d),
10 key (d,c,b,a),
11 key (c,b,a),
12 key (c,b,a,d),
13 key (b,a,d,c),
14 key (a,d,c,b))
15 engine = ndb;
16 Insert some rows
17 select count(1) from test.t1;
18 count(1)
19 48192
20 Generate a backup
21 drop table test.t1;
22 Restore with offline (parallel) rebuild
23 drop table test.t1;
24 Test that exclude-missing-tables does not exclude tables in rewritten databases
25 create database dbfrom;
26 use dbfrom;
27 create table t1(id int primary key, val int unique) engine=ndb;
28 insert into t1 values (1,1), (2,2), (3,3), (4,4), (5,5);
29 drop table t1;
30 drop database dbfrom;
31 create database dbto;
32 use dbto;
33 select * from t1 order by id;
34 id val
35 1 1
36 2 2
37 3 3
38 4 4
39 5 5
40 drop database dbto;