← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« 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 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
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
127
127
mysql.time_zone_transition_type                    OK
128
128
mysql.user                                         OK
129
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