diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-07-01 10:20:11 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-07-01 10:20:11 +0200 |
| commit | 5a9ba869a6e747224682946a7415c53df07f4a0e (patch) | |
| tree | f0d2d17ab7f4cd41111a49a9f88a0f2a44968c92 /mysql-test/r/status_user.result | |
| parent | e696da7b573ef40da56d96f42add332409282796 (diff) | |
| download | mariadb-git-5a9ba869a6e747224682946a7415c53df07f4a0e.tar.gz | |
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
Diffstat (limited to 'mysql-test/r/status_user.result')
| -rw-r--r-- | mysql-test/r/status_user.result | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/r/status_user.result b/mysql-test/r/status_user.result index 0d1d028eb3d..bc5f0aff7e4 100644 --- a/mysql-test/r/status_user.result +++ b/mysql-test/r/status_user.result @@ -186,4 +186,33 @@ bytes_sent <> 0, binlog_bytes_written <> 0 from information_schema.client_statistics; connected_time <> 0 busy_time <> 0 bytes_received <> 0 bytes_sent <> 0 binlog_bytes_written <> 0 1 1 1 1 1 +create table t1 (a int) engine=innodb; +select @@in_transaction; +@@in_transaction +0 +begin; +select @@in_transaction; +@@in_transaction +1 +insert into t1 values (1); +select @@in_transaction; +@@in_transaction +1 +commit; +select @@in_transaction; +@@in_transaction +0 +set @@autocommit=0; +select @@in_transaction; +@@in_transaction +0 +insert into t1 values (2); +select @@in_transaction; +@@in_transaction +1 +set @@autocommit=1; +select @@in_transaction; +@@in_transaction +0 +drop table t1; set @@global.general_log=@save_general_log; |