diff options
| author | unknown <andrey@example.com> | 2006-09-08 00:49:37 +0200 |
|---|---|---|
| committer | unknown <andrey@example.com> | 2006-09-08 00:49:37 +0200 |
| commit | 53267edaf6db74ee4e9e598a96ee8c5c0404051e (patch) | |
| tree | 69dced6c0133a7b0b489b23f5a2d94d2275ef77b /mysql-test/r/events.result | |
| parent | 23a46f410fabb568f7746f8446eac1d38cdc2775 (diff) | |
| download | mariadb-git-53267edaf6db74ee4e9e598a96ee8c5c0404051e.tar.gz | |
fix build
Diffstat (limited to 'mysql-test/r/events.result')
| -rw-r--r-- | mysql-test/r/events.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/events.result b/mysql-test/r/events.result index 37561e3b25a..146f46edc2b 100644 --- a/mysql-test/r/events.result +++ b/mysql-test/r/events.result @@ -334,7 +334,7 @@ select definer, name, db from mysql.event; definer name db root@localhost закачка events_test "Should be only 1 process" -select /*1*/ user, host, db, command, state, info from information_schema.processlist where command!='Daemon' and (info is null or info not like '%processlist%') order by info; +select /*1*/ user, host, db, command, state, info from information_schema.processlist where (command!='Daemon' || user='event_scheduler') and (info is null or info not like '%processlist%') order by info; user host db command state info select release_lock("test_lock1"); release_lock("test_lock1") @@ -353,7 +353,7 @@ get_lock("test_lock2", 20) create event закачка on schedule every 10 hour do select get_lock("test_lock2", 20); "Let some time pass to the event starts" "Should have only 2 processes: the scheduler and the locked event" -select /*2*/ user, host, db, command, state, info from information_schema.processlist where command!='Daemon' and (info is null or info not like '%processlist%') order by info; +select /*2*/ user, host, db, command, state, info from information_schema.processlist where (command!='Daemon' || user='event_scheduler') and (info is null or info not like '%processlist%') order by info; user host db command state info event_scheduler localhost NULL Daemon Waiting for next activation NULL root localhost events_test Connect User lock select get_lock("test_lock2", 20) @@ -369,13 +369,13 @@ get_lock("test_lock2_1", 20) 1 create event закачка21 on schedule every 10 hour do select get_lock("test_lock2_1", 20); "Should have only 3 processes: the scheduler, our conn and the locked event" -select /*3*/ user, host, db, command, state, info from information_schema.processlist where command!='Daemon' and (info is null or info not like '%processlist%') order by info; +select /*3*/ user, host, db, command, state, info from information_schema.processlist where (command!='Daemon' || user='event_scheduler') and (info is null or info not like '%processlist%') order by info; user host db command state info event_scheduler localhost NULL Daemon Waiting for next activation NULL root localhost events_test Connect User lock select get_lock("test_lock2_1", 20) set global event_scheduler=off; "Should have only our process now:" -select /*4*/ user, host, db, command, state, info from information_schema.processlist where command!='Daemon' and (info is null or info not like '%processlist%') order by info; +select /*4*/ user, host, db, command, state, info from information_schema.processlist where (command!='Daemon' || user='event_scheduler') and (info is null or info not like '%processlist%') order by info; user host db command state info root localhost events_test Connect User lock select get_lock("test_lock2_1", 20) drop event закачка21; |