Debian Codegraph @

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

raw
1 SET @session_start_value = @@session.innodb_table_locks;
2 SELECT @session_start_value;
3 @session_start_value
4 1
5 SET @global_start_value = @@global.innodb_table_locks;
6 SELECT @global_start_value;
7 @global_start_value
8 1
9 '#--------------------FN_DYNVARS_046_01------------------------#'
10 SET @@session.innodb_table_locks = 0;
11 SET @@session.innodb_table_locks = DEFAULT;
12 SELECT @@session.innodb_table_locks;
13 @@session.innodb_table_locks
14 1
15 SET @@global.innodb_table_locks = 0;
16 SET @@global.innodb_table_locks = DEFAULT;
17 SELECT @@global.innodb_table_locks;
18 @@global.innodb_table_locks
19 1
20 '#---------------------FN_DYNVARS_046_02-------------------------#'
21 SET innodb_table_locks = 1;
22 SELECT @@innodb_table_locks;
23 @@innodb_table_locks
24 1
25 SELECT session.innodb_table_locks;
26 ERROR 42S02: Unknown table 'session' in field list
27 SELECT local.innodb_table_locks;
28 ERROR 42S02: Unknown table 'local' in field list
29 SELECT global.innodb_table_locks;
30 ERROR 42S02: Unknown table 'global' in field list
31 SET session innodb_table_locks = 0;
32 SELECT @@session.innodb_table_locks;
33 @@session.innodb_table_locks
34 0
35 SET global innodb_table_locks = 0;
36 SELECT @@global.innodb_table_locks;
37 @@global.innodb_table_locks
38 0
39 '#--------------------FN_DYNVARS_046_03------------------------#'
40 SET @@session.innodb_table_locks = 0;
41 SELECT @@session.innodb_table_locks;
42 @@session.innodb_table_locks
43 0
44 SET @@session.innodb_table_locks = 1;
45 SELECT @@session.innodb_table_locks;
46 @@session.innodb_table_locks
47 1
48 SET @@global.innodb_table_locks = 0;
49 SELECT @@global.innodb_table_locks;
50 @@global.innodb_table_locks
51 0
52 SET @@global.innodb_table_locks = 1;
53 SELECT @@global.innodb_table_locks;
54 @@global.innodb_table_locks
55 1
56 '#--------------------FN_DYNVARS_046_04-------------------------#'
57 SET @@session.innodb_table_locks = -6;
58 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '-6'
59 SET @@session.innodb_table_locks = 1.6;
60 ERROR 42000: Incorrect argument type to variable 'innodb_table_locks'
61 SET @@session.innodb_table_locks = "T";
62 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'T'
63 SET @@session.innodb_table_locks = "Y";
64 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'Y'
65 SET @@session.innodb_table_locks = TRÜE;
66 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'TRÜE'
67 SET @@session.innodb_table_locks = ÕN;
68 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'ÕN'
69 SET @@session.innodb_table_locks = OF;
70 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OF' at line 1
71 SELECT @@session.innodb_table_locks;
72 @@session.innodb_table_locks
73 1
74 SET @@session.innodb_table_locks = ÓFF;
75 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'ÓFF'
76 SET @@global.innodb_table_locks = -1;
77 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '-1'
78 SET @@global.innodb_table_locks = 2;
79 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of '2'
80 SET @@global.innodb_table_locks = "T";
81 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'T'
82 SET @@global.innodb_table_locks = "Y";
83 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'Y'
84 SET @@global.innodb_table_locks = TRÜE;
85 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'TRÜE'
86 SET @@global.innodb_table_locks = QN;
87 ERROR 42000: Variable 'innodb_table_locks' can't be set to the value of 'QN'
88 SET @@global.innodb_table_locks = OF;
89 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OF' at line 1
90 SELECT @@global.innodb_table_locks;
91 @@global.innodb_table_locks
92 1
93 '#-------------------FN_DYNVARS_046_05----------------------------#'
94 SET @@global.innodb_table_locks = 0;
95 SET @@session.innodb_table_locks = 1;
96 SELECT @@global.innodb_table_locks AS res_is_0;
97 res_is_0
98 0
99 SET @@global.innodb_table_locks = 0;
100 SELECT @@session.innodb_table_locks AS res_is_1;
101 res_is_1
102 1
103 '#----------------------FN_DYNVARS_046_06------------------------#'
104 SELECT IF(@@global.innodb_table_locks, "ON", "OFF") =
105 VARIABLE_VALUE FROM performance_schema.global_variables
106 WHERE VARIABLE_NAME='innodb_table_locks';
107 IF(@@global.innodb_table_locks, "ON", "OFF") =
108 VARIABLE_VALUE
109 1
110 SELECT @@global.innodb_table_locks;
111 @@global.innodb_table_locks
112 0
113 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
114 WHERE VARIABLE_NAME='innodb_table_locks';
115 VARIABLE_VALUE
116 OFF
117 '#----------------------FN_DYNVARS_046_07------------------------#'
118 SELECT IF(@@session.innodb_table_locks, "ON", "OFF") =
119 VARIABLE_VALUE FROM performance_schema.session_variables
120 WHERE VARIABLE_NAME='innodb_table_locks';
121 IF(@@session.innodb_table_locks, "ON", "OFF") =
122 VARIABLE_VALUE
123 1
124 SELECT @@session.innodb_table_locks;
125 @@session.innodb_table_locks
126 1
127 SELECT VARIABLE_VALUE FROM performance_schema.session_variables
128 WHERE VARIABLE_NAME='innodb_table_locks';
129 VARIABLE_VALUE
130 ON
131 '#---------------------FN_DYNVARS_046_08-------------------------#'
132 SET @@session.innodb_table_locks = OFF;
133 SELECT @@session.innodb_table_locks;
134 @@session.innodb_table_locks
135 0
136 SET @@session.innodb_table_locks = ON;
137 SELECT @@session.innodb_table_locks;
138 @@session.innodb_table_locks
139 1
140 SET @@global.innodb_table_locks = OFF;
141 SELECT @@global.innodb_table_locks;
142 @@global.innodb_table_locks
143 0
144 SET @@global.innodb_table_locks = ON;
145 SELECT @@global.innodb_table_locks;
146 @@global.innodb_table_locks
147 1
148 '#---------------------FN_DYNVARS_046_09----------------------#'
149 SET @@session.innodb_table_locks = TRUE;
150 SELECT @@session.innodb_table_locks;
151 @@session.innodb_table_locks
152 1
153 SET @@session.innodb_table_locks = FALSE;
154 SELECT @@session.innodb_table_locks;
155 @@session.innodb_table_locks
156 0
157 SET @@global.innodb_table_locks = TRUE;
158 SELECT @@global.innodb_table_locks;
159 @@global.innodb_table_locks
160 1
161 SET @@global.innodb_table_locks = FALSE;
162 SELECT @@global.innodb_table_locks;
163 @@global.innodb_table_locks
164 0
165 SET @@session.innodb_table_locks = @session_start_value;
166 SELECT @@session.innodb_table_locks;
167 @@session.innodb_table_locks
168 1
169 SET @@global.innodb_table_locks = @global_start_value;
170 SELECT @@global.innodb_table_locks;
171 @@global.innodb_table_locks
172 1