Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
None
Description
Test case:
--source include/not_embedded.inc
|
|
alter table mysql.user modify User char(80) binary not null default ''; |
alter table mysql.db modify User char(80) binary not null default ''; |
alter table mysql.tables_priv modify User char(80) binary not null default ''; |
alter table mysql.columns_priv modify User char(80) binary not null default ''; |
alter table mysql.procs_priv modify User char(80) binary not null default ''; |
alter table mysql.proc modify definer char(141) collate utf8_bin not null default ''; |
alter table mysql.event modify definer char(141) collate utf8_bin not null default ''; |
flush privileges; |
|
--enable_reconnect
|
--append_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
restart
|
EOF
|
--shutdown_server 60
|
--source include/wait_until_connected_again.inc
|
|
set global event_scheduler = on; |
select @@event_scheduler; |
|
alter table mysql.user modify User char(16) binary not null default ''; |
alter table mysql.db modify User char(16) binary not null default ''; |
alter table mysql.tables_priv modify User char(16) binary not null default ''; |
alter table mysql.columns_priv modify User char(16) binary not null default ''; |
alter table mysql.procs_priv modify User char(16) binary not null default ''; |
alter table mysql.proc modify definer char(77) collate utf8_bin not null default ''; |
alter table mysql.event modify definer char(77) collate utf8_bin not null default ''; |
|
set global event_scheduler = off; |
Output:
CURRENT_TEST: bug.t1
|
mysqltest: At line 19: query 'set global event_scheduler = on' failed: 1577: Cannot proceed because system tables used by Event Scheduler were found damaged at server start
|
Error log:
130512 17:22:23 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(16), found type char(80).
|
130512 17:22:23 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
|
bzr version-info
revision-id: wlad@montyprogram.com-20130509212557-5cdelkdvf7t61062
|
revno: 3756
|
branch-nick: 5.5
|
Attachments
Issue Links
- relates to
-
MDEV-4332 Increase username length from 16 characters
- Closed