Debian Codegraph @

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

raw
1 SET @start_value = @@global.autocommit;
2 SELECT @start_value;
3 @start_value
4 1
5 '#--------------------FN_DYNVARS_003_01------------------------#'
6 SET @@autocommit = 0;
7 SET @@autocommit = DEFAULT;
8 SELECT @@autocommit;
9 @@autocommit
10 1
11 '#---------------------FN_DYNVARS_003_02-------------------------#'
12 SET @@autocommit = @start_value;
13 SELECT @@autocommit = 1;
14 @@autocommit = 1
15 1
16 '#--------------------FN_DYNVARS_003_03------------------------#'
17 SET @@autocommit = 0;
18 SELECT @@autocommit;
19 @@autocommit
20 0
21 SET @@autocommit = 1;
22 SELECT @@autocommit;
23 @@autocommit
24 1
25 '#--------------------FN_DYNVARS_003_04-------------------------#'
26 SET @@autocommit = 2;
27 ERROR 42000: Variable 'autocommit' can't be set to the value of '2'
28 SET @@autocommit = -1;
29 ERROR 42000: Variable 'autocommit' can't be set to the value of '-1'
30 SET @@autocommit = TRUEF;
31 ERROR 42000: Variable 'autocommit' can't be set to the value of 'TRUEF'
32 SET @@autocommit = TRUE_F;
33 ERROR 42000: Variable 'autocommit' can't be set to the value of 'TRUE_F'
34 SET @@autocommit = FALSE0;
35 ERROR 42000: Variable 'autocommit' can't be set to the value of 'FALSE0'
36 SET @@autocommit = OON;
37 ERROR 42000: Variable 'autocommit' can't be set to the value of 'OON'
38 SET @@autocommit = ONN;
39 ERROR 42000: Variable 'autocommit' can't be set to the value of 'ONN'
40 SET @@autocommit = OOFF;
41 ERROR 42000: Variable 'autocommit' can't be set to the value of 'OOFF'
42 SET @@autocommit = 0FF;
43 ERROR 42000: Variable 'autocommit' can't be set to the value of '0FF'
44 SET @@autocommit = ' ';
45 ERROR 42000: Variable 'autocommit' can't be set to the value of ' '
46 SET @@autocommit = " ";
47 ERROR 42000: Variable 'autocommit' can't be set to the value of ' '
48 SET @@autocommit = '';
49 ERROR 42000: Variable 'autocommit' can't be set to the value of ''
50 '#-------------------FN_DYNVARS_003_05----------------------------#'
51 SET @@global.autocommit = 0;
52 SELECT @@global.autocommit;
53 @@global.autocommit
54 0
55 SET @@global.autocommit = 1;
56 '#----------------------FN_DYNVARS_003_06------------------------#'
57 SELECT IF(@@session.autocommit, "ON", "OFF") = VARIABLE_VALUE
58 FROM performance_schema.session_variables
59 WHERE VARIABLE_NAME='autocommit';
60 IF(@@session.autocommit, "ON", "OFF") = VARIABLE_VALUE
61 1
62 '#----------------------FN_DYNVARS_003_07------------------------#'
63 SET @@autocommit = 1;
64 SELECT IF(@@autocommit, "ON", "OFF") = VARIABLE_VALUE
65 FROM performance_schema.global_variables
66 WHERE VARIABLE_NAME='autocommit';
67 IF(@@autocommit, "ON", "OFF") = VARIABLE_VALUE
68 1
69 '#---------------------FN_DYNVARS_003_08-------------------------#'
70 SET @@autocommit = OFF;
71 SELECT @@autocommit;
72 @@autocommit
73 0
74 SET @@autocommit = ON;
75 SELECT @@autocommit;
76 @@autocommit
77 1
78 '#---------------------FN_DYNVARS_003_09----------------------#'
79 SET @@autocommit = TRUE;
80 SELECT @@autocommit;
81 @@autocommit
82 1
83 SET @@autocommit = FALSE;
84 SELECT @@autocommit;
85 @@autocommit
86 0
87 '#---------------------FN_DYNVARS_003_10----------------------#'
88 SET @@autocommit = 0;
89 SELECT @@autocommit = @@local.autocommit;
90 @@autocommit = @@local.autocommit
91 1
92 SELECT @@local.autocommit = @@session.autocommit;
93 @@local.autocommit = @@session.autocommit
94 1
95 SET @@autocommit = 1;
96 SELECT @@autocommit = @@local.autocommit;
97 @@autocommit = @@local.autocommit
98 1
99 SELECT @@session.autocommit = @@autocommit;
100 @@session.autocommit = @@autocommit
101 1
102 '#---------------------FN_DYNVARS_003_11----------------------#'
103 SET autocommit = 1;
104 SELECT @@autocommit;
105 @@autocommit
106 1
107 SELECT local.autocommit;
108 ERROR 42S02: Unknown table 'local' in field list
109 SELECT session.autocommit;
110 ERROR 42S02: Unknown table 'session' in field list
111 SELECT autocommit = @@session.autocommit;
112 ERROR 42S22: Unknown column 'autocommit' in 'field list'
113 SET @@global.autocommit = @start_value;
114 SELECT @@global.autocommit;
115 @@global.autocommit
116 1