← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
Import upstream version 5.1.45

Show diffs side-by-side

added added

removed removed

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