Debian Codegraph @

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

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