Debian Codegraph @

mysql-test/suite/sys_vars/t/in_transaction_basic.test

raw
1 # bool readonly
2
3 #
4 # show values;
5 #
6 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
7 select @@global.in_transaction;
8 select @@session.in_transaction;
9 show global variables like 'in_transaction';
10 show session variables like 'in_transaction';
11 select * from information_schema.global_variables where variable_name='in_transaction';
12 select * from information_schema.session_variables where variable_name='in_transaction';
13
14 #
15 # show that it's read-only
16 #
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 set global in_transaction=1;
19 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
20 set session in_transaction=1;
21