summaryrefslogtreecommitdiff
path: root/mysql-test/r/trigger-trans.result
diff options
context:
space:
mode:
authorVladislav Vaintroub <wlad@mariadb.com>2016-04-09 17:03:48 +0200
committerVladislav Vaintroub <wlad@mariadb.com>2016-04-09 17:03:48 +0200
commitcd776fedba3e2902bc25ee206d6e6266e7eb9411 (patch)
tree95bf82d0e0522c6af708cd28639c82e004b5a264 /mysql-test/r/trigger-trans.result
parentf884d233e6a5f68bab846a7bdbd041fc4415ad77 (diff)
parentd516a2ae0cbd09d3b5b1667ec62b421330ab9902 (diff)
downloadmariadb-git-10.2-connector-c-integ.tar.gz
Merge branch '10.2' into 10.2-connector-c-integ10.2-connector-c-integ
Diffstat (limited to 'mysql-test/r/trigger-trans.result')
-rw-r--r--mysql-test/r/trigger-trans.result9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/trigger-trans.result b/mysql-test/r/trigger-trans.result
index cab7336cbe5..c58c4230a40 100644
--- a/mysql-test/r/trigger-trans.result
+++ b/mysql-test/r/trigger-trans.result
@@ -113,13 +113,18 @@ for each row
begin
insert into t3 (c) values (1);
end|
+connect connection_aux,localhost,root,,test,,;
+connect connection_update,localhost,root,,test,,;
+connection connection_aux;
select get_lock("lock_bug26141_wait", 0);
get_lock("lock_bug26141_wait", 0)
1
+connection default;
select get_lock("lock_bug26141_sync", /* must not be priorly locked */ 0);
get_lock("lock_bug26141_sync", /* must not be priorly locked */ 0)
1
insert into t1 (c) values (2);
+connection connection_update;
select get_lock("lock_bug26141_sync", 1000);
get_lock("lock_bug26141_sync", 1000)
1
@@ -127,9 +132,11 @@ update t1 set c=3 where c=1;
select release_lock("lock_bug26141_sync");
release_lock("lock_bug26141_sync")
1
+connection connection_aux;
select release_lock("lock_bug26141_wait");
release_lock("lock_bug26141_wait")
1
+connection default;
select * from t1;
c
2
@@ -141,6 +148,8 @@ select * from t3;
c
1
drop table t1, t2, t3;
+disconnect connection_update;
+disconnect connection_aux;
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=innodb;