1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
|
Test case 1 - Normal run
# Source on localhost: ... connected.
# Importing ... bad_engines.csv
#...done.
util_test.t1: ENGINE=MEMORY
util_test.t2: ENGINE=MEMORY
util_test.t3: ENGINE=MEMORY
util_test.t4: ENGINE=MyISAM
util_test.t5: ENGINE=MEMORY
util_test.t6: ENGINE=MEMORY
util_test.t7: ENGINE=MEMORY
util_test.t8: ENGINE=MEMORY
util_test.t9: ENGINE=InnoDB
util_test.t10: ENGINE=MEMORY
Test case 2 - convert to memory storage engine
# Source on localhost: ... connected.
# Importing ... bad_engines.csv
# Adding missing ENGINE=MEMORY clause for table `util_test`.`t1`.
# Replacing ENGINE=CAYMAN with ENGINE=MEMORY for table `util_test`.`t2`.
# Replacing ENGINE=BOXSTER with ENGINE=MEMORY for table `util_test`.`t3`.
# Replacing ENGINE=MYISAM with ENGINE=MEMORY for table `util_test`.`t4`.
# Adding missing ENGINE=MEMORY clause for table `util_test`.`t5`.
# Replacing ENGINE=CARRERA with ENGINE=MEMORY for table `util_test`.`t6`.
# Adding missing ENGINE=MEMORY clause for table `util_test`.`t7`.
# Replacing ENGINE=PANAMERA with ENGINE=MEMORY for table `util_test`.`t8`.
# Replacing ENGINE=INNODB with ENGINE=MEMORY for table `util_test`.`t9`.
# Adding missing ENGINE=MEMORY clause for table `util_test`.`t10`.
#...done.
util_test.t1: ENGINE=MEMORY
util_test.t2: ENGINE=MEMORY
util_test.t3: ENGINE=MEMORY
util_test.t4: ENGINE=MEMORY
util_test.t5: ENGINE=MEMORY
util_test.t6: ENGINE=MEMORY
util_test.t7: ENGINE=MEMORY
util_test.t8: ENGINE=MEMORY
util_test.t9: ENGINE=MEMORY
util_test.t10: ENGINE=MEMORY
Test case 3 - new storage engine missing
# Source on localhost: ... connected.
WARNING: New storage engine NOTTHERE is not supported on the server.
# Importing ... bad_engines.csv
#...done.
util_test.t1: ENGINE=MEMORY
util_test.t2: ENGINE=MEMORY
util_test.t3: ENGINE=MEMORY
util_test.t4: ENGINE=MyISAM
util_test.t5: ENGINE=MEMORY
util_test.t6: ENGINE=MEMORY
util_test.t7: ENGINE=MEMORY
util_test.t8: ENGINE=MEMORY
util_test.t9: ENGINE=InnoDB
util_test.t10: ENGINE=MEMORY
Test case 4 - default storage engine missing
# Source on localhost: ... connected.
WARNING: Default storage engine NOPENOTHERE is not supported on the server.
# Importing ... bad_engines.csv
#...done.
util_test.t1: ENGINE=MEMORY
util_test.t2: ENGINE=MEMORY
util_test.t3: ENGINE=MEMORY
util_test.t4: ENGINE=MyISAM
util_test.t5: ENGINE=MEMORY
util_test.t6: ENGINE=MEMORY
util_test.t7: ENGINE=MEMORY
util_test.t8: ENGINE=MEMORY
util_test.t9: ENGINE=InnoDB
util_test.t10: ENGINE=MEMORY
Test case 5 - new storage engine missing, default Ok
# Source on localhost: ... connected.
WARNING: New storage engine NOTTHERE is not supported on the server.
# Importing ... bad_engines.csv
# Adding missing ENGINE=INNODB clause for table `util_test`.`t1`.
# Replacing ENGINE=MYISAM with ENGINE=INNODB for table `util_test`.`t4`.
# Adding missing ENGINE=INNODB clause for table `util_test`.`t5`.
# Adding missing ENGINE=INNODB clause for table `util_test`.`t7`.
# Adding missing ENGINE=INNODB clause for table `util_test`.`t10`.
#...done.
util_test.t1: ENGINE=InnoDB
util_test.t2: ENGINE=MEMORY
util_test.t3: ENGINE=MEMORY
util_test.t4: ENGINE=MyISAM
util_test.t5: ENGINE=InnoDB
util_test.t6: ENGINE=MEMORY
util_test.t7: ENGINE=InnoDB
util_test.t8: ENGINE=MEMORY
util_test.t9: ENGINE=InnoDB
util_test.t10: ENGINE=InnoDB
Test case 6 - default storage engine missing, new Ok
# Source on localhost: ... connected.
WARNING: Default storage engine NOPENOTHERE is not supported on the server.
# Importing ... bad_engines.csv
# Adding missing ENGINE=MYISAM clause for table `util_test`.`t1`.
# Replacing ENGINE=CAYMAN with ENGINE=MYISAM for table `util_test`.`t2`.
# Replacing ENGINE=BOXSTER with ENGINE=MYISAM for table `util_test`.`t3`.
# Adding missing ENGINE=MYISAM clause for table `util_test`.`t5`.
# Replacing ENGINE=CARRERA with ENGINE=MYISAM for table `util_test`.`t6`.
# Adding missing ENGINE=MYISAM clause for table `util_test`.`t7`.
# Replacing ENGINE=PANAMERA with ENGINE=MYISAM for table `util_test`.`t8`.
# Replacing ENGINE=INNODB with ENGINE=MYISAM for table `util_test`.`t9`.
# Adding missing ENGINE=MYISAM clause for table `util_test`.`t10`.
#...done.
util_test.t1: ENGINE=MyISAM
util_test.t2: ENGINE=MyISAM
util_test.t3: ENGINE=MyISAM
util_test.t4: ENGINE=MyISAM
util_test.t5: ENGINE=MyISAM
util_test.t6: ENGINE=MyISAM
util_test.t7: ENGINE=MyISAM
util_test.t8: ENGINE=MyISAM
util_test.t9: ENGINE=MyISAM
util_test.t10: ENGINE=MyISAM
|