1SET @start_global_value = @@global.long_query_time;
2SET @start_session_value = @@session.long_query_time;
3'#--------------------FN_DYNVARS_068_01-------------------------#'
4SET @@global.long_query_time = 100;
5SET @@global.long_query_time = DEFAULT;
6SELECT @@global.long_query_time >= 0;
7@@global.long_query_time >= 0
81
9SET @@session.long_query_time = 200;
10SET @@session.long_query_time = DEFAULT;
11SELECT @@session.long_query_time >= 0;
12@@session.long_query_time >= 0
131
14'#--------------------FN_DYNVARS_068_03-------------------------#'
15SET @@global.long_query_time = 0;
16SELECT @@global.long_query_time;
17@@global.long_query_time
180.000000
19SET @@global.long_query_time = 1;
20SELECT @@global.long_query_time;
21@@global.long_query_time
221.000000
23SET @@global.long_query_time = 60020;
24SELECT @@global.long_query_time;
25@@global.long_query_time
2660020.000000
27SET @@global.long_query_time = 31536000;
28SELECT @@global.long_query_time;
29@@global.long_query_time
3031536000.000000
31SET @@global.long_query_time = 65536;
32SELECT @@global.long_query_time;
33@@global.long_query_time
3465536.000000
35'#--------------------FN_DYNVARS_068_04-------------------------#'
36SET @@session.long_query_time = 0;
37SELECT @@session.long_query_time;
38@@session.long_query_time
390.000000
40SET @@session.long_query_time = 1;
41SELECT @@session.long_query_time;
42@@session.long_query_time
431.000000
44SET @@session.long_query_time = 50050;
45SELECT @@session.long_query_time;
46@@session.long_query_time
4750050.000000
48SET @@session.long_query_time = 31536000;
49SELECT @@session.long_query_time;
50@@session.long_query_time
5131536000.000000
52SET @@session.long_query_time = 65550;
53SELECT @@session.long_query_time;
54@@session.long_query_time
5565550.000000
56'#------------------FN_DYNVARS_068_05-----------------------#'
57SET @@global.long_query_time = 100000000000;
58Warnings:
59Warning	1292	Truncated incorrect long_query_time value: '100000000000'
60SELECT @@global.long_query_time;
61@@global.long_query_time
6231536000.000000
63SET @@global.long_query_time = -1;
64Warnings:
65Warning	1292	Truncated incorrect long_query_time value: '-1'
66SELECT @@global.long_query_time;
67@@global.long_query_time
680.000000
69SET @@global.long_query_time = 65530.34;
70SELECT @@global.long_query_time;
71@@global.long_query_time
7265530.340000
73SET @@global.long_query_time = test;
74ERROR 42000: Incorrect argument type to variable 'long_query_time'
75SELECT @@global.long_query_time;
76@@global.long_query_time
7765530.340000
78SET @@session.long_query_time = 100000000000;
79Warnings:
80Warning	1292	Truncated incorrect long_query_time value: '100000000000'
81SELECT @@session.long_query_time;
82@@session.long_query_time
8331536000.000000
84SET @@session.long_query_time = -2;
85Warnings:
86Warning	1292	Truncated incorrect long_query_time value: '-2'
87SELECT @@session.long_query_time;
88@@session.long_query_time
890.000000
90SET @@session.long_query_time = 65530.34;
91SELECT @@session.long_query_time;
92@@session.long_query_time
9365530.340000
94SET @@session.long_query_time = test;
95ERROR 42000: Incorrect argument type to variable 'long_query_time'
96SELECT @@session.long_query_time;
97@@session.long_query_time
9865530.340000
99'#------------------FN_DYNVARS_068_06-----------------------#'
100SELECT @@global.long_query_time = VARIABLE_VALUE
101FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
102WHERE VARIABLE_NAME='long_query_time';
103@@global.long_query_time = VARIABLE_VALUE
1041
105'#------------------FN_DYNVARS_068_07-----------------------#'
106SELECT @@session.long_query_time = VARIABLE_VALUE
107FROM INFORMATION_SCHEMA.SESSION_VARIABLES
108WHERE VARIABLE_NAME='long_query_time';
109@@session.long_query_time = VARIABLE_VALUE
1101
111'#------------------FN_DYNVARS_068_08-----------------------#'
112SET @@global.long_query_time = TRUE;
113SELECT @@global.long_query_time;
114@@global.long_query_time
1151.000000
116SET @@global.long_query_time = FALSE;
117SELECT @@global.long_query_time;
118@@global.long_query_time
1190.000000
120'#---------------------FN_DYNVARS_001_09----------------------#'
121SET @@global.long_query_time = 10;
122SELECT @@long_query_time = @@global.long_query_time;
123@@long_query_time = @@global.long_query_time
1240
125'#---------------------FN_DYNVARS_001_10----------------------#'
126SET @@long_query_time = 100;
127SELECT @@long_query_time = @@local.long_query_time;
128@@long_query_time = @@local.long_query_time
1291
130SELECT @@local.long_query_time = @@session.long_query_time;
131@@local.long_query_time = @@session.long_query_time
1321
133'#---------------------FN_DYNVARS_001_11----------------------#'
134SET long_query_time = 1;
135SELECT @@long_query_time;
136@@long_query_time
1371.000000
138SELECT local.long_query_time;
139ERROR 42S02: Unknown table 'local' in field list
140SELECT session.long_query_time;
141ERROR 42S02: Unknown table 'session' in field list
142SELECT long_query_time = @@session.long_query_time;
143ERROR 42S22: Unknown column 'long_query_time' in 'field list'
144SET @@global.long_query_time = @start_global_value;
145