Debian Codegraph @

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

raw
1 SET @start_global_value = @@session.transaction_allow_batching;
2 SELECT @start_global_value as "Should be off by default";
3 Should be off by default
4 0
5 select @@global.transaction_allow_batching;
6 ERROR HY000: Variable 'transaction_allow_batching' is a SESSION variable
7 select @@session.transaction_allow_batching;
8 @@session.transaction_allow_batching
9 0
10 show global variables like 'transaction_allow_batching';
11 Variable_name Value
12 show session variables like 'transaction_allow_batching';
13 Variable_name Value
14 transaction_allow_batching OFF
15 select * from performance_schema.global_variables where variable_name='transaction_allow_batching';
16 VARIABLE_NAME VARIABLE_VALUE
17 select * from performance_schema.session_variables where variable_name='transaction_allow_batching';
18 VARIABLE_NAME VARIABLE_VALUE
19 transaction_allow_batching OFF
20 set global transaction_allow_batching = 1;
21 ERROR HY000: Variable 'transaction_allow_batching' is a SESSION variable and can't be used with SET GLOBAL
22 set session transaction_allow_batching = TRUE;
23 select @@session.transaction_allow_batching;
24 @@session.transaction_allow_batching
25 1
26 set transaction_allow_batching=1.1;
27 ERROR 42000: Incorrect argument type to variable 'transaction_allow_batching'
28 set transaction_allow_batching=1e1;
29 ERROR 42000: Incorrect argument type to variable 'transaction_allow_batching'
30 set transaction_allow_batching="foobar";
31 ERROR 42000: Variable 'transaction_allow_batching' can't be set to the value of 'foobar'
32 set session transaction_allow_batching = @start_global_value;
33 select @@session.transaction_allow_batching;
34 @@session.transaction_allow_batching
35 0