From 03c71ff2ba1c5949ff715e64008cfdb291c6b14a Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Mon, 1 Jul 2013 12:02:44 +0200 Subject: MDEV-4683 query start_time not reset when going to sleep --- mysql-test/t/processlist.test | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'mysql-test/t/processlist.test') diff --git a/mysql-test/t/processlist.test b/mysql-test/t/processlist.test index eff1daff3aa..c7b775cf992 100644 --- a/mysql-test/t/processlist.test +++ b/mysql-test/t/processlist.test @@ -18,5 +18,18 @@ SET DEBUG_SYNC = 'now SIGNAL fill_schema_proceed'; connection con1; reap; +connection default; + +# +# MDEV-4683 query start_time not reset when going to sleep +# + +connection con1; +select sleep(5); #run a query that will take some time +connection default; + +# verify that the time in COM_SLEEP doesn't include the query run time +select command, time < 5 from information_schema.processlist where id != connection_id(); + disconnect con1; -- cgit v1.2.1