Debian Codegraph @

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

raw
1 --source include/have_ndb.inc
2 --source suite/ndb/include/backup_restore_setup.inc
3
4 --disable_warnings
5 drop table if exists t1, t1sum;
6 --enable_warnings
7
8 select @@session.time_zone;
9 set time_zone = '+00:00';
10 select @@session.time_zone;
11
12 --echo # create query summary table
13 create table t1sum (
14 pk int primary key,
15 cnt int unsigned not null,
16 crc bigint unsigned
17 ) engine=myisam;
18
19 --echo # PART 1: data load and queries
20
21 --echo # create table prec 3
22 --let $prec=(3)
23 --let $frac=.123
24 --source ndb_wl946_create.inc
25 --disable_warnings
26 show create table t1;
27 --enable_warnings
28 --source show_attributes.inc
29 --source show_indexes.inc
30
31 --echo # test defaults
32 insert into t1(a) values (0);
33 select * from t1;
34 delete from t1;
35
36 --echo # load data
37 load data local infile 'suite/ndb/data/wl946_main3.dat'
38 into table t1 fields terminated by ',' lines terminated by '\n';
39
40 --echo # check contents
41 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
42 --echo # verify ndb_select_all
43 --source ndb_wl946_select_all.inc
44
45 --echo # index queries
46 select * from t1 where b = '2011';
47 select * from t1 where c = '2007-12-01';
48 select * from t1 where d = '-13:38:50.785';
49 select * from t1 where e = '8321-12-27 21:08:47.878';
50 select * from t1 where f = '1979-12-28 20:02:06.999';
51 --source ndb_wl946_main_query.inc
52
53 --echo # check results via myisam
54 alter table t1 engine=myisam;
55 show create table t1;
56 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
57 select * from t1 where b = '2011';
58 select * from t1 where c = '2007-12-01';
59 select * from t1 where d = '-13:38:50.785';
60 select * from t1 where e = '8321-12-27 21:08:47.878';
61 select * from t1 where f = '1979-12-28 20:02:06.999';
62 --source ndb_wl946_main_query.inc
63
64 --echo # drop table prec 3
65 drop table t1;
66
67 --echo # create table prec 6
68 --let $prec=(6)
69 --let $frac=.123456
70 --source ndb_wl946_create.inc
71 --disable_warnings
72 show create table t1;
73 --enable_warnings
74 --source show_attributes.inc
75 --source show_indexes.inc
76
77 --echo # test defaults
78 insert into t1(a) values (0);
79 select * from t1;
80 delete from t1;
81
82 --echo # load data
83 load data local infile 'suite/ndb/data/wl946_main6.dat'
84 into table t1 fields terminated by ',' lines terminated by '\n';
85
86 --echo # check contents
87 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
88 --echo # verify ndb_select_all
89 --source ndb_wl946_select_all.inc
90
91 --echo # index queries
92 select * from t1 where b = '1984';
93 select * from t1 where c = '2099-12-21';
94 select * from t1 where d = '15:11:51.840792';
95 select * from t1 where e = '1917-01-19 09:13:16.715589';
96 select * from t1 where f = '2032-03-16 20:53:59.869710';
97 --source ndb_wl946_main_query.inc
98
99 --echo # check results via myisam
100 alter table t1 engine=myisam;
101 show create table t1;
102 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
103 select * from t1 where b = '1984';
104 select * from t1 where c = '2099-12-21';
105 select * from t1 where d = '15:11:51.840792';
106 select * from t1 where e = '1917-01-19 09:13:16.715589';
107 select * from t1 where f = '2032-03-16 20:53:59.869710';
108 --source ndb_wl946_main_query.inc
109
110 --echo # drop table prec 6
111 drop table t1;
112
113 --echo # PART 2: backup and restore
114
115 --echo # create table prec 3
116 --let $prec=(3)
117 --let $frac=.123
118 --source ndb_wl946_create.inc
119 --disable_warnings
120 show create table t1;
121 --enable_warnings
122 --source show_attributes.inc
123 --source show_indexes.inc
124
125 --echo # load data
126 load data local infile 'suite/ndb/data/wl946_main3.dat'
127 into table t1 fields terminated by ',' lines terminated by '\n';
128
129 --echo # run backup
130 --source include/ndb_backup.inc
131 --let backup_id_3 = $the_backup_id
132
133 --echo # drop table prec 3
134 drop table t1;
135
136 --echo # restore meta from backup
137 --exec $NDB_RESTORE -b $backup_id_3 -n 1 -m --print-meta $NDB_BACKUPS-$backup_id_3 >> $NDB_TOOLS_OUTPUT
138 --disable_warnings
139 show create table t1;
140 --enable_warnings
141 --source show_attributes.inc
142 --source show_indexes.inc
143
144 --echo # restore data from backup
145 --exec $NDB_RESTORE -b $backup_id_3 -n 1 -r $NDB_BACKUPS-$backup_id_3 >> $NDB_TOOLS_OUTPUT
146 --exec $NDB_RESTORE -b $backup_id_3 -n 2 -r $NDB_BACKUPS-$backup_id_3 >> $NDB_TOOLS_OUTPUT
147
148 --echo # check contents
149 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
150
151 --echo # drop table prec 3
152 drop table t1;
153
154 --echo # create table prec 6
155 --let $prec=(6)
156 --let $frac=.123456
157 --source ndb_wl946_create.inc
158 --disable_warnings
159 show create table t1;
160 --enable_warnings
161 --source show_attributes.inc
162 --source show_indexes.inc
163
164 --echo # load data
165 load data local infile 'suite/ndb/data/wl946_main6.dat'
166 into table t1 fields terminated by ',' lines terminated by '\n';
167
168 --echo # run backup
169 --source include/ndb_backup.inc
170 --let backup_id_6 = $the_backup_id
171
172 --echo # drop table prec 6
173 drop table t1;
174
175 --echo # restore meta from backup
176 --exec $NDB_RESTORE -b $backup_id_6 -n 1 -m --print-meta $NDB_BACKUPS-$backup_id_6 >> $NDB_TOOLS_OUTPUT
177 --disable_warnings
178 show create table t1;
179 --enable_warnings
180 --source show_attributes.inc
181 --source show_indexes.inc
182
183 --echo # restore data from backup
184 --exec $NDB_RESTORE -b $backup_id_6 -n 1 -r $NDB_BACKUPS-$backup_id_6 >> $NDB_TOOLS_OUTPUT
185 --exec $NDB_RESTORE -b $backup_id_6 -n 2 -r $NDB_BACKUPS-$backup_id_6 >> $NDB_TOOLS_OUTPUT
186
187 --echo # check contents
188 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
189
190 --echo # check contents truncated to prec 3
191 # something weird: have to insert concat into char to get correct checksum
192 --let $works=0
193 if ($works)
194 {
195 select count(*), sum(crc32(concat(a,b,c,left(d,length(d)-3),left(e,length(e)-3),left(f,length(f)-3)))) from t1;
196 }
197 if (!$works)
198 {
199 --disable_warnings
200 drop table if exists t1tmp;
201 --enable_warnings
202 create temporary table t1tmp (
203 x char(255)
204 ) engine=myisam;
205 insert into t1tmp select concat(a,b,c,left(d,length(d)-3),left(e,length(e)-3),left(f,length(f)-3)) from t1;
206 select count(*), sum(crc32(x)) from t1tmp;
207 drop table t1tmp;
208 }
209
210 --echo # drop table prec 6
211 drop table t1;
212
213 --echo # PART 3: restore with data promote and demote
214
215 --echo # create table prec 6
216 --let $prec=(6)
217 --let $frac=.123456
218 --source ndb_wl946_create.inc
219 --disable_warnings
220 show create table t1;
221 --enable_warnings
222 --source show_attributes.inc
223 --source show_indexes.inc
224
225 --echo # restore data from backup with promote
226 --exec $NDB_RESTORE -b $backup_id_3 -n 1 -r --promote-attributes $NDB_BACKUPS-$backup_id_3 >> $NDB_TOOLS_OUTPUT
227 --exec $NDB_RESTORE -b $backup_id_3 -n 2 -r --promote-attributes $NDB_BACKUPS-$backup_id_3 >> $NDB_TOOLS_OUTPUT
228
229 --echo # check contents
230 # replace fraction .000123 by .123
231 select count(*), sum(crc32(replace(concat(a,b,c,d,e,f),".000","."))) from t1;
232
233 --echo # drop table prec 6
234 drop table t1;
235
236 --echo # create table prec 3
237 --let $prec=(3)
238 --let $frac=.123
239 --source ndb_wl946_create.inc
240 --disable_warnings
241 show create table t1;
242 --enable_warnings
243 --source show_attributes.inc
244 --source show_indexes.inc
245
246 --echo # restore data from backup with demote
247 --exec $NDB_RESTORE -b $backup_id_6 -n 1 -r --lossy-conversions $NDB_BACKUPS-$backup_id_6 >> $NDB_TOOLS_OUTPUT
248 --exec $NDB_RESTORE -b $backup_id_6 -n 2 -r --lossy-conversions $NDB_BACKUPS-$backup_id_6 >> $NDB_TOOLS_OUTPUT
249
250 --echo # check contents truncated to prec 3
251 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
252
253 set time_zone = default;
254 select @@session.time_zone;
255
256 drop table t1, t1sum;
257 --source suite/ndb/include/backup_restore_cleanup.inc
258 --remove_file $NDB_TOOLS_OUTPUT