diff options
author | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2012-01-12 16:44:37 +0200 |
---|---|---|
committer | Georgi Kodinov <Georgi.Kodinov@Oracle.com> | 2012-01-12 16:44:37 +0200 |
commit | b8cbc736d0ab7c08209ee0a4be9f4b82926c1c27 (patch) | |
tree | 49a70370e684e43136f624db8f965a39865bc6e9 /mysql-test/r/sp.result | |
parent | f621aa902074d6d28f42ffc4e7ce2e0c594c0ab6 (diff) | |
parent | 529b0f64c241785e25881b3f4e80719c9cd66268 (diff) | |
download | mariadb-git-b8cbc736d0ab7c08209ee0a4be9f4b82926c1c27.tar.gz |
weave merge mysql-5.5->mysql-5.5-security
Diffstat (limited to 'mysql-test/r/sp.result')
-rw-r--r-- | mysql-test/r/sp.result | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 0f5ab0af1c3..781abca566d 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -2772,20 +2772,23 @@ userid drop procedure bug8116| drop table t3| drop procedure if exists bug6857| -create procedure bug6857(counter int) +create procedure bug6857() begin declare t0, t1 int; declare plus bool default 0; -set t0 = current_time(); -while counter > 0 do -set counter = counter - 1; -end while; -set t1 = current_time(); +set t0 = unix_timestamp(); +select sleep(1.1); +set t1 = unix_timestamp(); if t1 > t0 then set plus = 1; end if; select plus; end| +call bug6857()| +sleep(1.1) +0 +plus +1 drop procedure bug6857| drop procedure if exists bug8757| create procedure bug8757() |