Debian Codegraph @

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

raw
1 #### mysql-test\suite\sys_vars\t\session_track_transaction_info_basic.test ####
2 # #
3 # Variable Name: session_track_transaction_info #
4 # Scope: Global & Session #
5 # Data Type: enumeration #
6 # Default: 0 #
7 # Accepted Values: 0, 1, 2 #
8 # #
9 # #
10 # Creation Date: 2015-01-01 #
11 # #
12 # #
13 # Description:Test Cases of Dynamic System Variable #
14 # session_track_transaction_info #
15 # that checks the behavior of this variable in the following ways #
16 # * Value Check #
17 # * Scope Check #
18 # #
19 ###############################################################################
20
21 SELECT @@session.session_track_transaction_info INTO @old_track_tx;
22 SELECT @@global.session_track_transaction_info INTO @old_track_tx_gbl;
23
24 SELECT @@global.session_track_transaction_info;
25 SELECT @@session.session_track_transaction_info;
26
27 SET SESSION session_track_transaction_info=0;
28 SELECT @@session.session_track_transaction_info;
29
30 SET SESSION session_track_transaction_info=1;
31 SELECT @@session.session_track_transaction_info;
32
33 SET SESSION session_track_transaction_info=2;
34 SELECT @@session.session_track_transaction_info;
35
36 SET SESSION session_track_transaction_info=DEFAULT;
37 SELECT @@session.session_track_transaction_info;
38
39 --error ER_WRONG_TYPE_FOR_VAR
40 SET SESSION session_track_transaction_info=1.1;
41
42 SET SESSION session_track_transaction_info='OFF';
43 SELECT @@session.session_track_transaction_info;
44
45 --error ER_WRONG_VALUE_FOR_VAR
46 SET SESSION session_track_transaction_info='on';
47
48 SET SESSION session_track_transaction_info='STATE';
49 SELECT @@session.session_track_transaction_info;
50
51 SET SESSION session_track_transaction_info='CHARACTERISTICS';
52 SELECT @@session.session_track_transaction_info;
53
54 # Like most system variables, and unlike transaction_isolation/
55 # transaction_read_only, session_track_transaction_info has two
56 # scopes, SESSION and GLOBAL, with the default being SESSION.
57
58 SET SESSION session_track_transaction_info='OFF';
59 SET GLOBAL session_track_transaction_info='STATE';
60 SET session_track_transaction_info='CHARACTERISTICS';
61 SELECT @@global.session_track_transaction_info;
62 SELECT @@session.session_track_transaction_info;
63 SELECT @@session_track_transaction_info;
64 SET GLOBAL session_track_transaction_info='OFF';
65 SET session_track_transaction_info='CHARACTERISTICS';
66 SET SESSION session_track_transaction_info='STATE';
67 SELECT @@global.session_track_transaction_info;
68 SELECT @@session.session_track_transaction_info;
69 SELECT @@session_track_transaction_info;
70
71 # clean up
72
73 SET SESSION session_track_transaction_info=@old_track_tx;
74 SET GLOBAL session_track_transaction_info=@old_track_tx_gbl;