Debian Codegraph @

mysql-test/suite/ndb/t/ndb_restore_schema_blobs.test

raw
1 ######################################################################
2 # Test restoring backups with blob columns
3 ######################################################################
4
5 -- source include/have_ndb.inc
6 -- source suite/ndb/include/backup_restore_setup.inc
7
8 --disable_warnings
9 use test;
10 drop table if exists t1,t2;
11 --enable_warnings
12
13 # length 61
14 set @s0 = 'rggurloniukyehuxdbfkkyzlceixzrehqhvxvxbpwizzvjzpucqmzrhzxzfau';
15 set @s1 = 'ykyymbzqgqlcjhlhmyqelfoaaohvtbekvifukdtnvcrrjveevfakxarxexomz';
16 set @s2 = 'dbnfqyzgtqxalcrwtfsqabknvtfcbpoonxsjiqvmhnfikxxhcgoexlkoezvah';
17
18 set @v1 = repeat(@s0, 100); # 1d42dd9090cf78314a06665d4ea938c35cc760f4
19 set @v2 = repeat(@s1, 200); # 10d3c783026b310218d10b7188da96a2401648c6
20 set @v3 = repeat(@s2, 300); # a33549d9844092289a58ac348dd59f09fc28406a
21 set @v4 = repeat(@s0, 400); # daa61c6de36a0526f0d47dc29d6b9de7e6d2630c
22 set @v5 = repeat(@s1, 500); # 70fc9a7d08beebc522258bfb02000a30c77a8f1d
23 set @v6 = repeat(@s2, 600); # 090565c580809efed3d369481a4bbb168b20713e
24
25 create table t1 (
26 a int auto_increment,
27 b text,
28 primary key (a)
29 )
30 engine ndbcluster;
31
32 insert into t1(b) values(@v1);
33 insert into t1(b) values(@v2);
34 insert into t1(b) values(@v3);
35
36 create table t2 (
37 a text,
38 b varchar(8),
39 c mediumblob,
40 d int,
41 e tinyblob,
42 f varchar(2),
43 primary key (b, d, f)
44 )
45 engine ndbcluster;
46
47 insert into t2 values(@v1, 'a', @v2, 1, 'xx1', 'u');
48 insert into t2 values(@v3, 'a', @v4, 1, 'yy1', 'v');
49 insert into t2 values(@v5, 'a', @v6, 2, 'zz1', 'v');
50 insert into t2 values(@v1, 'abc', @v2, 1, 'xx2', 'u');
51 insert into t2 values(@v3, 'abc', @v4, 1, 'yy2', 'v');
52 insert into t2 values(@v5, 'abc', @v6, 2, 'zz2', 'v');
53 insert into t2 values(@v1, 'abcdefgh', @v2, 1, 'xx3', 'u');
54 insert into t2 values(@v3, 'abcdefgh', @v4, 1, 'yy3', 'v');
55 insert into t2 values(@v5, 'abcdefgh', @v6, 2, 'zz3', 'v');
56
57 # grmbl
58 # select TABLE_NAME,ENGINE from INFORMATION_SCHEMA.TABLES
59 # where TABLE_SCHEMA = 'test' and TABLE_NAME in ('t1','t2');
60
61 select a, sha1(b) from t1 order by a;
62 select sha1(a), sha1(c), e from t2 order by b, d, f;
63
64 --source include/ndb_backup.inc
65 drop table t1, t2;
66 --exec $NDB_RESTORE -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
67 --exec $NDB_RESTORE -b $the_backup_id -n 2 -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
68
69 select a, sha1(b) from t1 order by a;
70 select sha1(a), sha1(c), e from t2 order by b, d, f;
71
72 drop table t1,t2;
73
74 # same on disk
75
76 create logfile group lg1 add undofile 'undofile.dat'
77 initial_size 16M undo_buffer_size 1M engine=ndb;
78 create tablespace ts1 add datafile 'datafile.dat'
79 use logfile group lg1 initial_size 64M engine=ndb;
80
81 create table t1 (
82 a int,
83 b text,
84 primary key (a)
85 )
86 tablespace ts1 storage disk
87 engine ndbcluster;
88
89 insert into t1 values(1, @v1);
90 insert into t1 values(2, @v2);
91 insert into t1 values(3, @v3);
92
93 create table t2 (
94 a text,
95 b varchar(8),
96 c mediumblob,
97 d int,
98 e tinyblob,
99 f varchar(2),
100 primary key (b, d, f)
101 )
102 tablespace ts1 storage disk
103 engine ndbcluster;
104
105 insert into t2 values(@v1, 'a', @v2, 1, 'xx1', 'u');
106 insert into t2 values(@v3, 'a', @v4, 1, 'yy1', 'v');
107 insert into t2 values(@v5, 'a', @v6, 2, 'zz1', 'v');
108 insert into t2 values(@v1, 'abc', @v2, 1, 'xx2', 'u');
109 insert into t2 values(@v3, 'abc', @v4, 1, 'yy2', 'v');
110 insert into t2 values(@v5, 'abc', @v6, 2, 'zz2', 'v');
111 insert into t2 values(@v1, 'abcdefgh', @v2, 1, 'xx3', 'u');
112 insert into t2 values(@v3, 'abcdefgh', @v4, 1, 'yy3', 'v');
113 insert into t2 values(@v5, 'abcdefgh', @v6, 2, 'zz3', 'v');
114
115 # grmbl
116 # select TABLE_NAME,ENGINE from INFORMATION_SCHEMA.TABLES
117 # where TABLE_SCHEMA = 'test' and TABLE_NAME in ('t1','t2');
118
119 select a, sha1(b) from t1 order by a;
120 select sha1(a), sha1(c), e from t2 order by b, d, f;
121
122 --source include/ndb_backup.inc
123 drop table t1, t2;
124 --exec $NDB_RESTORE -d -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
125 --exec $NDB_RESTORE -d -b $the_backup_id -n 2 -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
126
127 select a, sha1(b) from t1 order by a;
128 select sha1(a), sha1(c), e from t2 order by b, d, f;
129
130 drop table t1,t2;
131
132 alter tablespace ts1 drop datafile 'datafile.dat';
133 drop tablespace ts1;
134 drop logfile group lg1 engine=ndb;
135 --source suite/ndb/include/backup_restore_cleanup.inc
136 --remove_file $NDB_TOOLS_OUTPUT