Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.lock_wait_timeout;
2 SELECT @start_global_value;
3 @start_global_value
4 86400
5 SET @start_session_value = @@session.lock_wait_timeout;
6 SELECT @start_session_value;
7 @start_session_value
8 86400
9 '#--------------------FN_DYNVARS_002_01-------------------------#'
10 SET @@global.lock_wait_timeout = 100;
11 SET @@global.lock_wait_timeout = DEFAULT;
12 SELECT @@global.lock_wait_timeout;
13 @@global.lock_wait_timeout
14 86400
15 SET @@session.lock_wait_timeout = 200;
16 SET @@session.lock_wait_timeout = DEFAULT;
17 SELECT @@session.lock_wait_timeout;
18 @@session.lock_wait_timeout
19 86400
20 '#--------------------FN_DYNVARS_002_02-------------------------#'
21 SET @@global.lock_wait_timeout = @start_global_value;
22 SELECT @@global.lock_wait_timeout = 31536000;
23 @@global.lock_wait_timeout = 31536000
24 0
25 SET @@session.lock_wait_timeout = @start_session_value;
26 SELECT @@session.lock_wait_timeout = 31536000;
27 @@session.lock_wait_timeout = 31536000
28 0
29 '#--------------------FN_DYNVARS_002_03-------------------------#'
30 SET @@global.lock_wait_timeout = 1;
31 SELECT @@global.lock_wait_timeout;
32 @@global.lock_wait_timeout
33 1
34 SET @@global.lock_wait_timeout = 60020;
35 SELECT @@global.lock_wait_timeout;
36 @@global.lock_wait_timeout
37 60020
38 SET @@global.lock_wait_timeout = 65535;
39 SELECT @@global.lock_wait_timeout;
40 @@global.lock_wait_timeout
41 65535
42 '#--------------------FN_DYNVARS_002_04-------------------------#'
43 SET @@session.lock_wait_timeout = 1;
44 SELECT @@session.lock_wait_timeout;
45 @@session.lock_wait_timeout
46 1
47 SET @@session.lock_wait_timeout = 50050;
48 SELECT @@session.lock_wait_timeout;
49 @@session.lock_wait_timeout
50 50050
51 SET @@session.lock_wait_timeout = 65535;
52 SELECT @@session.lock_wait_timeout;
53 @@session.lock_wait_timeout
54 65535
55 '#------------------FN_DYNVARS_002_05-----------------------#'
56 SET @@global.lock_wait_timeout = 0;
57 SELECT @@global.lock_wait_timeout;
58 @@global.lock_wait_timeout
59 0
60 SET @@global.lock_wait_timeout = -1024;
61 Warnings:
62 Warning 1292 Truncated incorrect lock_wait_timeout value: '-1024'
63 SELECT @@global.lock_wait_timeout;
64 @@global.lock_wait_timeout
65 0
66 SET @@global.lock_wait_timeout = 31536001;
67 Warnings:
68 Warning 1292 Truncated incorrect lock_wait_timeout value: '31536001'
69 SELECT @@global.lock_wait_timeout;
70 @@global.lock_wait_timeout
71 31536000
72 SET @@global.lock_wait_timeout = ON;
73 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
74 SELECT @@global.lock_wait_timeout;
75 @@global.lock_wait_timeout
76 31536000
77 SET @@global.lock_wait_timeout = OFF;
78 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
79 SELECT @@global.lock_wait_timeout;
80 @@global.lock_wait_timeout
81 31536000
82 SET @@global.lock_wait_timeout = test;
83 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
84 SELECT @@global.lock_wait_timeout;
85 @@global.lock_wait_timeout
86 31536000
87 SET @@session.lock_wait_timeout = 0;
88 SELECT @@session.lock_wait_timeout;
89 @@session.lock_wait_timeout
90 0
91 SET @@session.lock_wait_timeout = -2;
92 Warnings:
93 Warning 1292 Truncated incorrect lock_wait_timeout value: '-2'
94 SELECT @@session.lock_wait_timeout;
95 @@session.lock_wait_timeout
96 0
97 SET @@session.lock_wait_timeout = 31537000;
98 Warnings:
99 Warning 1292 Truncated incorrect lock_wait_timeout value: '31537000'
100 SELECT @@session.lock_wait_timeout;
101 @@session.lock_wait_timeout
102 31536000
103 SET @@session.lock_wait_timeout = ON;
104 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
105 SELECT @@session.lock_wait_timeout;
106 @@session.lock_wait_timeout
107 31536000
108 SET @@session.lock_wait_timeout = OFF;
109 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
110 SELECT @@session.lock_wait_timeout;
111 @@session.lock_wait_timeout
112 31536000
113 SET @@session.lock_wait_timeout = test;
114 ERROR 42000: Incorrect argument type to variable 'lock_wait_timeout'
115 SELECT @@session.lock_wait_timeout;
116 @@session.lock_wait_timeout
117 31536000
118 '#------------------FN_DYNVARS_002_06-----------------------#'
119 SELECT @@global.lock_wait_timeout = VARIABLE_VALUE
120 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
121 WHERE VARIABLE_NAME='lock_wait_timeout';
122 @@global.lock_wait_timeout = VARIABLE_VALUE
123 1
124 '#------------------FN_DYNVARS_002_07-----------------------#'
125 SELECT @@session.lock_wait_timeout = VARIABLE_VALUE
126 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
127 WHERE VARIABLE_NAME='lock_wait_timeout';
128 @@session.lock_wait_timeout = VARIABLE_VALUE
129 1
130 '#------------------FN_DYNVARS_002_08-----------------------#'
131 SET @@global.lock_wait_timeout = TRUE;
132 SELECT @@global.lock_wait_timeout;
133 @@global.lock_wait_timeout
134 1
135 SET @@global.lock_wait_timeout = FALSE;
136 SELECT @@global.lock_wait_timeout;
137 @@global.lock_wait_timeout
138 0
139 '#---------------------FN_DYNVARS_001_09----------------------#'
140 SET @@global.lock_wait_timeout = 10;
141 SET @@session.lock_wait_timeout = 11;
142 SELECT @@lock_wait_timeout = @@global.lock_wait_timeout;
143 @@lock_wait_timeout = @@global.lock_wait_timeout
144 0
145 '#---------------------FN_DYNVARS_001_10----------------------#'
146 SET @@lock_wait_timeout = 100;
147 SELECT @@lock_wait_timeout = @@local.lock_wait_timeout;
148 @@lock_wait_timeout = @@local.lock_wait_timeout
149 1
150 SELECT @@local.lock_wait_timeout = @@session.lock_wait_timeout;
151 @@local.lock_wait_timeout = @@session.lock_wait_timeout
152 1
153 '#---------------------FN_DYNVARS_001_11----------------------#'
154 SET lock_wait_timeout = 1;
155 SELECT @@lock_wait_timeout;
156 @@lock_wait_timeout
157 1
158 SELECT local.lock_wait_timeout;
159 ERROR 42S02: Unknown table 'local' in SELECT
160 SELECT session.lock_wait_timeout;
161 ERROR 42S02: Unknown table 'session' in SELECT
162 SELECT lock_wait_timeout = @@session.lock_wait_timeout;
163 ERROR 42S22: Unknown column 'lock_wait_timeout' in 'SELECT'
164 SET @@global.lock_wait_timeout = @start_global_value;
165 SELECT @@global.lock_wait_timeout;
166 @@global.lock_wait_timeout
167 86400
168 SET @@session.lock_wait_timeout = @start_session_value;
169 SELECT @@session.lock_wait_timeout;
170 @@session.lock_wait_timeout
171 86400