Debian Codegraph @

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

raw
1 SET @start_global_value=@@global.innodb_lock_wait_timeout;
2 SELECT @start_global_value;
3 @start_global_value
4 50
5 '#---------------------BS_STVARS_032_01----------------------#'
6 SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout);
7 COUNT(@@GLOBAL.innodb_lock_wait_timeout)
8 1
9 1 Expected
10 '#---------------------BS_STVARS_032_02----------------------#'
11 SET global innodb_lock_wait_timeout=60;
12 SELECT @@global.innodb_lock_wait_timeout;
13 @@global.innodb_lock_wait_timeout
14 60
15 SET session innodb_lock_wait_timeout=60;
16 SELECT @@session.innodb_lock_wait_timeout;
17 @@session.innodb_lock_wait_timeout
18 60
19 '#---------------------BS_STVARS_032_03----------------------#'
20 SELECT @@GLOBAL.innodb_lock_wait_timeout = VARIABLE_VALUE
21 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
22 WHERE VARIABLE_NAME='innodb_lock_wait_timeout';
23 @@GLOBAL.innodb_lock_wait_timeout = VARIABLE_VALUE
24 1
25 1 Expected
26 SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout);
27 COUNT(@@GLOBAL.innodb_lock_wait_timeout)
28 1
29 1 Expected
30 SELECT COUNT(VARIABLE_VALUE)
31 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
32 WHERE VARIABLE_NAME='innodb_lock_wait_timeout';
33 COUNT(VARIABLE_VALUE)
34 1
35 1 Expected
36 '#---------------------BS_STVARS_032_04----------------------#'
37 SELECT @@innodb_lock_wait_timeout = @@GLOBAL.innodb_lock_wait_timeout;
38 @@innodb_lock_wait_timeout = @@GLOBAL.innodb_lock_wait_timeout
39 1
40 1 Expected
41 '#---------------------BS_STVARS_032_05----------------------#'
42 SELECT COUNT(@@innodb_lock_wait_timeout);
43 COUNT(@@innodb_lock_wait_timeout)
44 1
45 1 Expected
46 SELECT COUNT(@@local.innodb_lock_wait_timeout);
47 COUNT(@@local.innodb_lock_wait_timeout)
48 1
49 SELECT COUNT(@@SESSION.innodb_lock_wait_timeout);
50 COUNT(@@SESSION.innodb_lock_wait_timeout)
51 1
52 SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout);
53 COUNT(@@GLOBAL.innodb_lock_wait_timeout)
54 1
55 1 Expected
56 SELECT innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
57 ERROR 42S22: Unknown column 'innodb_lock_wait_timeout' in 'SELECT'
58 set @@global.innodb_lock_wait_timeout=100;
59 set @@global.innodb_lock_wait_timeout=DEFAULT;
60 select @@global.innodb_lock_wait_timeout;
61 @@global.innodb_lock_wait_timeout
62 50
63 set @@session.innodb_lock_wait_timeout=100;
64 set @@session.innodb_lock_wait_timeout=DEFAULT;
65 select @@session.innodb_lock_wait_timeout;
66 @@session.innodb_lock_wait_timeout
67 50
68 SET @@global.innodb_lock_wait_timeout=1;
69 SELECT @@global.innodb_lock_wait_timeout;
70 @@global.innodb_lock_wait_timeout
71 1
72 SET @@global.innodb_lock_wait_timeout=1024;
73 SELECT @@global.innodb_lock_wait_timeout;
74 @@global.innodb_lock_wait_timeout
75 1024
76 SET @@global.innodb_lock_wait_timeout=1073741824;
77 Warnings:
78 Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '1073741824'
79 SELECT @@global.innodb_lock_wait_timeout;
80 @@global.innodb_lock_wait_timeout
81 100000000
82 SET @@session.innodb_lock_wait_timeout=1;
83 SELECT @@session.innodb_lock_wait_timeout;
84 @@session.innodb_lock_wait_timeout
85 1
86 SET @@session.innodb_lock_wait_timeout=1024;
87 SELECT @@session.innodb_lock_wait_timeout;
88 @@session.innodb_lock_wait_timeout
89 1024
90 SET @@session.innodb_lock_wait_timeout=1073741824;
91 Warnings:
92 Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '1073741824'
93 SELECT @@session.innodb_lock_wait_timeout;
94 @@session.innodb_lock_wait_timeout
95 100000000
96 SET @@global.innodb_lock_wait_timeout="t";
97 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
98 SELECT @@global.innodb_lock_wait_timeout;
99 @@global.innodb_lock_wait_timeout
100 100000000
101 SET @@global.innodb_lock_wait_timeout=-1024;
102 Warnings:
103 Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '-1024'
104 SELECT @@global.innodb_lock_wait_timeout;
105 @@global.innodb_lock_wait_timeout
106 0
107 SET @@global.innodb_lock_wait_timeout=1073741825;
108 Warnings:
109 Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '1073741825'
110 SELECT @@global.innodb_lock_wait_timeout;
111 @@global.innodb_lock_wait_timeout
112 100000000
113 SET @@global.innodb_lock_wait_timeout=" ";
114 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
115 SELECT @@global.innodb_lock_wait_timeout;
116 @@global.innodb_lock_wait_timeout
117 100000000
118 SET @@global.innodb_lock_wait_timeout=' ';
119 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
120 SELECT @@global.innodb_lock_wait_timeout;
121 @@global.innodb_lock_wait_timeout
122 100000000
123 SET @@global.innodb_lock_wait_timeout=1.1;
124 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
125 SELECT @@global.innodb_lock_wait_timeout;
126 @@global.innodb_lock_wait_timeout
127 100000000
128 SET @@session.innodb_lock_wait_timeout="T";
129 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
130 SELECT @@session.innodb_lock_wait_timeout;
131 @@session.innodb_lock_wait_timeout
132 100000000
133 SET @@session.innodb_lock_wait_timeout=-1024;
134 Warnings:
135 Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '-1024'
136 SELECT @@session.innodb_lock_wait_timeout;
137 @@session.innodb_lock_wait_timeout
138 0
139 SET @@session.innodb_lock_wait_timeout=1073999999;
140 Warnings:
141 Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '1073999999'
142 SELECT @@session.innodb_lock_wait_timeout;
143 @@session.innodb_lock_wait_timeout
144 100000000
145 SET @@session.innodb_lock_wait_timeout=' ';
146 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
147 SELECT @@session.innodb_lock_wait_timeout;
148 @@session.innodb_lock_wait_timeout
149 100000000
150 SET @@session.innodb_lock_wait_timeout=" ";
151 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
152 SELECT @@session.innodb_lock_wait_timeout;
153 @@session.innodb_lock_wait_timeout
154 100000000
155 SET @@session.innodb_lock_wait_timeout=1.1;
156 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
157 SELECT @@session.innodb_lock_wait_timeout;
158 @@session.innodb_lock_wait_timeout
159 100000000
160 SET @@global.innodb_lock_wait_timeout = @start_global_value;
161 SELECT @@global.innodb_lock_wait_timeout;
162 @@global.innodb_lock_wait_timeout
163 50