1
SET @start_global_value = @@global.interactive_timeout;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.interactive_timeout;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_052_01-------------------------#'
10
SET @@global.interactive_timeout = 100;
11
SET @@global.interactive_timeout = DEFAULT;
12
SELECT @@global.interactive_timeout;
13
@@global.interactive_timeout
15
SET @@session.interactive_timeout = 200;
16
SET @@session.interactive_timeout = DEFAULT;
17
SELECT @@session.interactive_timeout;
18
@@session.interactive_timeout
20
'#--------------------FN_DYNVARS_052_02-------------------------#'
21
SET @@global.interactive_timeout = DEFAULT;
22
SELECT @@global.interactive_timeout = 28800;
23
@@global.interactive_timeout = 28800
25
SET @@session.interactive_timeout = DEFAULT;
26
SELECT @@session.interactive_timeout = 28800;
27
@@session.interactive_timeout = 28800
29
'#--------------------FN_DYNVARS_052_03-------------------------#'
30
SET @@global.interactive_timeout = 1;
31
SELECT @@global.interactive_timeout;
32
@@global.interactive_timeout
34
SET @@global.interactive_timeout = 60020;
35
SELECT @@global.interactive_timeout;
36
@@global.interactive_timeout
38
SET @@global.interactive_timeout = 65535;
39
SELECT @@global.interactive_timeout;
40
@@global.interactive_timeout
42
'#--------------------FN_DYNVARS_052_04-------------------------#'
43
SET @@session.interactive_timeout = 1;
44
SELECT @@session.interactive_timeout;
45
@@session.interactive_timeout
47
SET @@session.interactive_timeout = 50050;
48
SELECT @@session.interactive_timeout;
49
@@session.interactive_timeout
51
SET @@session.interactive_timeout = 65535;
52
SELECT @@session.interactive_timeout;
53
@@session.interactive_timeout
55
'#------------------FN_DYNVARS_052_05-----------------------#'
56
SET @@global.interactive_timeout = 0;
58
Warning 1292 Truncated incorrect interactive_timeout value: '0'
59
SELECT @@global.interactive_timeout;
60
@@global.interactive_timeout
62
SET @@global.interactive_timeout = -1024;
64
Warning 1292 Truncated incorrect interactive_timeout value: '0'
65
SELECT @@global.interactive_timeout;
66
@@global.interactive_timeout
68
SET @@global.interactive_timeout = 1000000000;
70
Warning 1292 Truncated incorrect interactive_timeout value: '1000000000'
71
SELECT @@global.interactive_timeout;
72
@@global.interactive_timeout
74
SET @@global.interactive_timeout = 65530.34.;
75
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 '.' at line 1
76
SELECT @@global.interactive_timeout;
77
@@global.interactive_timeout
79
SET @@global.interactive_timeout = test;
80
ERROR 42000: Incorrect argument type to variable 'interactive_timeout'
81
SELECT @@global.interactive_timeout;
82
@@global.interactive_timeout
84
SET @@session.interactive_timeout = 0;
86
Warning 1292 Truncated incorrect interactive_timeout value: '0'
87
SELECT @@session.interactive_timeout;
88
@@session.interactive_timeout
90
SET @@session.interactive_timeout = -2;
92
Warning 1292 Truncated incorrect interactive_timeout value: '0'
93
SELECT @@session.interactive_timeout;
94
@@session.interactive_timeout
96
SET @@session.interactive_timeout = 65530.34.;
97
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 '.' at line 1
98
SET @@session.interactive_timeout = 100000000;
100
Warning 1292 Truncated incorrect interactive_timeout value: '100000000'
101
SELECT @@session.interactive_timeout;
102
@@session.interactive_timeout
104
'Bug # 34837: Errors are not coming on assigning invalid values to variable'
105
SET @@session.interactive_timeout = test;
106
ERROR 42000: Incorrect argument type to variable 'interactive_timeout'
107
SELECT @@session.interactive_timeout;
108
@@session.interactive_timeout
110
'#------------------FN_DYNVARS_052_06-----------------------#'
111
SELECT @@global.interactive_timeout = VARIABLE_VALUE
112
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
113
WHERE VARIABLE_NAME='interactive_timeout';
114
@@global.interactive_timeout = VARIABLE_VALUE
116
'#------------------FN_DYNVARS_052_07-----------------------#'
117
SELECT @@session.interactive_timeout = VARIABLE_VALUE
118
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
119
WHERE VARIABLE_NAME='interactive_timeout';
120
@@session.interactive_timeout = VARIABLE_VALUE
122
'#------------------FN_DYNVARS_052_08-----------------------#'
123
SET @@global.interactive_timeout = TRUE;
124
SELECT @@global.interactive_timeout;
125
@@global.interactive_timeout
127
SET @@global.interactive_timeout = FALSE;
129
Warning 1292 Truncated incorrect interactive_timeout value: '0'
130
SELECT @@global.interactive_timeout;
131
@@global.interactive_timeout
133
'#---------------------FN_DYNVARS_052_09----------------------#'
134
SET @@global.interactive_timeout = 10;
135
SELECT @@interactive_timeout = @@global.interactive_timeout;
136
@@interactive_timeout = @@global.interactive_timeout
138
'#---------------------FN_DYNVARS_052_10----------------------#'
139
SET @@interactive_timeout = 100;
140
SELECT @@interactive_timeout = @@local.interactive_timeout;
141
@@interactive_timeout = @@local.interactive_timeout
143
SELECT @@local.interactive_timeout = @@session.interactive_timeout;
144
@@local.interactive_timeout = @@session.interactive_timeout
146
'#---------------------FN_DYNVARS_052_11----------------------#'
147
SET interactive_timeout = 1;
148
SELECT @@interactive_timeout;
149
@@interactive_timeout
151
SELECT local.interactive_timeout;
152
ERROR 42S02: Unknown table 'local' in field list
153
SELECT session.interactive_timeout;
154
ERROR 42S02: Unknown table 'session' in field list
155
SELECT interactive_timeout = @@session.interactive_timeout;
156
ERROR 42S22: Unknown column 'interactive_timeout' in 'field list'
157
SET @@global.interactive_timeout = @start_global_value;
158
SELECT @@global.interactive_timeout;
159
@@global.interactive_timeout
161
SET @@session.interactive_timeout = @start_session_value;
162
SELECT @@session.interactive_timeout;
163
@@session.interactive_timeout