~drizzle-trunk/drizzle/development : contents of mysql-test/r/mysql

~drizzle-trunk/drizzle/development : (revision 33)

Run mysql_upgrade once
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log
Error    : You can't use locks with log tables.
status   : OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.online_backup
Error    : You can't use locks with log tables.
status   : OK
mysql.online_backup_progress
Error    : You can't use locks with log tables.
status   : OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
Error    : You can't use locks with log tables.
status   : OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Run it again - should say already completed
This installation of MySQL is already upgraded to VERSION, use --force if you still need to run mysql_upgrade
Force should run it regardless of wether it's been run before
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log
Error    : You can't use locks with log tables.
status   : OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.online_backup
Error    : You can't use locks with log tables.
status   : OK
mysql.online_backup_progress
Error    : You can't use locks with log tables.
status   : OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
Error    : You can't use locks with log tables.
status   : OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
CREATE USER mysqltest1@'%' IDENTIFIED by 'sakila';
GRANT ALL ON *.* TO mysqltest1@'%';
Run mysql_upgrade with password protected account
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log
Error    : You can't use locks with log tables.
status   : OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.online_backup
Error    : You can't use locks with log tables.
status   : OK
mysql.online_backup_progress
Error    : You can't use locks with log tables.
status   : OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
Error    : You can't use locks with log tables.
status   : OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
DROP USER mysqltest1@'%';
Run mysql_upgrade with a non existing server socket
mysqlcheck: Got error: 2005: Unknown MySQL server host 'not_existing_host' (errno) when trying to connect
FATAL ERROR: Upgrade failed
set GLOBAL sql_mode='STRICT_ALL_TABLES,ANSI_QUOTES,NO_ZERO_DATE';
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log
Error    : You can't use locks with log tables.
status   : OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.online_backup
Error    : You can't use locks with log tables.
status   : OK
mysql.online_backup_progress
Error    : You can't use locks with log tables.
status   : OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
Error    : You can't use locks with log tables.
status   : OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
set GLOBAL sql_mode=default;

1 by brian clean slate	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;