diff options
author | unknown <andrey@lmy004.> | 2006-03-25 00:24:04 +0100 |
---|---|---|
committer | unknown <andrey@lmy004.> | 2006-03-25 00:24:04 +0100 |
commit | b95fb17332b17427a1bf93498e73d6348af43c8c (patch) | |
tree | 8c187436597fa6d5c9ce88799c7c8bcf5ec34a89 /mysql-test/t/events_bugs.test | |
parent | 1a53c9c3a3b93d3adc55af4f9c4c77aee63b4342 (diff) | |
parent | 6e9cd55d835f284192deaab1389ed8ad20921895 (diff) | |
download | mariadb-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.test | 25 |
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 |