diff options
| author | unknown <andrey@lmy004.> | 2006-03-24 17:45:52 +0100 |
|---|---|---|
| committer | unknown <andrey@lmy004.> | 2006-03-24 17:45:52 +0100 |
| commit | 6e9cd55d835f284192deaab1389ed8ad20921895 (patch) | |
| tree | 71f942b354f5151f43abcfa3f6f2f30fa783fe0e /mysql-test/t/events_bugs.test | |
| parent | c78dc0cb1d3c4a425dade6610063c02a5e63098c (diff) | |
| download | mariadb-git-6e9cd55d835f284192deaab1389ed8ad20921895.tar.gz | |
fix for bug#16415 Events names are case sensitive
mysql-test/lib/init_db.sql:
make name not binary, then event names won't be case sensitive
mysql-test/r/events.result:
output fix
mysql-test/r/events_bugs.result:
update result
mysql-test/t/events_bugs.test:
test case for bug #16415 events' names are case sensitive
scripts/mysql_create_system_tables.sh:
make name not binary, then event names won't be case sensitive
scripts/mysql_fix_privilege_tables.sql:
make name not binary, then event names won't be case sensitive
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 2d4374dcb41..b3394d03b3e 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 - 16407: Events: Changes in sql_mode won't be taken into account # @@ -41,7 +64,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 |