Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.long_query_time;
2 SELECT @start_global_value;
3 @start_global_value
4 10
5 SET @start_session_value = @@session.long_query_time;
6 SELECT @start_session_value;
7 @start_session_value
8 10
9 '#--------------------FN_DYNVARS_068_01-------------------------#'
10 SET @@global.long_query_time = 100;
11 SET @@global.long_query_time = DEFAULT;
12 SELECT @@global.long_query_time;
13 @@global.long_query_time
14 10.000000
15 SET @@session.long_query_time = 200;
16 SET @@session.long_query_time = DEFAULT;
17 SELECT @@session.long_query_time;
18 @@session.long_query_time
19 10.000000
20 '#--------------------FN_DYNVARS_068_02-------------------------#'
21 SET @@global.long_query_time = DEFAULT;
22 SELECT @@global.long_query_time = 10;
23 @@global.long_query_time = 10
24 1
25 SET @@session.long_query_time = DEFAULT;
26 SELECT @@session.long_query_time = 10;
27 @@session.long_query_time = 10
28 1
29 '#--------------------FN_DYNVARS_068_03-------------------------#'
30 SET @@global.long_query_time = 0;
31 SELECT @@global.long_query_time;
32 @@global.long_query_time
33 0.000000
34 SET @@global.long_query_time = 1;
35 SELECT @@global.long_query_time;
36 @@global.long_query_time
37 1.000000
38 SET @@global.long_query_time = 60020;
39 SELECT @@global.long_query_time;
40 @@global.long_query_time
41 60020.000000
42 SET @@global.long_query_time = 31536000;
43 SELECT @@global.long_query_time;
44 @@global.long_query_time
45 31536000.000000
46 SET @@global.long_query_time = 65536;
47 SELECT @@global.long_query_time;
48 @@global.long_query_time
49 65536.000000
50 '#--------------------FN_DYNVARS_068_04-------------------------#'
51 SET @@session.long_query_time = 0;
52 SELECT @@session.long_query_time;
53 @@session.long_query_time
54 0.000000
55 SET @@session.long_query_time = 1;
56 SELECT @@session.long_query_time;
57 @@session.long_query_time
58 1.000000
59 SET @@session.long_query_time = 50050;
60 SELECT @@session.long_query_time;
61 @@session.long_query_time
62 50050.000000
63 SET @@session.long_query_time = 31536000;
64 SELECT @@session.long_query_time;
65 @@session.long_query_time
66 31536000.000000
67 SET @@session.long_query_time = 65550;
68 SELECT @@session.long_query_time;
69 @@session.long_query_time
70 65550.000000
71 '#------------------FN_DYNVARS_068_05-----------------------#'
72 SET @@global.long_query_time = 100000000000;
73 Warnings:
74 Warning 1292 Truncated incorrect long_query_time value: '100000000000'
75 SELECT @@global.long_query_time;
76 @@global.long_query_time
77 31536000.000000
78 SET @@global.long_query_time = -1;
79 Warnings:
80 Warning 1292 Truncated incorrect long_query_time value: '-1'
81 SELECT @@global.long_query_time;
82 @@global.long_query_time
83 0.000000
84 SET @@global.long_query_time = 65530.34;
85 SELECT @@global.long_query_time;
86 @@global.long_query_time
87 65530.340000
88 SET @@global.long_query_time = test;
89 ERROR 42000: Incorrect argument type to variable 'long_query_time'
90 SELECT @@global.long_query_time;
91 @@global.long_query_time
92 65530.340000
93 SET @@global.long_query_time = ' ';
94 ERROR 42000: Incorrect argument type to variable 'long_query_time'
95 SELECT @@global.long_query_time;
96 @@global.long_query_time
97 65530.340000
98 SET @@session.long_query_time = 100000000000;
99 Warnings:
100 Warning 1292 Truncated incorrect long_query_time value: '100000000000'
101 SELECT @@session.long_query_time;
102 @@session.long_query_time
103 31536000.000000
104 SET @@session.long_query_time = -2;
105 Warnings:
106 Warning 1292 Truncated incorrect long_query_time value: '-2'
107 SELECT @@session.long_query_time;
108 @@session.long_query_time
109 0.000000
110 SET @@session.long_query_time = 65530.34;
111 SELECT @@session.long_query_time;
112 @@session.long_query_time
113 65530.340000
114 SET @@session.long_query_time = test;
115 ERROR 42000: Incorrect argument type to variable 'long_query_time'
116 SELECT @@session.long_query_time;
117 @@session.long_query_time
118 65530.340000
119 SET @@session.long_query_time = ' ';
120 ERROR 42000: Incorrect argument type to variable 'long_query_time'
121 SELECT @@session.long_query_time;
122 @@session.long_query_time
123 65530.340000
124 '#------------------FN_DYNVARS_068_06-----------------------#'
125 SELECT @@global.long_query_time = VARIABLE_VALUE
126 FROM performance_schema.global_variables
127 WHERE VARIABLE_NAME='long_query_time';
128 @@global.long_query_time = VARIABLE_VALUE
129 1
130 '#------------------FN_DYNVARS_068_07-----------------------#'
131 SELECT @@session.long_query_time = VARIABLE_VALUE
132 FROM performance_schema.session_variables
133 WHERE VARIABLE_NAME='long_query_time';
134 @@session.long_query_time = VARIABLE_VALUE
135 1
136 '#------------------FN_DYNVARS_068_08-----------------------#'
137 SET @@global.long_query_time = TRUE;
138 SELECT @@global.long_query_time;
139 @@global.long_query_time
140 1.000000
141 SET @@global.long_query_time = FALSE;
142 SELECT @@global.long_query_time;
143 @@global.long_query_time
144 0.000000
145 '#---------------------FN_DYNVARS_001_09----------------------#'
146 SET @@global.long_query_time = 10;
147 SELECT @@long_query_time = @@global.long_query_time;
148 @@long_query_time = @@global.long_query_time
149 0
150 '#---------------------FN_DYNVARS_001_10----------------------#'
151 SET @@long_query_time = 100;
152 SELECT @@long_query_time = @@local.long_query_time;
153 @@long_query_time = @@local.long_query_time
154 1
155 SELECT @@local.long_query_time = @@session.long_query_time;
156 @@local.long_query_time = @@session.long_query_time
157 1
158 '#---------------------FN_DYNVARS_001_11----------------------#'
159 SET long_query_time = 1;
160 SELECT @@long_query_time;
161 @@long_query_time
162 1.000000
163 SELECT local.long_query_time;
164 ERROR 42S02: Unknown table 'local' in field list
165 SELECT session.long_query_time;
166 ERROR 42S02: Unknown table 'session' in field list
167 SELECT long_query_time = @@session.long_query_time;
168 ERROR 42S22: Unknown column 'long_query_time' in 'field list'
169 SET @@global.long_query_time = @start_global_value;
170 SELECT @@global.long_query_time;
171 @@global.long_query_time
172 10.000000
173 SET @@session.long_query_time = @start_session_value;
174 SELECT @@session.long_query_time;
175 @@session.long_query_time
176 10.000000