summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp.result
diff options
context:
space:
mode:
authorGeorgi Kodinov <Georgi.Kodinov@Oracle.com>2012-01-12 16:44:37 +0200
committerGeorgi Kodinov <Georgi.Kodinov@Oracle.com>2012-01-12 16:44:37 +0200
commitfa7a8e97a7bfda3f262ac06a7bc77cc2c0fed3ba (patch)
tree49a70370e684e43136f624db8f965a39865bc6e9 /mysql-test/r/sp.result
parent63a0c3078b708bb7f985e33d22e5127244466aff (diff)
parentd0a58c1e7a5f32566390180cd3f8380258e49730 (diff)
downloadmariadb-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.result15
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()