Debian Codegraph @

mysql-test/suite/sys_vars/r/in_transaction_basic.result

raw
1 select @@global.in_transaction;
2 ERROR HY000: Variable 'in_transaction' is a SESSION variable
3 select @@session.in_transaction;
4 @@session.in_transaction
5 0
6 show global variables like 'in_transaction';
7 Variable_name Value
8 show session variables like 'in_transaction';
9 Variable_name Value
10 in_transaction 0
11 select * from information_schema.global_variables where variable_name='in_transaction';
12 VARIABLE_NAME VARIABLE_VALUE
13 select * from information_schema.session_variables where variable_name='in_transaction';
14 VARIABLE_NAME VARIABLE_VALUE
15 IN_TRANSACTION 0
16 set global in_transaction=1;
17 ERROR HY000: Variable 'in_transaction' is a read only variable
18 set session in_transaction=1;
19 ERROR HY000: Variable 'in_transaction' is a read only variable