summaryrefslogtreecommitdiff
path: root/mysql-test/t/events_bugs.test
diff options
context:
space:
mode:
authorDmitry Shulga <Dmitry.Shulga@oracle.com>2011-06-10 00:07:03 +0700
committerDmitry Shulga <Dmitry.Shulga@oracle.com>2011-06-10 00:07:03 +0700
commit1be4de546ea89a05babb94d9a95e3bce2fccf0f0 (patch)
tree63a7c37a1ec59dfeb60718fa0d55eda1f8038628 /mysql-test/t/events_bugs.test
parent600647c7d8647dc31025146896a671619d73d97f (diff)
parentfa913a0b987d94164449511cf0cef5baf1fb9a6f (diff)
downloadmariadb-git-1be4de546ea89a05babb94d9a95e3bce2fccf0f0.tar.gz
Auto-merge of patch for bug#11764334 from mysql-5.1 tree.
Diffstat (limited to 'mysql-test/t/events_bugs.test')
-rw-r--r--mysql-test/t/events_bugs.test15
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/events_bugs.test b/mysql-test/t/events_bugs.test
index 036a1132acd..06dc3b30aa2 100644
--- a/mysql-test/t/events_bugs.test
+++ b/mysql-test/t/events_bugs.test
@@ -1286,6 +1286,21 @@ DROP EVENT IF EXISTS event_Bug12546938;
DROP TABLE table_bug12546938;
SET GLOBAL EVENT_SCHEDULER = OFF;
+#
+# Bug#11764334 - 57156: ALTER EVENT CHANGES THE EVENT STATUS
+#
+--disable_warnings
+DROP DATABASE IF EXISTS event_test11764334;
+--enable_warnings
+CREATE DATABASE event_test11764334;
+USE event_test11764334;
+CREATE EVENT ev1 ON SCHEDULE EVERY 3 SECOND DISABLE DO SELECT 1;
+SHOW EVENTS IN event_test11764334 WHERE NAME='ev1';
+ALTER EVENT ev1 ON SCHEDULE EVERY 4 SECOND;
+SHOW EVENTS IN event_test11764334 WHERE NAME='ev1';
+DROP EVENT ev1;
+DROP DATABASE event_test11764334;
+USE test;
###########################################################################
#
# End of tests