| blob | 4541763c7c50365b347ff9fbcf3b167bc77ab22d |
1 Run mysql_upgrade once
2 mtr.global_suppressions OK
3 mtr.test_suppressions OK
4 mysql.columns_priv OK
5 mysql.db OK
6 mysql.event OK
7 mysql.func OK
8 mysql.general_log
9 Error : You can't use locks with log tables.
10 status : OK
11 mysql.help_category OK
12 mysql.help_keyword OK
13 mysql.help_relation OK
14 mysql.help_topic OK
15 mysql.host OK
16 mysql.ndb_binlog_index OK
17 mysql.plugin OK
18 mysql.proc OK
19 mysql.procs_priv OK
20 mysql.servers OK
21 mysql.slow_log
22 Error : You can't use locks with log tables.
23 status : OK
24 mysql.tables_priv OK
25 mysql.time_zone OK
26 mysql.time_zone_leap_second OK
27 mysql.time_zone_name OK
28 mysql.time_zone_transition OK
29 mysql.time_zone_transition_type OK
30 mysql.user OK
31 Run it again - should say already completed
32 This installation of MySQL is already upgraded to VERSION, use --force if you still need to run mysql_upgrade
33 Force should run it regardless of wether it's been run before
34 mtr.global_suppressions OK
35 mtr.test_suppressions OK
36 mysql.columns_priv OK
37 mysql.db OK
38 mysql.event OK
39 mysql.func OK
40 mysql.general_log
41 Error : You can't use locks with log tables.
42 status : OK
43 mysql.help_category OK
44 mysql.help_keyword OK
45 mysql.help_relation OK
46 mysql.help_topic OK
47 mysql.host OK
48 mysql.ndb_binlog_index OK
49 mysql.plugin OK
50 mysql.proc OK
51 mysql.procs_priv OK
52 mysql.servers OK
53 mysql.slow_log
54 Error : You can't use locks with log tables.
55 status : OK
56 mysql.tables_priv OK
57 mysql.time_zone OK
58 mysql.time_zone_leap_second OK
59 mysql.time_zone_name OK
60 mysql.time_zone_transition OK
61 mysql.time_zone_transition_type OK
62 mysql.user OK
63 CREATE USER mysqltest1@'%' IDENTIFIED by 'sakila';
64 GRANT ALL ON *.* TO mysqltest1@'%';
65 Run mysql_upgrade with password protected account
66 mtr.global_suppressions OK
67 mtr.test_suppressions OK
68 mysql.columns_priv OK
69 mysql.db OK
70 mysql.event OK
71 mysql.func OK
72 mysql.general_log
73 Error : You can't use locks with log tables.
74 status : OK
75 mysql.help_category OK
76 mysql.help_keyword OK
77 mysql.help_relation OK
78 mysql.help_topic OK
79 mysql.host OK
80 mysql.ndb_binlog_index OK
81 mysql.plugin OK
82 mysql.proc OK
83 mysql.procs_priv OK
84 mysql.servers OK
85 mysql.slow_log
86 Error : You can't use locks with log tables.
87 status : OK
88 mysql.tables_priv OK
89 mysql.time_zone OK
90 mysql.time_zone_leap_second OK
91 mysql.time_zone_name OK
92 mysql.time_zone_transition OK
93 mysql.time_zone_transition_type OK
94 mysql.user OK
95 DROP USER mysqltest1@'%';
96 Run mysql_upgrade with a non existing server socket
97 mysqlcheck: Got error: 2005: Unknown MySQL server host 'not_existing_host' (errno) when trying to connect
98 FATAL ERROR: Upgrade failed
99 set GLOBAL sql_mode='STRICT_ALL_TABLES,ANSI_QUOTES,NO_ZERO_DATE';
100 mtr.global_suppressions OK
101 mtr.test_suppressions OK
102 mysql.columns_priv OK
103 mysql.db OK
104 mysql.event OK
105 mysql.func OK
106 mysql.general_log
107 Error : You can't use locks with log tables.
108 status : OK
109 mysql.help_category OK
110 mysql.help_keyword OK
111 mysql.help_relation OK
112 mysql.help_topic OK
113 mysql.host OK
114 mysql.ndb_binlog_index OK
115 mysql.plugin OK
116 mysql.proc OK
117 mysql.procs_priv OK
118 mysql.servers OK
119 mysql.slow_log
120 Error : You can't use locks with log tables.
121 status : OK
122 mysql.tables_priv OK
123 mysql.time_zone OK
124 mysql.time_zone_leap_second OK
125 mysql.time_zone_name OK
126 mysql.time_zone_transition OK
127 mysql.time_zone_transition_type OK
128 mysql.user OK
129 set GLOBAL sql_mode=default;
130 #
131 # Bug #41569 mysql_upgrade (ver 5.1) add 3 fields to mysql.proc table
132 # but does not set values.
133 #
134 CREATE PROCEDURE testproc() BEGIN END;
135 UPDATE mysql.proc SET character_set_client = NULL WHERE name LIKE 'testproc';
136 UPDATE mysql.proc SET collation_connection = NULL WHERE name LIKE 'testproc';
137 UPDATE mysql.proc SET db_collation = NULL WHERE name LIKE 'testproc';
138 mtr.global_suppressions OK
139 mtr.test_suppressions OK
140 mysql.columns_priv OK
141 mysql.db OK
142 mysql.event OK
143 mysql.func OK
144 mysql.general_log
145 Error : You can't use locks with log tables.
146 status : OK
147 mysql.help_category OK
148 mysql.help_keyword OK
149 mysql.help_relation OK
150 mysql.help_topic OK
151 mysql.host OK
152 mysql.ndb_binlog_index OK
153 mysql.plugin OK
154 mysql.proc OK
155 mysql.procs_priv OK
156 mysql.servers OK
157 mysql.slow_log
158 Error : You can't use locks with log tables.
159 status : OK
160 mysql.tables_priv OK
161 mysql.time_zone OK
162 mysql.time_zone_leap_second OK
163 mysql.time_zone_name OK
164 mysql.time_zone_transition OK
165 mysql.time_zone_transition_type OK
166 mysql.user OK
167 CALL testproc();
168 DROP PROCEDURE testproc;
169 WARNING: NULL values of the 'character_set_client' column ('mysql.proc' table) have been updated with a default value (latin1). Please verify if necessary.
170 WARNING: NULL values of the 'collation_connection' column ('mysql.proc' table) have been updated with a default value (latin1_swedish_ci). Please verify if necessary.
171 WARNING: NULL values of the 'db_collation' column ('mysql.proc' table) have been updated with default values. Please verify if necessary.
172 #
173 # Bug #53613: mysql_upgrade incorrectly revokes
174 # TRIGGER privilege on given table
175 #
176 GRANT USAGE ON *.* TO 'user3'@'%';
177 GRANT ALL PRIVILEGES ON `roelt`.`test2` TO 'user3'@'%';
178 Run mysql_upgrade with all privileges on a user
179 mtr.global_suppressions OK
180 mtr.test_suppressions OK
181 mysql.columns_priv OK
182 mysql.db OK
183 mysql.event OK
184 mysql.func OK
185 mysql.general_log
186 Error : You can't use locks with log tables.
187 status : OK
188 mysql.help_category OK
189 mysql.help_keyword OK
190 mysql.help_relation OK
191 mysql.help_topic OK
192 mysql.host OK
193 mysql.ndb_binlog_index OK
194 mysql.plugin OK
195 mysql.proc OK
196 mysql.procs_priv OK
197 mysql.servers OK
198 mysql.slow_log
199 Error : You can't use locks with log tables.
200 status : OK
201 mysql.tables_priv OK
202 mysql.time_zone OK
203 mysql.time_zone_leap_second OK
204 mysql.time_zone_name OK
205 mysql.time_zone_transition OK
206 mysql.time_zone_transition_type OK
207 mysql.user OK
208 SHOW GRANTS FOR 'user3'@'%';
209 Grants for user3@%
210 GRANT USAGE ON *.* TO 'user3'@'%'
211 GRANT ALL PRIVILEGES ON `roelt`.`test2` TO 'user3'@'%'
212 DROP USER 'user3'@'%';
213 End of 5.1 tests