diff options
author | andrey@example.com <> | 2006-09-08 00:49:37 +0200 |
---|---|---|
committer | andrey@example.com <> | 2006-09-08 00:49:37 +0200 |
commit | 83f4f3b2aa4a1d73bb6db867cf673d79595cd9ce (patch) | |
tree | 69dced6c0133a7b0b489b23f5a2d94d2275ef77b /mysql-test/t/events_bugs.test | |
parent | 75eeececb1ba0bc8b9e5aedefce816155b25f575 (diff) | |
download | mariadb-git-83f4f3b2aa4a1d73bb6db867cf673d79595cd9ce.tar.gz |
fix build
Diffstat (limited to 'mysql-test/t/events_bugs.test')
-rw-r--r-- | mysql-test/t/events_bugs.test | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/t/events_bugs.test b/mysql-test/t/events_bugs.test index 04c6d8e91f5..c9a8842f8f0 100644 --- a/mysql-test/t/events_bugs.test +++ b/mysql-test/t/events_bugs.test @@ -80,7 +80,7 @@ end| delimiter ;| --sleep 0.8 --echo "Now if everything is fine the event has compiled and is locked -select /*1*/ user, host, db, info from information_schema.processlist where info is null or info not like '%processlist%' order by info; +select /*1*/ user, host, db, info from information_schema.processlist where command!='Daemon' and (info is null or info not like '%processlist%') order by info; select release_lock('test_bug16407'); set global event_scheduler= off; @@ -128,10 +128,10 @@ end| delimiter ;| select event_schema, event_name, sql_mode from information_schema.events order by event_schema, event_name; --sleep 1 -select /*2*/ user, host, db, info from information_schema.processlist where info is null or info not like '%processlist%' order by info; +select /*2*/ user, host, db, info from information_schema.processlist where (command!='Daemon' || user='event_scheduler') and (info is null or info not like '%processlist%') order by info; select release_lock('ee_16407_2'); --sleep 1.2 -select /*3*/ user, host, db, info from information_schema.processlist where info is null or info not like '%processlist%' order by info; +select /*3*/ user, host, db, info from information_schema.processlist where (command!='Daemon' || user='event_scheduler') and (info is null or info not like '%processlist%') order by info; set global event_scheduler= off; select * from events_smode_test order by ev_name, a; --echo "OK, last check before we drop them" @@ -167,11 +167,11 @@ end| delimiter ;| --sleep 1 --echo "Should have 2 locked processes" -select /*4*/ user, host, db, info from information_schema.processlist where info is null or info not like '%processlist%' order by info; +select /*4*/ user, host, db, info from information_schema.processlist where (command!='Daemon' || user='event_scheduler') and (info is null or info not like '%processlist%') order by info; select release_lock('ee_16407_5'); --sleep 1.3 --echo "Should have 0 processes locked" -select /*5*/ user, host, db, info from information_schema.processlist where info is null or info not like '%processlist%' order by info; +select /*5*/ user, host, db, info from information_schema.processlist where (command!='Daemon' || user='event_scheduler') and (info is null or info not like '%processlist%') order by info; select * from events_smode_test order by ev_name, a; --echo "And here we check one more time before we drop the events" select event_schema, event_name, sql_mode from information_schema.events order by event_schema, event_name; |