1SET @start_global_value = @@global.max_statement_time;
2SELECT @start_global_value;
3@start_global_value
40
5SET @start_session_value = @@session.max_statement_time;
6SELECT @start_session_value;
7@start_session_value
80
9'#--------------------FN_DYNVARS_068_01-------------------------#'
10SET @@global.max_statement_time = 100;
11SET @@global.max_statement_time = DEFAULT;
12SELECT @@global.max_statement_time;
13@@global.max_statement_time
140.000000
15SET @@session.max_statement_time = 200;
16SET @@session.max_statement_time = DEFAULT;
17SELECT @@session.max_statement_time;
18@@session.max_statement_time
190.000000
20'#--------------------FN_DYNVARS_068_02-------------------------#'
21SET @@global.max_statement_time = DEFAULT;
22SELECT @@global.max_statement_time = 0;
23@@global.max_statement_time = 0
241
25SET @@session.max_statement_time = DEFAULT;
26SELECT @@session.max_statement_time = 0;
27@@session.max_statement_time = 0
281
29'#--------------------FN_DYNVARS_068_03-------------------------#'
30SET @@global.max_statement_time = 0;
31SELECT @@global.max_statement_time;
32@@global.max_statement_time
330.000000
34SET @@global.max_statement_time = 0.123456;
35SELECT @@global.max_statement_time;
36@@global.max_statement_time
370.123456
38SET @@global.max_statement_time = 60020;
39SELECT @@global.max_statement_time;
40@@global.max_statement_time
4160020.000000
42SET @@global.max_statement_time = 31536000;
43SELECT @@global.max_statement_time;
44@@global.max_statement_time
4531536000.000000
46SET @@global.max_statement_time = 65536;
47SELECT @@global.max_statement_time;
48@@global.max_statement_time
4965536.000000
50'#--------------------FN_DYNVARS_068_04-------------------------#'
51SET @@session.max_statement_time = 0;
52SELECT @@session.max_statement_time;
53@@session.max_statement_time
540.000000
55SET @@session.max_statement_time = 1;
56SELECT @@session.max_statement_time;
57@@session.max_statement_time
581.000000
59SET @@session.max_statement_time = 50050;
60SELECT @@session.max_statement_time;
61@@session.max_statement_time
6250050.000000
63SET @@session.max_statement_time = 31536000;
64SELECT @@session.max_statement_time;
65@@session.max_statement_time
6631536000.000000
67SET @@session.max_statement_time = 65550;
68SELECT @@session.max_statement_time;
69@@session.max_statement_time
7065550.000000
71'#------------------FN_DYNVARS_068_05-----------------------#'
72SET @@global.max_statement_time = 100000000000;
73Warnings:
74Warning	1292	Truncated incorrect max_statement_time value: '100000000000'
75SELECT @@global.max_statement_time;
76@@global.max_statement_time
7731536000.000000
78SET @@global.max_statement_time = -1;
79Warnings:
80Warning	1292	Truncated incorrect max_statement_time value: '-1'
81SELECT @@global.max_statement_time;
82@@global.max_statement_time
830.000000
84SET @@global.max_statement_time = 65530.34;
85SELECT @@global.max_statement_time;
86@@global.max_statement_time
8765530.340000
88SET @@global.max_statement_time = test;
89ERROR 42000: Incorrect argument type to variable 'max_statement_time'
90SELECT @@global.max_statement_time;
91@@global.max_statement_time
9265530.340000
93SET @@session.max_statement_time = 100000000000;
94Warnings:
95Warning	1292	Truncated incorrect max_statement_time value: '100000000000'
96SELECT @@session.max_statement_time;
97@@session.max_statement_time
9831536000.000000
99SET @@session.max_statement_time = -2;
100Warnings:
101Warning	1292	Truncated incorrect max_statement_time value: '-2'
102SELECT @@session.max_statement_time;
103@@session.max_statement_time
1040.000000
105SET @@session.max_statement_time = 65530.34;
106SELECT @@session.max_statement_time;
107@@session.max_statement_time
10865530.340000
109SET @@session.max_statement_time = test;
110ERROR 42000: Incorrect argument type to variable 'max_statement_time'
111SELECT @@session.max_statement_time;
112@@session.max_statement_time
11365530.340000
114'#------------------FN_DYNVARS_068_06-----------------------#'
115SELECT @@global.max_statement_time = VARIABLE_VALUE
116FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
117WHERE VARIABLE_NAME='max_statement_time';
118@@global.max_statement_time = VARIABLE_VALUE
1191
120'#------------------FN_DYNVARS_068_07-----------------------#'
121SELECT @@session.max_statement_time = VARIABLE_VALUE
122FROM INFORMATION_SCHEMA.SESSION_VARIABLES
123WHERE VARIABLE_NAME='max_statement_time';
124@@session.max_statement_time = VARIABLE_VALUE
1251
126'#------------------FN_DYNVARS_068_08-----------------------#'
127SET @@global.max_statement_time = TRUE;
128SELECT @@global.max_statement_time;
129@@global.max_statement_time
1301.000000
131SET @@global.max_statement_time = FALSE;
132SELECT @@global.max_statement_time;
133@@global.max_statement_time
1340.000000
135'#---------------------FN_DYNVARS_001_09----------------------#'
136SET @@global.max_statement_time = 10;
137SELECT @@max_statement_time = @@global.max_statement_time;
138@@max_statement_time = @@global.max_statement_time
1390
140'#---------------------FN_DYNVARS_001_10----------------------#'
141SET @@max_statement_time = 100;
142SELECT @@max_statement_time = @@local.max_statement_time;
143@@max_statement_time = @@local.max_statement_time
1441
145SELECT @@local.max_statement_time = @@session.max_statement_time;
146@@local.max_statement_time = @@session.max_statement_time
1471
148'#---------------------FN_DYNVARS_001_11----------------------#'
149SET max_statement_time = 1;
150SELECT @@max_statement_time;
151@@max_statement_time
1521.000000
153SELECT local.max_statement_time;
154ERROR 42S02: Unknown table 'local' in field list
155SELECT session.max_statement_time;
156ERROR 42S02: Unknown table 'session' in field list
157SELECT max_statement_time = @@session.max_statement_time;
158ERROR 42S22: Unknown column 'max_statement_time' in 'field list'
159#
160# Check that one can use max_statement_time as a field
161#
162drop table if exists t1;
163create table t1 (a int, max_statement_time int);
164drop table t1;
165SET @@global.max_statement_time = @start_global_value;
166SELECT @@global.max_statement_time;
167@@global.max_statement_time
1680.000000
169SET @@session.max_statement_time = @start_session_value;
170SELECT @@session.max_statement_time;
171@@session.max_statement_time
1720.000000
173