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 | fa7a8e97a7bfda3f262ac06a7bc77cc2c0fed3ba (patch) | |
tree | 49a70370e684e43136f624db8f965a39865bc6e9 /mysql-test/r/sp.result | |
parent | 63a0c3078b708bb7f985e33d22e5127244466aff (diff) | |
parent | d0a58c1e7a5f32566390180cd3f8380258e49730 (diff) | |
download | mariadb-git-fa7a8e97a7bfda3f262ac06a7bc77cc2c0fed3ba.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() |