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 performance_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 performance_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 'field list'
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 SELECT @@global.innodb_lock_wait_timeout;
78 @@global.innodb_lock_wait_timeout
79 1073741824
80 SET @@session.innodb_lock_wait_timeout=1;
81 SELECT @@session.innodb_lock_wait_timeout;
82 @@session.innodb_lock_wait_timeout
83 1
84 SET @@session.innodb_lock_wait_timeout=1024;
85 SELECT @@session.innodb_lock_wait_timeout;
86 @@session.innodb_lock_wait_timeout
87 1024
88 SET @@session.innodb_lock_wait_timeout=1073741824;
89 SELECT @@session.innodb_lock_wait_timeout;
90 @@session.innodb_lock_wait_timeout
91 1073741824
92 SET @@global.innodb_lock_wait_timeout="t";
93 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
94 SELECT @@global.innodb_lock_wait_timeout;
95 @@global.innodb_lock_wait_timeout
96 1073741824
97 SET @@global.innodb_lock_wait_timeout=-1024;
98 Warnings:
99 Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '-1024'
100 SELECT @@global.innodb_lock_wait_timeout;
101 @@global.innodb_lock_wait_timeout
102 1
103 SET @@global.innodb_lock_wait_timeout=1073741825;
104 Warnings:
105 Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '1073741825'
106 SELECT @@global.innodb_lock_wait_timeout;
107 @@global.innodb_lock_wait_timeout
108 1073741824
109 SET @@global.innodb_lock_wait_timeout=" ";
110 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
111 SELECT @@global.innodb_lock_wait_timeout;
112 @@global.innodb_lock_wait_timeout
113 1073741824
114 SET @@global.innodb_lock_wait_timeout=' ';
115 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
116 SELECT @@global.innodb_lock_wait_timeout;
117 @@global.innodb_lock_wait_timeout
118 1073741824
119 SET @@global.innodb_lock_wait_timeout=1.1;
120 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
121 SELECT @@global.innodb_lock_wait_timeout;
122 @@global.innodb_lock_wait_timeout
123 1073741824
124 SET @@session.innodb_lock_wait_timeout="T";
125 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
126 SELECT @@session.innodb_lock_wait_timeout;
127 @@session.innodb_lock_wait_timeout
128 1073741824
129 SET @@session.innodb_lock_wait_timeout=-1024;
130 Warnings:
131 Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '-1024'
132 SELECT @@session.innodb_lock_wait_timeout;
133 @@session.innodb_lock_wait_timeout
134 1
135 SET @@session.innodb_lock_wait_timeout=1073999999;
136 Warnings:
137 Warning 1292 Truncated incorrect innodb_lock_wait_timeout value: '1073999999'
138 SELECT @@session.innodb_lock_wait_timeout;
139 @@session.innodb_lock_wait_timeout
140 1073741824
141 SET @@session.innodb_lock_wait_timeout=' ';
142 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
143 SELECT @@session.innodb_lock_wait_timeout;
144 @@session.innodb_lock_wait_timeout
145 1073741824
146 SET @@session.innodb_lock_wait_timeout=" ";
147 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
148 SELECT @@session.innodb_lock_wait_timeout;
149 @@session.innodb_lock_wait_timeout
150 1073741824
151 SET @@session.innodb_lock_wait_timeout=1.1;
152 ERROR 42000: Incorrect argument type to variable 'innodb_lock_wait_timeout'
153 SELECT @@session.innodb_lock_wait_timeout;
154 @@session.innodb_lock_wait_timeout
155 1073741824
156 SET @@global.innodb_lock_wait_timeout = @start_global_value;
157 SELECT @@global.innodb_lock_wait_timeout;
158 @@global.innodb_lock_wait_timeout
159 50