~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
Run mysql_upgrade once
 
2
mysql.columns_priv                                 OK
 
3
mysql.db                                           OK
 
4
mysql.event                                        OK
 
5
mysql.func                                         OK
 
6
mysql.general_log
 
7
Error    : You can't use locks with log tables.
 
8
status   : OK
 
9
mysql.help_category                                OK
 
10
mysql.help_keyword                                 OK
 
11
mysql.help_relation                                OK
 
12
mysql.help_topic                                   OK
 
13
mysql.host                                         OK
 
14
mysql.ndb_binlog_index                             OK
 
15
mysql.online_backup
 
16
Error    : You can't use locks with log tables.
 
17
status   : OK
 
18
mysql.online_backup_progress
 
19
Error    : You can't use locks with log tables.
 
20
status   : OK
 
21
mysql.plugin                                       OK
 
22
mysql.proc                                         OK
 
23
mysql.procs_priv                                   OK
 
24
mysql.servers                                      OK
 
25
mysql.slow_log
 
26
Error    : You can't use locks with log tables.
 
27
status   : OK
 
28
mysql.tables_priv                                  OK
 
29
mysql.time_zone                                    OK
 
30
mysql.time_zone_leap_second                        OK
 
31
mysql.time_zone_name                               OK
 
32
mysql.time_zone_transition                         OK
 
33
mysql.time_zone_transition_type                    OK
 
34
mysql.user                                         OK
 
35
Run it again - should say already completed
 
36
This installation of MySQL is already upgraded to VERSION, use --force if you still need to run mysql_upgrade
 
37
Force should run it regardless of wether it's been run before
 
38
mysql.columns_priv                                 OK
 
39
mysql.db                                           OK
 
40
mysql.event                                        OK
 
41
mysql.func                                         OK
 
42
mysql.general_log
 
43
Error    : You can't use locks with log tables.
 
44
status   : OK
 
45
mysql.help_category                                OK
 
46
mysql.help_keyword                                 OK
 
47
mysql.help_relation                                OK
 
48
mysql.help_topic                                   OK
 
49
mysql.host                                         OK
 
50
mysql.ndb_binlog_index                             OK
 
51
mysql.online_backup
 
52
Error    : You can't use locks with log tables.
 
53
status   : OK
 
54
mysql.online_backup_progress
 
55
Error    : You can't use locks with log tables.
 
56
status   : OK
 
57
mysql.plugin                                       OK
 
58
mysql.proc                                         OK
 
59
mysql.procs_priv                                   OK
 
60
mysql.servers                                      OK
 
61
mysql.slow_log
 
62
Error    : You can't use locks with log tables.
 
63
status   : OK
 
64
mysql.tables_priv                                  OK
 
65
mysql.time_zone                                    OK
 
66
mysql.time_zone_leap_second                        OK
 
67
mysql.time_zone_name                               OK
 
68
mysql.time_zone_transition                         OK
 
69
mysql.time_zone_transition_type                    OK
 
70
mysql.user                                         OK
 
71
CREATE USER mysqltest1@'%' IDENTIFIED by 'sakila';
 
72
GRANT ALL ON *.* TO mysqltest1@'%';
 
73
Run mysql_upgrade with password protected account
 
74
mysql.columns_priv                                 OK
 
75
mysql.db                                           OK
 
76
mysql.event                                        OK
 
77
mysql.func                                         OK
 
78
mysql.general_log
 
79
Error    : You can't use locks with log tables.
 
80
status   : OK
 
81
mysql.help_category                                OK
 
82
mysql.help_keyword                                 OK
 
83
mysql.help_relation                                OK
 
84
mysql.help_topic                                   OK
 
85
mysql.host                                         OK
 
86
mysql.ndb_binlog_index                             OK
 
87
mysql.online_backup
 
88
Error    : You can't use locks with log tables.
 
89
status   : OK
 
90
mysql.online_backup_progress
 
91
Error    : You can't use locks with log tables.
 
92
status   : OK
 
93
mysql.plugin                                       OK
 
94
mysql.proc                                         OK
 
95
mysql.procs_priv                                   OK
 
96
mysql.servers                                      OK
 
97
mysql.slow_log
 
98
Error    : You can't use locks with log tables.
 
99
status   : OK
 
100
mysql.tables_priv                                  OK
 
101
mysql.time_zone                                    OK
 
102
mysql.time_zone_leap_second                        OK
 
103
mysql.time_zone_name                               OK
 
104
mysql.time_zone_transition                         OK
 
105
mysql.time_zone_transition_type                    OK
 
106
mysql.user                                         OK
 
107
DROP USER mysqltest1@'%';
 
108
Run mysql_upgrade with a non existing server socket
 
109
mysqlcheck: Got error: 2005: Unknown MySQL server host 'not_existing_host' (errno) when trying to connect
 
110
FATAL ERROR: Upgrade failed
 
111
set GLOBAL sql_mode='STRICT_ALL_TABLES,ANSI_QUOTES,NO_ZERO_DATE';
 
112
mysql.columns_priv                                 OK
 
113
mysql.db                                           OK
 
114
mysql.event                                        OK
 
115
mysql.func                                         OK
 
116
mysql.general_log
 
117
Error    : You can't use locks with log tables.
 
118
status   : OK
 
119
mysql.help_category                                OK
 
120
mysql.help_keyword                                 OK
 
121
mysql.help_relation                                OK
 
122
mysql.help_topic                                   OK
 
123
mysql.host                                         OK
 
124
mysql.ndb_binlog_index                             OK
 
125
mysql.online_backup
 
126
Error    : You can't use locks with log tables.
 
127
status   : OK
 
128
mysql.online_backup_progress
 
129
Error    : You can't use locks with log tables.
 
130
status   : OK
 
131
mysql.plugin                                       OK
 
132
mysql.proc                                         OK
 
133
mysql.procs_priv                                   OK
 
134
mysql.servers                                      OK
 
135
mysql.slow_log
 
136
Error    : You can't use locks with log tables.
 
137
status   : OK
 
138
mysql.tables_priv                                  OK
 
139
mysql.time_zone                                    OK
 
140
mysql.time_zone_leap_second                        OK
 
141
mysql.time_zone_name                               OK
 
142
mysql.time_zone_transition                         OK
 
143
mysql.time_zone_transition_type                    OK
 
144
mysql.user                                         OK
 
145
set GLOBAL sql_mode=default;