summaryrefslogtreecommitdiff
path: root/scripts/mysql_system_tables_fix.sql
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2015-10-15 12:11:17 +0300
committerMichael Widenius <monty@mariadb.org>2015-10-21 16:31:11 +0300
commit18f7dfed179204dcfc02a27790e22bb9cc4e2e32 (patch)
treecf404263c6ee35c5e9c80811f5fd3845c0b98aca /scripts/mysql_system_tables_fix.sql
parent95faf34d859aee242812fae31629b224feeb868a (diff)
downloadmariadb-git-18f7dfed179204dcfc02a27790e22bb9cc4e2e32.tar.gz
Allow mysql_upgrade to enable event after table is corrected
new features: set event_scheduler=ON|OFF will now try to init event scheduler if it's not enabled set event_scheduler=default will try to enable it based on the value of the event_scheduler when mysqld was started
Diffstat (limited to 'scripts/mysql_system_tables_fix.sql')
-rw-r--r--scripts/mysql_system_tables_fix.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/scripts/mysql_system_tables_fix.sql b/scripts/mysql_system_tables_fix.sql
index b81eb4e8e40..33b4306b103 100644
--- a/scripts/mysql_system_tables_fix.sql
+++ b/scripts/mysql_system_tables_fix.sql
@@ -597,6 +597,8 @@ ALTER TABLE event ADD body_utf8 longblob DEFAULT NULL
AFTER db_collation;
ALTER TABLE event MODIFY body_utf8 longblob DEFAULT NULL;
+# Enable event scheduler if the event table was not up to date before.
+set global event_scheduler=original;
#
# TRIGGER privilege