diff options
Diffstat (limited to 'mysql-test/main/events_slowlog.result')
| -rw-r--r-- | mysql-test/main/events_slowlog.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/events_slowlog.result b/mysql-test/main/events_slowlog.result new file mode 100644 index 00000000..be0a1e78 --- /dev/null +++ b/mysql-test/main/events_slowlog.result @@ -0,0 +1,13 @@ +set @event_scheduler_save= @@global.event_scheduler; +set @slow_query_log_save= @@global.slow_query_log; +set global event_scheduler= on; +set global slow_query_log= on; +set global long_query_time=0.2; +create table t1 (i int); +insert into t1 values (0); +create event ev on schedule at CURRENT_TIMESTAMP + INTERVAL 1 second do update t1 set i=1+sleep(0.5); +FOUND 1 /update t1 set i=1/ in mysqld-slow.log +drop table t1; +set global event_scheduler= @event_scheduler_save; +set global slow_query_log= @slow_query_log_save; +set global long_query_time= @@session.long_query_time; |