summaryrefslogtreecommitdiff
path: root/mysql-test/t/events.test
diff options
context:
space:
mode:
authorunknown <andrey@lmy004.>2006-04-07 11:29:15 +0200
committerunknown <andrey@lmy004.>2006-04-07 11:29:15 +0200
commit61c5bbb719b3c5a43e99040998ce3b8d23295647 (patch)
tree6b073c924c4e5ba978df66c450730ec756542999 /mysql-test/t/events.test
parent3fe07e27852f258f201829bbb68f2ed18d76f8c3 (diff)
downloadmariadb-git-61c5bbb719b3c5a43e99040998ce3b8d23295647.tar.gz
update tests
mysql-test/r/events.result: update result mysql-test/t/events.test: update test (bk mangles cp1251 during merge) mysql-test/t/events_scheduling.test: fix test
Diffstat (limited to 'mysql-test/t/events.test')
-rw-r--r--mysql-test/t/events.test8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/t/events.test b/mysql-test/t/events.test
index 73cadd406d8..f80297682b7 100644
--- a/mysql-test/t/events.test
+++ b/mysql-test/t/events.test
@@ -147,8 +147,8 @@ SHOW CREATE EVENT root19;
create event root20 on schedule every '50:20:12:45' day_second do select 1;
SHOW CREATE EVENT root20;
set names cp1251;
-create event ðóóò21 on schedule every '50:23:59:95' day_second COMMENT 'òîâà å 1251 êîìåíòàð' do select 1;
-SHOW CREATE EVENT ðóóò21;
+create event ðóóò21 on schedule every '50:23:59:95' day_second COMMENT 'òîâà å 1251 êîìåíòàð' do select 1;
+SHOW CREATE EVENT ðóóò21;
insert into mysql.event (db, name, body, definer, interval_value, interval_field) values (database(), "root22", "select 1", user(), 100, "SECOND_MICROSECOND");
--error 1235
show create event root22;
@@ -173,7 +173,7 @@ drop event root17_1;
drop event root18;
drop event root19;
drop event root20;
-drop event ðóóò21;
+drop event ðóóò21;
set names latin1;
#
@@ -202,7 +202,7 @@ INSERT INTO event_like SELECT * FROM mysql.event;
#sleep a bit or we won't catch the change of time
--sleep 1
ALTER TABLE mysql.event MODIFY db char(64) character set cp1251 default '';
---error 1526
+--error ER_CANNOT_LOAD_FROM_TABLE
SELECT event_name FROM INFORMATION_SCHEMA.EVENTS;
ALTER TABLE mysql.event MODIFY db char(20) character set utf8 collate utf8_bin default '';
#wait a bit or we won't see the difference because of seconds resolution