summaryrefslogtreecommitdiff
path: root/mysql-test/t/events_bugs.test
diff options
context:
space:
mode:
authorunknown <andrey@lmy004.>2006-03-25 00:24:04 +0100
committerunknown <andrey@lmy004.>2006-03-25 00:24:04 +0100
commitb95fb17332b17427a1bf93498e73d6348af43c8c (patch)
tree8c187436597fa6d5c9ce88799c7c8bcf5ec34a89 /mysql-test/t/events_bugs.test
parent1a53c9c3a3b93d3adc55af4f9c4c77aee63b4342 (diff)
parent6e9cd55d835f284192deaab1389ed8ad20921895 (diff)
downloadmariadb-git-b95fb17332b17427a1bf93498e73d6348af43c8c.tar.gz
manual merge
mysql-test/r/events.result: Auto merged mysql-test/t/events_bugs.test: Auto merged scripts/mysql_fix_privilege_tables.sql: Auto merged
Diffstat (limited to 'mysql-test/t/events_bugs.test')
-rw-r--r--mysql-test/t/events_bugs.test25
1 files changed, 24 insertions, 1 deletions
diff --git a/mysql-test/t/events_bugs.test b/mysql-test/t/events_bugs.test
index 384b648761a..690f9f3df6f 100644
--- a/mysql-test/t/events_bugs.test
+++ b/mysql-test/t/events_bugs.test
@@ -1,5 +1,28 @@
create database if not exists events_test;
use events_test;
+
+#
+# START - 16415: Events: event names are case sensitive
+#
+CREATE EVENT lower_case ON SCHEDULE EVERY 1 MINUTE DO SELECT 1;
+--error ER_EVENT_ALREADY_EXISTS
+CREATE EVENT Lower_case ON SCHEDULE EVERY 2 MINUTE DO SELECT 2;
+DROP EVENT Lower_case;
+SET NAMES cp1251;
+CREATE EVENT __1251 ON SCHEDULE EVERY 1 YEAR DO SELECT 100;
+--error ER_EVENT_ALREADY_EXISTS
+CREATE EVENT __1251 ON SCHEDULE EVERY 2 YEAR DO SELECT 200;
+DROP EVENT __1251;
+SET NAMES utf8;
+CREATE EVENT долен_регистър_утф8 ON SCHEDULE EVERY 3 YEAR DO SELECT 300;
+--error ER_EVENT_ALREADY_EXISTS
+CREATE EVENT ДОЛЕН_регистър_утф8 ON SCHEDULE EVERY 4 YEAR DO SELECT 400;
+DROP EVENT ДОЛЕН_регистър_утф8;
+SET NAMES latin1;
+#
+# END - 16415: Events: event names are case sensitive
+#
+
#
# START - BUG#16408: Events: crash for an event in a procedure
#
@@ -75,7 +98,7 @@ begin
select get_lock('ee_16407_2', 60);
insert into events_test.events_smode_test values('ee_16407_2','1980-19-02');
end|
---error 1292
+--error ER_TRUNCATED_WRONG_VALUE
insert into events_smode_test values ('test','1980-19-02')|
--echo "This is ok"
create event ee_16407_3 on schedule every 60 second do