diff options
author | Vladislav Vaintroub <wlad@mariadb.com> | 2016-04-09 17:03:48 +0200 |
---|---|---|
committer | Vladislav Vaintroub <wlad@mariadb.com> | 2016-04-09 17:03:48 +0200 |
commit | cd776fedba3e2902bc25ee206d6e6266e7eb9411 (patch) | |
tree | 95bf82d0e0522c6af708cd28639c82e004b5a264 /mysql-test/r/trigger-trans.result | |
parent | f884d233e6a5f68bab846a7bdbd041fc4415ad77 (diff) | |
parent | d516a2ae0cbd09d3b5b1667ec62b421330ab9902 (diff) | |
download | mariadb-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.result | 9 |
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; |