Debian Codegraph @

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

raw
1 SELECT @@session.session_track_transaction_info INTO @old_track_tx;
2 SELECT @@global.session_track_transaction_info INTO @old_track_tx_gbl;
3 SELECT @@global.session_track_transaction_info;
4 @@global.session_track_transaction_info
5 OFF
6 SELECT @@session.session_track_transaction_info;
7 @@session.session_track_transaction_info
8 OFF
9 SET SESSION session_track_transaction_info=0;
10 SELECT @@session.session_track_transaction_info;
11 @@session.session_track_transaction_info
12 OFF
13 SET SESSION session_track_transaction_info=1;
14 SELECT @@session.session_track_transaction_info;
15 @@session.session_track_transaction_info
16 STATE
17 SET SESSION session_track_transaction_info=2;
18 SELECT @@session.session_track_transaction_info;
19 @@session.session_track_transaction_info
20 CHARACTERISTICS
21 SET SESSION session_track_transaction_info=DEFAULT;
22 SELECT @@session.session_track_transaction_info;
23 @@session.session_track_transaction_info
24 OFF
25 SET SESSION session_track_transaction_info=1.1;
26 ERROR 42000: Incorrect argument type to variable 'session_track_transaction_info'
27 SET SESSION session_track_transaction_info='OFF';
28 SELECT @@session.session_track_transaction_info;
29 @@session.session_track_transaction_info
30 OFF
31 SET SESSION session_track_transaction_info='on';
32 ERROR 42000: Variable 'session_track_transaction_info' can't be set to the value of 'on'
33 SET SESSION session_track_transaction_info='STATE';
34 SELECT @@session.session_track_transaction_info;
35 @@session.session_track_transaction_info
36 STATE
37 SET SESSION session_track_transaction_info='CHARACTERISTICS';
38 SELECT @@session.session_track_transaction_info;
39 @@session.session_track_transaction_info
40 CHARACTERISTICS
41 SET SESSION session_track_transaction_info='OFF';
42 SET GLOBAL session_track_transaction_info='STATE';
43 SET session_track_transaction_info='CHARACTERISTICS';
44 SELECT @@global.session_track_transaction_info;
45 @@global.session_track_transaction_info
46 STATE
47 SELECT @@session.session_track_transaction_info;
48 @@session.session_track_transaction_info
49 CHARACTERISTICS
50 SELECT @@session_track_transaction_info;
51 @@session_track_transaction_info
52 CHARACTERISTICS
53 SET GLOBAL session_track_transaction_info='OFF';
54 SET session_track_transaction_info='CHARACTERISTICS';
55 SET SESSION session_track_transaction_info='STATE';
56 SELECT @@global.session_track_transaction_info;
57 @@global.session_track_transaction_info
58 OFF
59 SELECT @@session.session_track_transaction_info;
60 @@session.session_track_transaction_info
61 STATE
62 SELECT @@session_track_transaction_info;
63 @@session_track_transaction_info
64 STATE
65 SET SESSION session_track_transaction_info=@old_track_tx;
66 SET GLOBAL session_track_transaction_info=@old_track_tx_gbl;