Debian Codegraph @

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

raw
1 --source include/have_ndb.inc
2 --source suite/ndb/include/backup_restore_setup.inc
3
4 # runs before and after wl#946 / wl#6231
5 # result file is same (avoid ndb_desc if new types are possible)
6 # also creates a backup used in ndb_wl946_post.test
7
8 select @@session.time_zone;
9 set time_zone = '+00:00';
10 select @@session.time_zone;
11
12 --echo # create table
13 --let $prec=
14 --let $frac=
15 --source ndb_wl946_create.inc
16 show create table t1;
17
18 --echo # test defaults
19 insert into t1 (a) values (0);
20 select * from t1;
21 delete from t1;
22
23 --echo # load data
24 load data local infile 'suite/ndb/data/wl946_pre.dat'
25 into table t1 fields terminated by ',' lines terminated by '\n';
26
27 --echo # check contents
28 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
29
30 --echo # run backup
31 --source include/ndb_backup.inc
32
33 --echo # index queries
34 --source ndb_wl946_pre_query.inc
35
36 --echo # check results via innodb
37 alter table t1 engine=innodb;
38 show create table t1;
39 --enable_warnings
40 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
41 --source ndb_wl946_pre_query.inc
42
43 --echo # drop table
44 drop table t1;
45
46 --echo # restore meta from backup
47 --exec $NDB_RESTORE -b $the_backup_id -n 1 -m --print-meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
48
49 show create table t1;
50
51 --echo # restore data from backup
52 --exec $NDB_RESTORE -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
53 --exec $NDB_RESTORE -b $the_backup_id -n 2 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
54
55 --echo # check contents
56 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
57
58 --echo # drop table
59 drop table t1;
60
61 --echo # restore meta from wl946_pre
62 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 -m --print-meta $NDB_SAVED_BACKUPS/wl946_pre >> $NDB_TOOLS_OUTPUT
63
64 # datetime,timestamp default wrong on solaris (probably bug#53818)
65 # show create table t1;
66 # ndb_restore creates old types
67 --source show_attributes.inc
68 --source show_indexes.inc
69
70 --echo # restore data from wl946_pre
71 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 -r $NDB_SAVED_BACKUPS/wl946_pre >> $NDB_TOOLS_OUTPUT
72 --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 2 -r $NDB_SAVED_BACKUPS/wl946_pre >> $NDB_TOOLS_OUTPUT
73
74 --echo # check contents
75 # The `t1` table is not expected to be usable. It contains old
76 # temporal types which have been removed in 8.0. The upgrade of the
77 # table metadata is not supported
78 --disable_query_log
79 call mtr.add_suppression("Table upgrade required");
80 --enable_query_log
81 --error ER_NO_SUCH_TABLE
82 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1;
83 SHOW WARNINGS;
84
85 set time_zone = default;
86 select @@session.time_zone;
87
88 --exec $NDB_DROP_TABLE -d test t1 >> $NDB_TOOLS_OUTPUT
89
90 --source suite/ndb/include/backup_restore_cleanup.inc
91 --remove_file $NDB_TOOLS_OUTPUT