summaryrefslogtreecommitdiff
path: root/mysql-test/r/rpl_sp_effects.result
diff options
context:
space:
mode:
authorsergefp@mysql.com <>2005-08-25 18:13:56 +0400
committersergefp@mysql.com <>2005-08-25 18:13:56 +0400
commit6d25f5629750b5239e60fc3ac596eaa9d8144f55 (patch)
tree544b7149d956f887280acfc4cdda41f65ba48def /mysql-test/r/rpl_sp_effects.result
parentc78ce166815bd32d2f922b93fe33840aa9f8c1a8 (diff)
downloadmariadb-git-6d25f5629750b5239e60fc3ac596eaa9d8144f55.tar.gz
BUG#12335: merging: temporarily removed a test case that demonstrates wrong behaviour and does it in non-deterministic way.
Diffstat (limited to 'mysql-test/r/rpl_sp_effects.result')
-rw-r--r--mysql-test/r/rpl_sp_effects.result58
1 files changed, 0 insertions, 58 deletions
diff --git a/mysql-test/r/rpl_sp_effects.result b/mysql-test/r/rpl_sp_effects.result
index 738fd08450a..8bcbf1a60d0 100644
--- a/mysql-test/r/rpl_sp_effects.result
+++ b/mysql-test/r/rpl_sp_effects.result
@@ -156,61 +156,3 @@ slave: 6
drop procedure p1;
drop function f1;
drop table t1,t2;
-create table t1 (a int);
-create table t2 (a char(200));
-create procedure p1()
-begin
-declare dummy int;
-while ((select count(*) from t1) < 1) do
-set dummy = sleep(1);
-end while;
-end//
-create procedure p2()
-begin
-select f1();
-call p1();
-delete from t1 limit 1;
-select f1();
-call p1();
-delete from t1 limit 1;
-select f1();
-end//
-create function f1() returns int
-begin
-insert into t2 values('f1-r1');
-return 0;
-end//
- call p2();
-drop function f1//
-create function f1() returns int
-begin
-insert into t2 values('f1-r2');
-return 0;
-end//
-insert into t1 values (1) //
-call p1()//
-drop function f1//
-create function f1() returns int
-begin
-insert into t2 values('f1-r3');
-return 0;
-end//
-insert into t1 values (1) //
-call p1()//
-f1()
-0
-f1()
-0
-f1()
-0
-select * from t2;
-a
-f1-r1
-f1-r1
-f1-r1
-select * from t2;
-a
-f1-r1
-f1-r3
-f1-r3
-drop table t1;