Debian Codegraph @

mysql-test/suite/ndb/t/ndb_fk_restore.inc

raw
1 #
2
3 # Create view which displays all foreign keys.
4 # NOTE! Uses a format which is backward compatible with the output
5 # from "ndb_show_tables" previously used by this test - for example names
6 # have surrounding quotes.
7 --disable_query_log ONCE
8 CREATE VIEW ndb_show_tables_results AS
9 SELECT
10 CASE type
11 WHEN 25 THEN "'ForeignKey'"
12 WHEN 26 THEN "'FKParentTrigger'"
13 WHEN 27 THEN "'FKChildTrigger'"
14 ELSE 'UnexpectedType'
15 END AS type,
16 /* Add surrounding quotes */
17 CONCAT("'", CONCAT(fq_name, "'")) AS name
18 FROM ndbinfo.dict_obj_info WHERE type IN (25, 26, 27);
19
20 #SELECT * FROM ndb_show_tables_results;
21
22 -- echo # show meta
23 show create table t2;
24 -- replace_regex /_[0-9]+/_XX/ /[0-9]+\/[0-9]+/XX\/XX/
25 -- sorted_result
26 select type,name from ndb_show_tables_results
27 where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger''');
28
29 -- echo # show counts
30 select count(*) from t1;
31 select count(*) from t2;
32
33 -- echo # run backup
34 -- source include/ndb_backup.inc
35
36 -- echo # drop tables
37 drop table t2, t1;
38
39 # crummy language
40 -- let $disable_indexes2=0
41 if ($disable_indexes) {
42 -- let $disable_indexes2=1
43 }
44 if ($rebuild_indexes) {
45 -- let $disable_indexes2=1
46 }
47
48 if (!$disable_indexes2) {
49
50 -- echo # restore meta
51 -- exec $NDB_RESTORE --verbose=255 -b $the_backup_id -n 1 -m --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
52
53 -- echo # restore data
54 -- exec $NDB_RESTORE --verbose=255 -b $the_backup_id -n 1 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
55 -- exec $NDB_RESTORE --verbose=255 -b $the_backup_id -n 2 -r $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
56
57 }
58
59 if ($disable_indexes2) {
60
61 -- echo # restore meta (disable indexes)
62 -- exec $NDB_RESTORE --verbose=255 -b $the_backup_id -n 1 -m --print_meta --disable-indexes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
63
64 # option --disable-indexes should have no effect here but we imitate MCM
65 -- echo # restore data (disable indexes)
66 -- exec $NDB_RESTORE --verbose=255 -b $the_backup_id -n 1 -r --disable-indexes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
67 -- exec $NDB_RESTORE --verbose=255 -b $the_backup_id -n 2 -r --disable-indexes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
68
69 }
70
71 if ($rebuild_indexes) {
72
73 -- echo # rebuild indexes
74 -- exec $NDB_RESTORE --verbose=255 -b $the_backup_id -n 1 --print_meta --rebuild-indexes $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
75
76 }
77
78 # disable-indexes makes restored table unusable via mysql except for drop
79
80 -- echo # show meta
81 if (!$disable_indexes) {
82 show create table t2;
83 }
84 -- replace_regex /_[0-9]+/_XX/ /[0-9]+\/[0-9]+/XX\/XX/
85 -- sorted_result
86 select type,name from ndb_show_tables_results
87 where type in ('''ForeignKey''','''FKParentTrigger''','''FKChildTrigger''');
88
89 -- echo # show counts
90 if (!$disable_indexes) {
91 select count(*) from t1;
92 select count(*) from t2;
93 }
94
95 # reset
96 -- let $disable_indexes=
97 -- let $rebuild_indexes=
98 -- let $disable_indexes2=
99
100 --disable_query_log ONCE
101 DROP VIEW ndb_show_tables_results;