← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/r/mysql_upgrade.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/mysql_upgrade.result
169
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
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
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