From 5a9ba869a6e747224682946a7415c53df07f4a0e Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Fri, 1 Jul 2011 10:20:11 +0200 Subject: Added read only system variable 'in_transaction' which tells if there's an active transaction. fixed a bug - not clearing "in transaction" status on set @@autocommit=1 --- mysql-test/t/status_user.test | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) (limited to 'mysql-test/t/status_user.test') diff --git a/mysql-test/t/status_user.test b/mysql-test/t/status_user.test index d42f81b20e5..802e2207d3d 100644 --- a/mysql-test/t/status_user.test +++ b/mysql-test/t/status_user.test @@ -85,5 +85,25 @@ select connected_time <> 0, busy_time <> 0, bytes_received <> 0, bytes_sent <> 0, binlog_bytes_written <> 0 from information_schema.client_statistics; +# +# Test of in transaction +# + +create table t1 (a int) engine=innodb; +select @@in_transaction; +begin; +select @@in_transaction; +insert into t1 values (1); +select @@in_transaction; +commit; +select @@in_transaction; +set @@autocommit=0; +select @@in_transaction; +insert into t1 values (2); +select @@in_transaction; +set @@autocommit=1; +select @@in_transaction; +drop table t1; + # Cleanup set @@global.general_log=@save_general_log; -- cgit v1.2.1