Debian Codegraph @

mysql-test/suite/json/r/type_json.result

raw
1 #
2 # Start of 10.5 tests
3 #
4 #
5 # MDEV-27361 Hybrid functions with JSON arguments do not send format metadata
6 #
7 CREATE PROCEDURE p1(tbl TEXT, expr TEXT)
8 BEGIN
9 DECLARE t1cols INT DEFAULT (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
10 WHERE TABLE_NAME=tbl AND TABLE_SCHEMA='test');
11 FOR a IN 0..(t1cols-1) DO
12 FOR b IN 0..(t1cols-1) DO
13 BEGIN
14 DECLARE query TEXT DEFAULT CONCAT('SELECT ', expr, ' FROM ', tbl);
15 SET query= REPLACE(query, 'olt1', a);
16 SET query= REPLACE(query, 'olt2', b);
17 EXECUTE IMMEDIATE query;
18 END;
19 END FOR;
20 END FOR;
21 END;
22 $$
23 CREATE PROCEDURE p2(expr TEXT)
24 BEGIN
25 DECLARE t1cols INT DEFAULT (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
26 WHERE TABLE_NAME='t1' AND TABLE_SCHEMA='test');
27 DECLARE t2cols INT DEFAULT (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
28 WHERE TABLE_NAME='t2' AND TABLE_SCHEMA='test');
29 FOR a IN 0..(t1cols-1) DO
30 FOR b IN 0..(t2cols-1) DO
31 BEGIN
32 DECLARE query TEXT DEFAULT CONCAT('SELECT ', expr, ' FROM t1, t2');
33 SET query= REPLACE(query, 'olt1', a);
34 SET query= REPLACE(query, 'olt2', b);
35 EXECUTE IMMEDIATE query;
36 END;
37 END FOR;
38 END FOR;
39 END;
40 $$
41 CREATE TABLE t1
42 (
43 c0 CHAR(30) DEFAULT '1' CHECK(JSON_VALID(c0)),
44 c1 VARCHAR(30) DEFAULT '1' CHECK(JSON_VALID(c1)),
45 c2 TINYTEXT DEFAULT '1' CHECK(JSON_VALID(c2)),
46 c3 TEXT DEFAULT '1' CHECK(JSON_VALID(c3)),
47 c4 MEDIUMTEXT DEFAULT '1' CHECK(JSON_VALID(c4)),
48 c5 LONGTEXT DEFAULT '1' CHECK(JSON_VALID(c5)),
49 # The below data types do not have any special JSON properties.
50 # Just checking CHECK(JSON_VALID()) does not give any unexpected surprises.
51 c6 INT DEFAULT '1' CHECK(JSON_VALID(c6)),
52 c7 ENUM('1') DEFAULT '1' CHECK(JSON_VALID(c7))
53 );
54 INSERT INTO t1 VALUES ();
55 CREATE TABLE t1c
56 (
57 c0 CHAR(30) DEFAULT '1' CHECK(JSON_VALID(c0)),
58 c1 VARCHAR(30) COMPRESSED DEFAULT '1' CHECK(JSON_VALID(c1)),
59 c2 TINYTEXT COMPRESSED DEFAULT '1' CHECK(JSON_VALID(c2)),
60 c3 TEXT COMPRESSED DEFAULT '1' CHECK(JSON_VALID(c3)),
61 c4 MEDIUMTEXT COMPRESSED DEFAULT '1' CHECK(JSON_VALID(c4)),
62 c5 LONGTEXT COMPRESSED DEFAULT '1' CHECK(JSON_VALID(c5)),
63 # The below data types do not have any special JSON properties.
64 # Just checking CHECK(JSON_VALID()) does not give any unexpected surprises.
65 c6 INT DEFAULT '1' CHECK(JSON_VALID(c6)),
66 c7 ENUM('1') DEFAULT '1' CHECK(JSON_VALID(c7))
67 );
68 INSERT INTO t1c VALUES ();
69 CREATE TABLE t2
70 (
71 c0 CHAR(30) DEFAULT '1',
72 c1 VARCHAR(30) DEFAULT '1',
73 c2 TINYTEXT DEFAULT '1',
74 c3 TEXT DEFAULT '1',
75 c4 MEDIUMTEXT DEFAULT '1',
76 c5 LONGTEXT DEFAULT '1',
77 c6 INT DEFAULT 1,
78 c7 DOUBLE DEFAULT 1,
79 c8 DECIMAL(10,2) DEFAULT 1.23,
80 c9 TIME DEFAULT '10:20:30',
81 c10 DATE DEFAULT '2001-01-01',
82 c11 DATETIME DEFAULT '2001-01-01 10:20:30',
83 c12 ENUM('1','2') DEFAULT '1'
84 );
85 INSERT INTO t2 VALUES ();
86 CALL p1('t1', 'COALESCE(colt1, colt2)');
87 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
88 def COALESCE(c0, c0) 254 (format=json) 30 1 Y 0 39 8
89 COALESCE(c0, c0)
90 1
91 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
92 def COALESCE(c0, c1) 253 (format=json) 30 1 Y 0 39 8
93 COALESCE(c0, c1)
94 1
95 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
96 def COALESCE(c0, c2) 252 (format=json) 1020 1 Y 0 39 8
97 COALESCE(c0, c2)
98 1
99 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
100 def COALESCE(c0, c3) 250 (format=json) 262140 1 Y 0 39 8
101 COALESCE(c0, c3)
102 1
103 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
104 def COALESCE(c0, c4) 251 (format=json) 67108860 1 Y 0 39 8
105 COALESCE(c0, c4)
106 1
107 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
108 def COALESCE(c0, c5) 251 (format=json) 4294967292 1 Y 0 39 8
109 COALESCE(c0, c5)
110 1
111 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
112 def COALESCE(c0, c6) 254 30 1 Y 0 39 8
113 COALESCE(c0, c6)
114 1
115 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
116 def COALESCE(c0, c7) 253 30 1 Y 0 39 8
117 COALESCE(c0, c7)
118 1
119 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
120 def COALESCE(c1, c0) 253 (format=json) 30 1 Y 0 39 8
121 COALESCE(c1, c0)
122 1
123 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
124 def COALESCE(c1, c1) 253 (format=json) 30 1 Y 0 39 8
125 COALESCE(c1, c1)
126 1
127 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
128 def COALESCE(c1, c2) 252 (format=json) 1020 1 Y 0 39 8
129 COALESCE(c1, c2)
130 1
131 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
132 def COALESCE(c1, c3) 250 (format=json) 262140 1 Y 0 39 8
133 COALESCE(c1, c3)
134 1
135 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
136 def COALESCE(c1, c4) 251 (format=json) 67108860 1 Y 0 39 8
137 COALESCE(c1, c4)
138 1
139 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
140 def COALESCE(c1, c5) 251 (format=json) 4294967292 1 Y 0 39 8
141 COALESCE(c1, c5)
142 1
143 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
144 def COALESCE(c1, c6) 253 30 1 Y 0 39 8
145 COALESCE(c1, c6)
146 1
147 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
148 def COALESCE(c1, c7) 253 30 1 Y 0 39 8
149 COALESCE(c1, c7)
150 1
151 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
152 def COALESCE(c2, c0) 252 (format=json) 1020 1 Y 0 39 8
153 COALESCE(c2, c0)
154 1
155 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
156 def COALESCE(c2, c1) 252 (format=json) 1020 1 Y 0 39 8
157 COALESCE(c2, c1)
158 1
159 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
160 def COALESCE(c2, c2) 252 (format=json) 1020 1 Y 0 39 8
161 COALESCE(c2, c2)
162 1
163 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
164 def COALESCE(c2, c3) 250 (format=json) 262140 1 Y 0 39 8
165 COALESCE(c2, c3)
166 1
167 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
168 def COALESCE(c2, c4) 251 (format=json) 67108860 1 Y 0 39 8
169 COALESCE(c2, c4)
170 1
171 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
172 def COALESCE(c2, c5) 251 (format=json) 4294967292 1 Y 0 39 8
173 COALESCE(c2, c5)
174 1
175 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
176 def COALESCE(c2, c6) 252 1020 1 Y 0 39 8
177 COALESCE(c2, c6)
178 1
179 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
180 def COALESCE(c2, c7) 252 1020 1 Y 0 39 8
181 COALESCE(c2, c7)
182 1
183 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
184 def COALESCE(c3, c0) 250 (format=json) 262140 1 Y 0 39 8
185 COALESCE(c3, c0)
186 1
187 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
188 def COALESCE(c3, c1) 250 (format=json) 262140 1 Y 0 39 8
189 COALESCE(c3, c1)
190 1
191 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
192 def COALESCE(c3, c2) 250 (format=json) 262140 1 Y 0 39 8
193 COALESCE(c3, c2)
194 1
195 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
196 def COALESCE(c3, c3) 250 (format=json) 262140 1 Y 0 39 8
197 COALESCE(c3, c3)
198 1
199 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
200 def COALESCE(c3, c4) 251 (format=json) 67108860 1 Y 0 39 8
201 COALESCE(c3, c4)
202 1
203 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
204 def COALESCE(c3, c5) 251 (format=json) 4294967292 1 Y 0 39 8
205 COALESCE(c3, c5)
206 1
207 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
208 def COALESCE(c3, c6) 250 262140 1 Y 0 39 8
209 COALESCE(c3, c6)
210 1
211 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
212 def COALESCE(c3, c7) 250 262140 1 Y 0 39 8
213 COALESCE(c3, c7)
214 1
215 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
216 def COALESCE(c4, c0) 251 (format=json) 67108860 1 Y 0 39 8
217 COALESCE(c4, c0)
218 1
219 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
220 def COALESCE(c4, c1) 251 (format=json) 67108860 1 Y 0 39 8
221 COALESCE(c4, c1)
222 1
223 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
224 def COALESCE(c4, c2) 251 (format=json) 67108860 1 Y 0 39 8
225 COALESCE(c4, c2)
226 1
227 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
228 def COALESCE(c4, c3) 251 (format=json) 67108860 1 Y 0 39 8
229 COALESCE(c4, c3)
230 1
231 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
232 def COALESCE(c4, c4) 251 (format=json) 67108860 1 Y 0 39 8
233 COALESCE(c4, c4)
234 1
235 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
236 def COALESCE(c4, c5) 251 (format=json) 4294967292 1 Y 0 39 8
237 COALESCE(c4, c5)
238 1
239 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
240 def COALESCE(c4, c6) 251 67108860 1 Y 0 39 8
241 COALESCE(c4, c6)
242 1
243 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
244 def COALESCE(c4, c7) 251 67108860 1 Y 0 39 8
245 COALESCE(c4, c7)
246 1
247 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
248 def COALESCE(c5, c0) 251 (format=json) 4294967292 1 Y 0 39 8
249 COALESCE(c5, c0)
250 1
251 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
252 def COALESCE(c5, c1) 251 (format=json) 4294967292 1 Y 0 39 8
253 COALESCE(c5, c1)
254 1
255 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
256 def COALESCE(c5, c2) 251 (format=json) 4294967292 1 Y 0 39 8
257 COALESCE(c5, c2)
258 1
259 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
260 def COALESCE(c5, c3) 251 (format=json) 4294967292 1 Y 0 39 8
261 COALESCE(c5, c3)
262 1
263 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
264 def COALESCE(c5, c4) 251 (format=json) 4294967292 1 Y 0 39 8
265 COALESCE(c5, c4)
266 1
267 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
268 def COALESCE(c5, c5) 251 (format=json) 4294967292 1 Y 0 39 8
269 COALESCE(c5, c5)
270 1
271 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
272 def COALESCE(c5, c6) 251 4294967292 1 Y 0 39 8
273 COALESCE(c5, c6)
274 1
275 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
276 def COALESCE(c5, c7) 251 4294967292 1 Y 0 39 8
277 COALESCE(c5, c7)
278 1
279 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
280 def COALESCE(c6, c0) 254 30 1 Y 0 39 8
281 COALESCE(c6, c0)
282 1
283 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
284 def COALESCE(c6, c1) 253 30 1 Y 0 39 8
285 COALESCE(c6, c1)
286 1
287 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
288 def COALESCE(c6, c2) 252 1020 1 Y 0 39 8
289 COALESCE(c6, c2)
290 1
291 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
292 def COALESCE(c6, c3) 250 262140 1 Y 0 39 8
293 COALESCE(c6, c3)
294 1
295 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
296 def COALESCE(c6, c4) 251 67108860 1 Y 0 39 8
297 COALESCE(c6, c4)
298 1
299 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
300 def COALESCE(c6, c5) 251 4294967292 1 Y 0 39 8
301 COALESCE(c6, c5)
302 1
303 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
304 def COALESCE(c6, c6) 3 11 1 Y 32896 0 63
305 COALESCE(c6, c6)
306 1
307 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
308 def COALESCE(c6, c7) 253 11 1 Y 0 39 8
309 COALESCE(c6, c7)
310 1
311 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
312 def COALESCE(c7, c0) 253 30 1 Y 0 39 8
313 COALESCE(c7, c0)
314 1
315 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
316 def COALESCE(c7, c1) 253 30 1 Y 0 39 8
317 COALESCE(c7, c1)
318 1
319 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
320 def COALESCE(c7, c2) 252 1020 1 Y 0 39 8
321 COALESCE(c7, c2)
322 1
323 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
324 def COALESCE(c7, c3) 250 262140 1 Y 0 39 8
325 COALESCE(c7, c3)
326 1
327 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
328 def COALESCE(c7, c4) 251 67108860 1 Y 0 39 8
329 COALESCE(c7, c4)
330 1
331 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
332 def COALESCE(c7, c5) 251 4294967292 1 Y 0 39 8
333 COALESCE(c7, c5)
334 1
335 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
336 def COALESCE(c7, c6) 253 11 1 Y 0 39 8
337 COALESCE(c7, c6)
338 1
339 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
340 def COALESCE(c7, c7) 253 1 1 Y 0 39 8
341 COALESCE(c7, c7)
342 1
343 CALL p1('t1', 'LEAST(colt1, colt2)');
344 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
345 def LEAST(c0, c0) 254 30 1 Y 0 39 8
346 LEAST(c0, c0)
347 1
348 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
349 def LEAST(c0, c1) 253 30 1 Y 0 39 8
350 LEAST(c0, c1)
351 1
352 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
353 def LEAST(c0, c2) 252 1020 1 Y 0 39 8
354 LEAST(c0, c2)
355 1
356 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
357 def LEAST(c0, c3) 250 262140 1 Y 0 39 8
358 LEAST(c0, c3)
359 1
360 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
361 def LEAST(c0, c4) 251 67108860 1 Y 0 39 8
362 LEAST(c0, c4)
363 1
364 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
365 def LEAST(c0, c5) 251 4294967292 1 Y 0 39 8
366 LEAST(c0, c5)
367 1
368 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
369 def LEAST(c0, c6) 5 23 1 Y 32896 31 63
370 LEAST(c0, c6)
371 1
372 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
373 def LEAST(c0, c7) 253 30 1 Y 0 39 8
374 LEAST(c0, c7)
375 1
376 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
377 def LEAST(c1, c0) 253 30 1 Y 0 39 8
378 LEAST(c1, c0)
379 1
380 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
381 def LEAST(c1, c1) 253 30 1 Y 0 39 8
382 LEAST(c1, c1)
383 1
384 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
385 def LEAST(c1, c2) 252 1020 1 Y 0 39 8
386 LEAST(c1, c2)
387 1
388 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
389 def LEAST(c1, c3) 250 262140 1 Y 0 39 8
390 LEAST(c1, c3)
391 1
392 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
393 def LEAST(c1, c4) 251 67108860 1 Y 0 39 8
394 LEAST(c1, c4)
395 1
396 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
397 def LEAST(c1, c5) 251 4294967292 1 Y 0 39 8
398 LEAST(c1, c5)
399 1
400 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
401 def LEAST(c1, c6) 5 23 1 Y 32896 31 63
402 LEAST(c1, c6)
403 1
404 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
405 def LEAST(c1, c7) 253 30 1 Y 0 39 8
406 LEAST(c1, c7)
407 1
408 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
409 def LEAST(c2, c0) 252 1020 1 Y 0 39 8
410 LEAST(c2, c0)
411 1
412 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
413 def LEAST(c2, c1) 252 1020 1 Y 0 39 8
414 LEAST(c2, c1)
415 1
416 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
417 def LEAST(c2, c2) 252 1020 1 Y 0 39 8
418 LEAST(c2, c2)
419 1
420 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
421 def LEAST(c2, c3) 250 262140 1 Y 0 39 8
422 LEAST(c2, c3)
423 1
424 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
425 def LEAST(c2, c4) 251 67108860 1 Y 0 39 8
426 LEAST(c2, c4)
427 1
428 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
429 def LEAST(c2, c5) 251 4294967292 1 Y 0 39 8
430 LEAST(c2, c5)
431 1
432 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
433 def LEAST(c2, c6) 5 23 1 Y 32896 31 63
434 LEAST(c2, c6)
435 1
436 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
437 def LEAST(c2, c7) 252 1020 1 Y 0 39 8
438 LEAST(c2, c7)
439 1
440 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
441 def LEAST(c3, c0) 250 262140 1 Y 0 39 8
442 LEAST(c3, c0)
443 1
444 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
445 def LEAST(c3, c1) 250 262140 1 Y 0 39 8
446 LEAST(c3, c1)
447 1
448 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
449 def LEAST(c3, c2) 250 262140 1 Y 0 39 8
450 LEAST(c3, c2)
451 1
452 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
453 def LEAST(c3, c3) 250 262140 1 Y 0 39 8
454 LEAST(c3, c3)
455 1
456 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
457 def LEAST(c3, c4) 251 67108860 1 Y 0 39 8
458 LEAST(c3, c4)
459 1
460 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
461 def LEAST(c3, c5) 251 4294967292 1 Y 0 39 8
462 LEAST(c3, c5)
463 1
464 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
465 def LEAST(c3, c6) 5 23 1 Y 32896 31 63
466 LEAST(c3, c6)
467 1
468 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
469 def LEAST(c3, c7) 250 262140 1 Y 0 39 8
470 LEAST(c3, c7)
471 1
472 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
473 def LEAST(c4, c0) 251 67108860 1 Y 0 39 8
474 LEAST(c4, c0)
475 1
476 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
477 def LEAST(c4, c1) 251 67108860 1 Y 0 39 8
478 LEAST(c4, c1)
479 1
480 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
481 def LEAST(c4, c2) 251 67108860 1 Y 0 39 8
482 LEAST(c4, c2)
483 1
484 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
485 def LEAST(c4, c3) 251 67108860 1 Y 0 39 8
486 LEAST(c4, c3)
487 1
488 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
489 def LEAST(c4, c4) 251 67108860 1 Y 0 39 8
490 LEAST(c4, c4)
491 1
492 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
493 def LEAST(c4, c5) 251 4294967292 1 Y 0 39 8
494 LEAST(c4, c5)
495 1
496 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
497 def LEAST(c4, c6) 5 23 1 Y 32896 31 63
498 LEAST(c4, c6)
499 1
500 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
501 def LEAST(c4, c7) 251 67108860 1 Y 0 39 8
502 LEAST(c4, c7)
503 1
504 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
505 def LEAST(c5, c0) 251 4294967292 1 Y 0 39 8
506 LEAST(c5, c0)
507 1
508 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
509 def LEAST(c5, c1) 251 4294967292 1 Y 0 39 8
510 LEAST(c5, c1)
511 1
512 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
513 def LEAST(c5, c2) 251 4294967292 1 Y 0 39 8
514 LEAST(c5, c2)
515 1
516 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
517 def LEAST(c5, c3) 251 4294967292 1 Y 0 39 8
518 LEAST(c5, c3)
519 1
520 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
521 def LEAST(c5, c4) 251 4294967292 1 Y 0 39 8
522 LEAST(c5, c4)
523 1
524 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
525 def LEAST(c5, c5) 251 4294967292 1 Y 0 39 8
526 LEAST(c5, c5)
527 1
528 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
529 def LEAST(c5, c6) 5 23 1 Y 32896 31 63
530 LEAST(c5, c6)
531 1
532 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
533 def LEAST(c5, c7) 251 4294967292 1 Y 0 39 8
534 LEAST(c5, c7)
535 1
536 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
537 def LEAST(c6, c0) 5 23 1 Y 32896 31 63
538 LEAST(c6, c0)
539 1
540 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
541 def LEAST(c6, c1) 5 23 1 Y 32896 31 63
542 LEAST(c6, c1)
543 1
544 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
545 def LEAST(c6, c2) 5 23 1 Y 32896 31 63
546 LEAST(c6, c2)
547 1
548 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
549 def LEAST(c6, c3) 5 23 1 Y 32896 31 63
550 LEAST(c6, c3)
551 1
552 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
553 def LEAST(c6, c4) 5 23 1 Y 32896 31 63
554 LEAST(c6, c4)
555 1
556 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
557 def LEAST(c6, c5) 5 23 1 Y 32896 31 63
558 LEAST(c6, c5)
559 1
560 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
561 def LEAST(c6, c6) 3 11 1 Y 32896 0 63
562 LEAST(c6, c6)
563 1
564 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
565 def LEAST(c6, c7) 5 17 1 Y 32896 0 63
566 LEAST(c6, c7)
567 1
568 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
569 def LEAST(c7, c0) 253 30 1 Y 0 39 8
570 LEAST(c7, c0)
571 1
572 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
573 def LEAST(c7, c1) 253 30 1 Y 0 39 8
574 LEAST(c7, c1)
575 1
576 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
577 def LEAST(c7, c2) 252 1020 1 Y 0 39 8
578 LEAST(c7, c2)
579 1
580 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
581 def LEAST(c7, c3) 250 262140 1 Y 0 39 8
582 LEAST(c7, c3)
583 1
584 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
585 def LEAST(c7, c4) 251 67108860 1 Y 0 39 8
586 LEAST(c7, c4)
587 1
588 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
589 def LEAST(c7, c5) 251 4294967292 1 Y 0 39 8
590 LEAST(c7, c5)
591 1
592 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
593 def LEAST(c7, c6) 5 17 1 Y 32896 0 63
594 LEAST(c7, c6)
595 1
596 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
597 def LEAST(c7, c7) 253 1 1 Y 0 39 8
598 LEAST(c7, c7)
599 1
600 CALL p1('t1', 'colt1+colt2');
601 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
602 def c0+c0 5 23 1 Y 32896 31 63
603 c0+c0
604 2
605 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
606 def c0+c1 5 23 1 Y 32896 31 63
607 c0+c1
608 2
609 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
610 def c0+c2 5 23 1 Y 32896 31 63
611 c0+c2
612 2
613 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
614 def c0+c3 5 23 1 Y 32896 31 63
615 c0+c3
616 2
617 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
618 def c0+c4 5 23 1 Y 32896 31 63
619 c0+c4
620 2
621 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
622 def c0+c5 5 23 1 Y 32896 31 63
623 c0+c5
624 2
625 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
626 def c0+c6 5 23 1 Y 32896 31 63
627 c0+c6
628 2
629 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
630 def c0+c7 5 23 1 Y 32896 31 63
631 c0+c7
632 2
633 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
634 def c1+c0 5 23 1 Y 32896 31 63
635 c1+c0
636 2
637 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
638 def c1+c1 5 23 1 Y 32896 31 63
639 c1+c1
640 2
641 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
642 def c1+c2 5 23 1 Y 32896 31 63
643 c1+c2
644 2
645 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
646 def c1+c3 5 23 1 Y 32896 31 63
647 c1+c3
648 2
649 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
650 def c1+c4 5 23 1 Y 32896 31 63
651 c1+c4
652 2
653 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
654 def c1+c5 5 23 1 Y 32896 31 63
655 c1+c5
656 2
657 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
658 def c1+c6 5 23 1 Y 32896 31 63
659 c1+c6
660 2
661 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
662 def c1+c7 5 23 1 Y 32896 31 63
663 c1+c7
664 2
665 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
666 def c2+c0 5 23 1 Y 32896 31 63
667 c2+c0
668 2
669 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
670 def c2+c1 5 23 1 Y 32896 31 63
671 c2+c1
672 2
673 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
674 def c2+c2 5 23 1 Y 32896 31 63
675 c2+c2
676 2
677 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
678 def c2+c3 5 23 1 Y 32896 31 63
679 c2+c3
680 2
681 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
682 def c2+c4 5 23 1 Y 32896 31 63
683 c2+c4
684 2
685 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
686 def c2+c5 5 23 1 Y 32896 31 63
687 c2+c5
688 2
689 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
690 def c2+c6 5 23 1 Y 32896 31 63
691 c2+c6
692 2
693 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
694 def c2+c7 5 23 1 Y 32896 31 63
695 c2+c7
696 2
697 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
698 def c3+c0 5 23 1 Y 32896 31 63
699 c3+c0
700 2
701 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
702 def c3+c1 5 23 1 Y 32896 31 63
703 c3+c1
704 2
705 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
706 def c3+c2 5 23 1 Y 32896 31 63
707 c3+c2
708 2
709 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
710 def c3+c3 5 23 1 Y 32896 31 63
711 c3+c3
712 2
713 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
714 def c3+c4 5 23 1 Y 32896 31 63
715 c3+c4
716 2
717 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
718 def c3+c5 5 23 1 Y 32896 31 63
719 c3+c5
720 2
721 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
722 def c3+c6 5 23 1 Y 32896 31 63
723 c3+c6
724 2
725 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
726 def c3+c7 5 23 1 Y 32896 31 63
727 c3+c7
728 2
729 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
730 def c4+c0 5 23 1 Y 32896 31 63
731 c4+c0
732 2
733 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
734 def c4+c1 5 23 1 Y 32896 31 63
735 c4+c1
736 2
737 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
738 def c4+c2 5 23 1 Y 32896 31 63
739 c4+c2
740 2
741 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
742 def c4+c3 5 23 1 Y 32896 31 63
743 c4+c3
744 2
745 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
746 def c4+c4 5 23 1 Y 32896 31 63
747 c4+c4
748 2
749 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
750 def c4+c5 5 23 1 Y 32896 31 63
751 c4+c5
752 2
753 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
754 def c4+c6 5 23 1 Y 32896 31 63
755 c4+c6
756 2
757 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
758 def c4+c7 5 23 1 Y 32896 31 63
759 c4+c7
760 2
761 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
762 def c5+c0 5 23 1 Y 32896 31 63
763 c5+c0
764 2
765 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
766 def c5+c1 5 23 1 Y 32896 31 63
767 c5+c1
768 2
769 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
770 def c5+c2 5 23 1 Y 32896 31 63
771 c5+c2
772 2
773 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
774 def c5+c3 5 23 1 Y 32896 31 63
775 c5+c3
776 2
777 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
778 def c5+c4 5 23 1 Y 32896 31 63
779 c5+c4
780 2
781 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
782 def c5+c5 5 23 1 Y 32896 31 63
783 c5+c5
784 2
785 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
786 def c5+c6 5 23 1 Y 32896 31 63
787 c5+c6
788 2
789 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
790 def c5+c7 5 23 1 Y 32896 31 63
791 c5+c7
792 2
793 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
794 def c6+c0 5 23 1 Y 32896 31 63
795 c6+c0
796 2
797 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
798 def c6+c1 5 23 1 Y 32896 31 63
799 c6+c1
800 2
801 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
802 def c6+c2 5 23 1 Y 32896 31 63
803 c6+c2
804 2
805 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
806 def c6+c3 5 23 1 Y 32896 31 63
807 c6+c3
808 2
809 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
810 def c6+c4 5 23 1 Y 32896 31 63
811 c6+c4
812 2
813 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
814 def c6+c5 5 23 1 Y 32896 31 63
815 c6+c5
816 2
817 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
818 def c6+c6 8 12 1 Y 32896 0 63
819 c6+c6
820 2
821 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
822 def c6+c7 8 12 1 Y 32896 0 63
823 c6+c7
824 2
825 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
826 def c7+c0 5 23 1 Y 32896 31 63
827 c7+c0
828 2
829 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
830 def c7+c1 5 23 1 Y 32896 31 63
831 c7+c1
832 2
833 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
834 def c7+c2 5 23 1 Y 32896 31 63
835 c7+c2
836 2
837 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
838 def c7+c3 5 23 1 Y 32896 31 63
839 c7+c3
840 2
841 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
842 def c7+c4 5 23 1 Y 32896 31 63
843 c7+c4
844 2
845 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
846 def c7+c5 5 23 1 Y 32896 31 63
847 c7+c5
848 2
849 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
850 def c7+c6 8 12 1 Y 32896 0 63
851 c7+c6
852 2
853 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
854 def c7+c7 3 3 1 Y 32896 0 63
855 c7+c7
856 2
857 CALL p1('t1c', 'COALESCE(colt1, colt2)');
858 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
859 def COALESCE(c0, c0) 254 (format=json) 30 1 Y 0 39 8
860 COALESCE(c0, c0)
861 1
862 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
863 def COALESCE(c0, c1) 253 (format=json) 30 1 Y 0 39 8
864 COALESCE(c0, c1)
865 1
866 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
867 def COALESCE(c0, c2) 252 (format=json) 1020 1 Y 0 39 8
868 COALESCE(c0, c2)
869 1
870 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
871 def COALESCE(c0, c3) 250 (format=json) 262140 1 Y 0 39 8
872 COALESCE(c0, c3)
873 1
874 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
875 def COALESCE(c0, c4) 251 (format=json) 67108860 1 Y 0 39 8
876 COALESCE(c0, c4)
877 1
878 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
879 def COALESCE(c0, c5) 251 (format=json) 4294967292 1 Y 0 39 8
880 COALESCE(c0, c5)
881 1
882 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
883 def COALESCE(c0, c6) 254 30 1 Y 0 39 8
884 COALESCE(c0, c6)
885 1
886 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
887 def COALESCE(c0, c7) 253 30 1 Y 0 39 8
888 COALESCE(c0, c7)
889 1
890 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
891 def COALESCE(c1, c0) 253 (format=json) 30 1 Y 0 39 8
892 COALESCE(c1, c0)
893 1
894 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
895 def COALESCE(c1, c1) 253 (format=json) 30 1 Y 0 39 8
896 COALESCE(c1, c1)
897 1
898 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
899 def COALESCE(c1, c2) 252 (format=json) 1020 1 Y 0 39 8
900 COALESCE(c1, c2)
901 1
902 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
903 def COALESCE(c1, c3) 250 (format=json) 262140 1 Y 0 39 8
904 COALESCE(c1, c3)
905 1
906 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
907 def COALESCE(c1, c4) 251 (format=json) 67108860 1 Y 0 39 8
908 COALESCE(c1, c4)
909 1
910 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
911 def COALESCE(c1, c5) 251 (format=json) 4294967292 1 Y 0 39 8
912 COALESCE(c1, c5)
913 1
914 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
915 def COALESCE(c1, c6) 253 30 1 Y 0 39 8
916 COALESCE(c1, c6)
917 1
918 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
919 def COALESCE(c1, c7) 253 30 1 Y 0 39 8
920 COALESCE(c1, c7)
921 1
922 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
923 def COALESCE(c2, c0) 252 (format=json) 1020 1 Y 0 39 8
924 COALESCE(c2, c0)
925 1
926 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
927 def COALESCE(c2, c1) 252 (format=json) 1020 1 Y 0 39 8
928 COALESCE(c2, c1)
929 1
930 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
931 def COALESCE(c2, c2) 252 (format=json) 1020 1 Y 0 39 8
932 COALESCE(c2, c2)
933 1
934 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
935 def COALESCE(c2, c3) 250 (format=json) 262140 1 Y 0 39 8
936 COALESCE(c2, c3)
937 1
938 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
939 def COALESCE(c2, c4) 251 (format=json) 67108860 1 Y 0 39 8
940 COALESCE(c2, c4)
941 1
942 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
943 def COALESCE(c2, c5) 251 (format=json) 4294967292 1 Y 0 39 8
944 COALESCE(c2, c5)
945 1
946 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
947 def COALESCE(c2, c6) 252 1020 1 Y 0 39 8
948 COALESCE(c2, c6)
949 1
950 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
951 def COALESCE(c2, c7) 252 1020 1 Y 0 39 8
952 COALESCE(c2, c7)
953 1
954 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
955 def COALESCE(c3, c0) 250 (format=json) 262140 1 Y 0 39 8
956 COALESCE(c3, c0)
957 1
958 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
959 def COALESCE(c3, c1) 250 (format=json) 262140 1 Y 0 39 8
960 COALESCE(c3, c1)
961 1
962 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
963 def COALESCE(c3, c2) 250 (format=json) 262140 1 Y 0 39 8
964 COALESCE(c3, c2)
965 1
966 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
967 def COALESCE(c3, c3) 250 (format=json) 262140 1 Y 0 39 8
968 COALESCE(c3, c3)
969 1
970 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
971 def COALESCE(c3, c4) 251 (format=json) 67108860 1 Y 0 39 8
972 COALESCE(c3, c4)
973 1
974 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
975 def COALESCE(c3, c5) 251 (format=json) 4294967292 1 Y 0 39 8
976 COALESCE(c3, c5)
977 1
978 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
979 def COALESCE(c3, c6) 250 262140 1 Y 0 39 8
980 COALESCE(c3, c6)
981 1
982 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
983 def COALESCE(c3, c7) 250 262140 1 Y 0 39 8
984 COALESCE(c3, c7)
985 1
986 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
987 def COALESCE(c4, c0) 251 (format=json) 67108860 1 Y 0 39 8
988 COALESCE(c4, c0)
989 1
990 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
991 def COALESCE(c4, c1) 251 (format=json) 67108860 1 Y 0 39 8
992 COALESCE(c4, c1)
993 1
994 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
995 def COALESCE(c4, c2) 251 (format=json) 67108860 1 Y 0 39 8
996 COALESCE(c4, c2)
997 1
998 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
999 def COALESCE(c4, c3) 251 (format=json) 67108860 1 Y 0 39 8
1000 COALESCE(c4, c3)
1001 1
1002 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1003 def COALESCE(c4, c4) 251 (format=json) 67108860 1 Y 0 39 8
1004 COALESCE(c4, c4)
1005 1
1006 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1007 def COALESCE(c4, c5) 251 (format=json) 4294967292 1 Y 0 39 8
1008 COALESCE(c4, c5)
1009 1
1010 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1011 def COALESCE(c4, c6) 251 67108860 1 Y 0 39 8
1012 COALESCE(c4, c6)
1013 1
1014 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1015 def COALESCE(c4, c7) 251 67108860 1 Y 0 39 8
1016 COALESCE(c4, c7)
1017 1
1018 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1019 def COALESCE(c5, c0) 251 (format=json) 4294967292 1 Y 0 39 8
1020 COALESCE(c5, c0)
1021 1
1022 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1023 def COALESCE(c5, c1) 251 (format=json) 4294967292 1 Y 0 39 8
1024 COALESCE(c5, c1)
1025 1
1026 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1027 def COALESCE(c5, c2) 251 (format=json) 4294967292 1 Y 0 39 8
1028 COALESCE(c5, c2)
1029 1
1030 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1031 def COALESCE(c5, c3) 251 (format=json) 4294967292 1 Y 0 39 8
1032 COALESCE(c5, c3)
1033 1
1034 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1035 def COALESCE(c5, c4) 251 (format=json) 4294967292 1 Y 0 39 8
1036 COALESCE(c5, c4)
1037 1
1038 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1039 def COALESCE(c5, c5) 251 (format=json) 4294967292 1 Y 0 39 8
1040 COALESCE(c5, c5)
1041 1
1042 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1043 def COALESCE(c5, c6) 251 4294967292 1 Y 0 39 8
1044 COALESCE(c5, c6)
1045 1
1046 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1047 def COALESCE(c5, c7) 251 4294967292 1 Y 0 39 8
1048 COALESCE(c5, c7)
1049 1
1050 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1051 def COALESCE(c6, c0) 254 30 1 Y 0 39 8
1052 COALESCE(c6, c0)
1053 1
1054 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1055 def COALESCE(c6, c1) 253 30 1 Y 0 39 8
1056 COALESCE(c6, c1)
1057 1
1058 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1059 def COALESCE(c6, c2) 252 1020 1 Y 0 39 8
1060 COALESCE(c6, c2)
1061 1
1062 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1063 def COALESCE(c6, c3) 250 262140 1 Y 0 39 8
1064 COALESCE(c6, c3)
1065 1
1066 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1067 def COALESCE(c6, c4) 251 67108860 1 Y 0 39 8
1068 COALESCE(c6, c4)
1069 1
1070 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1071 def COALESCE(c6, c5) 251 4294967292 1 Y 0 39 8
1072 COALESCE(c6, c5)
1073 1
1074 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1075 def COALESCE(c6, c6) 3 11 1 Y 32896 0 63
1076 COALESCE(c6, c6)
1077 1
1078 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1079 def COALESCE(c6, c7) 253 11 1 Y 0 39 8
1080 COALESCE(c6, c7)
1081 1
1082 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1083 def COALESCE(c7, c0) 253 30 1 Y 0 39 8
1084 COALESCE(c7, c0)
1085 1
1086 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1087 def COALESCE(c7, c1) 253 30 1 Y 0 39 8
1088 COALESCE(c7, c1)
1089 1
1090 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1091 def COALESCE(c7, c2) 252 1020 1 Y 0 39 8
1092 COALESCE(c7, c2)
1093 1
1094 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1095 def COALESCE(c7, c3) 250 262140 1 Y 0 39 8
1096 COALESCE(c7, c3)
1097 1
1098 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1099 def COALESCE(c7, c4) 251 67108860 1 Y 0 39 8
1100 COALESCE(c7, c4)
1101 1
1102 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1103 def COALESCE(c7, c5) 251 4294967292 1 Y 0 39 8
1104 COALESCE(c7, c5)
1105 1
1106 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1107 def COALESCE(c7, c6) 253 11 1 Y 0 39 8
1108 COALESCE(c7, c6)
1109 1
1110 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1111 def COALESCE(c7, c7) 253 1 1 Y 0 39 8
1112 COALESCE(c7, c7)
1113 1
1114 CALL p1('t1c', 'LEAST(colt1, colt2)');
1115 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1116 def LEAST(c0, c0) 254 30 1 Y 0 39 8
1117 LEAST(c0, c0)
1118 1
1119 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1120 def LEAST(c0, c1) 253 30 1 Y 0 39 8
1121 LEAST(c0, c1)
1122 1
1123 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1124 def LEAST(c0, c2) 252 1020 1 Y 0 39 8
1125 LEAST(c0, c2)
1126 1
1127 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1128 def LEAST(c0, c3) 250 262140 1 Y 0 39 8
1129 LEAST(c0, c3)
1130 1
1131 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1132 def LEAST(c0, c4) 251 67108860 1 Y 0 39 8
1133 LEAST(c0, c4)
1134 1
1135 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1136 def LEAST(c0, c5) 251 4294967292 1 Y 0 39 8
1137 LEAST(c0, c5)
1138 1
1139 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1140 def LEAST(c0, c6) 5 23 1 Y 32896 31 63
1141 LEAST(c0, c6)
1142 1
1143 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1144 def LEAST(c0, c7) 253 30 1 Y 0 39 8
1145 LEAST(c0, c7)
1146 1
1147 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1148 def LEAST(c1, c0) 253 30 1 Y 0 39 8
1149 LEAST(c1, c0)
1150 1
1151 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1152 def LEAST(c1, c1) 253 30 1 Y 0 39 8
1153 LEAST(c1, c1)
1154 1
1155 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1156 def LEAST(c1, c2) 252 1020 1 Y 0 39 8
1157 LEAST(c1, c2)
1158 1
1159 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1160 def LEAST(c1, c3) 250 262140 1 Y 0 39 8
1161 LEAST(c1, c3)
1162 1
1163 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1164 def LEAST(c1, c4) 251 67108860 1 Y 0 39 8
1165 LEAST(c1, c4)
1166 1
1167 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1168 def LEAST(c1, c5) 251 4294967292 1 Y 0 39 8
1169 LEAST(c1, c5)
1170 1
1171 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1172 def LEAST(c1, c6) 5 23 1 Y 32896 31 63
1173 LEAST(c1, c6)
1174 1
1175 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1176 def LEAST(c1, c7) 253 30 1 Y 0 39 8
1177 LEAST(c1, c7)
1178 1
1179 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1180 def LEAST(c2, c0) 252 1020 1 Y 0 39 8
1181 LEAST(c2, c0)
1182 1
1183 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1184 def LEAST(c2, c1) 252 1020 1 Y 0 39 8
1185 LEAST(c2, c1)
1186 1
1187 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1188 def LEAST(c2, c2) 252 1020 1 Y 0 39 8
1189 LEAST(c2, c2)
1190 1
1191 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1192 def LEAST(c2, c3) 250 262140 1 Y 0 39 8
1193 LEAST(c2, c3)
1194 1
1195 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1196 def LEAST(c2, c4) 251 67108860 1 Y 0 39 8
1197 LEAST(c2, c4)
1198 1
1199 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1200 def LEAST(c2, c5) 251 4294967292 1 Y 0 39 8
1201 LEAST(c2, c5)
1202 1
1203 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1204 def LEAST(c2, c6) 5 23 1 Y 32896 31 63
1205 LEAST(c2, c6)
1206 1
1207 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1208 def LEAST(c2, c7) 252 1020 1 Y 0 39 8
1209 LEAST(c2, c7)
1210 1
1211 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1212 def LEAST(c3, c0) 250 262140 1 Y 0 39 8
1213 LEAST(c3, c0)
1214 1
1215 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1216 def LEAST(c3, c1) 250 262140 1 Y 0 39 8
1217 LEAST(c3, c1)
1218 1
1219 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1220 def LEAST(c3, c2) 250 262140 1 Y 0 39 8
1221 LEAST(c3, c2)
1222 1
1223 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1224 def LEAST(c3, c3) 250 262140 1 Y 0 39 8
1225 LEAST(c3, c3)
1226 1
1227 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1228 def LEAST(c3, c4) 251 67108860 1 Y 0 39 8
1229 LEAST(c3, c4)
1230 1
1231 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1232 def LEAST(c3, c5) 251 4294967292 1 Y 0 39 8
1233 LEAST(c3, c5)
1234 1
1235 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1236 def LEAST(c3, c6) 5 23 1 Y 32896 31 63
1237 LEAST(c3, c6)
1238 1
1239 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1240 def LEAST(c3, c7) 250 262140 1 Y 0 39 8
1241 LEAST(c3, c7)
1242 1
1243 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1244 def LEAST(c4, c0) 251 67108860 1 Y 0 39 8
1245 LEAST(c4, c0)
1246 1
1247 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1248 def LEAST(c4, c1) 251 67108860 1 Y 0 39 8
1249 LEAST(c4, c1)
1250 1
1251 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1252 def LEAST(c4, c2) 251 67108860 1 Y 0 39 8
1253 LEAST(c4, c2)
1254 1
1255 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1256 def LEAST(c4, c3) 251 67108860 1 Y 0 39 8
1257 LEAST(c4, c3)
1258 1
1259 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1260 def LEAST(c4, c4) 251 67108860 1 Y 0 39 8
1261 LEAST(c4, c4)
1262 1
1263 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1264 def LEAST(c4, c5) 251 4294967292 1 Y 0 39 8
1265 LEAST(c4, c5)
1266 1
1267 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1268 def LEAST(c4, c6) 5 23 1 Y 32896 31 63
1269 LEAST(c4, c6)
1270 1
1271 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1272 def LEAST(c4, c7) 251 67108860 1 Y 0 39 8
1273 LEAST(c4, c7)
1274 1
1275 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1276 def LEAST(c5, c0) 251 4294967292 1 Y 0 39 8
1277 LEAST(c5, c0)
1278 1
1279 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1280 def LEAST(c5, c1) 251 4294967292 1 Y 0 39 8
1281 LEAST(c5, c1)
1282 1
1283 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1284 def LEAST(c5, c2) 251 4294967292 1 Y 0 39 8
1285 LEAST(c5, c2)
1286 1
1287 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1288 def LEAST(c5, c3) 251 4294967292 1 Y 0 39 8
1289 LEAST(c5, c3)
1290 1
1291 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1292 def LEAST(c5, c4) 251 4294967292 1 Y 0 39 8
1293 LEAST(c5, c4)
1294 1
1295 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1296 def LEAST(c5, c5) 251 4294967292 1 Y 0 39 8
1297 LEAST(c5, c5)
1298 1
1299 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1300 def LEAST(c5, c6) 5 23 1 Y 32896 31 63
1301 LEAST(c5, c6)
1302 1
1303 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1304 def LEAST(c5, c7) 251 4294967292 1 Y 0 39 8
1305 LEAST(c5, c7)
1306 1
1307 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1308 def LEAST(c6, c0) 5 23 1 Y 32896 31 63
1309 LEAST(c6, c0)
1310 1
1311 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1312 def LEAST(c6, c1) 5 23 1 Y 32896 31 63
1313 LEAST(c6, c1)
1314 1
1315 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1316 def LEAST(c6, c2) 5 23 1 Y 32896 31 63
1317 LEAST(c6, c2)
1318 1
1319 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1320 def LEAST(c6, c3) 5 23 1 Y 32896 31 63
1321 LEAST(c6, c3)
1322 1
1323 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1324 def LEAST(c6, c4) 5 23 1 Y 32896 31 63
1325 LEAST(c6, c4)
1326 1
1327 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1328 def LEAST(c6, c5) 5 23 1 Y 32896 31 63
1329 LEAST(c6, c5)
1330 1
1331 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1332 def LEAST(c6, c6) 3 11 1 Y 32896 0 63
1333 LEAST(c6, c6)
1334 1
1335 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1336 def LEAST(c6, c7) 5 17 1 Y 32896 0 63
1337 LEAST(c6, c7)
1338 1
1339 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1340 def LEAST(c7, c0) 253 30 1 Y 0 39 8
1341 LEAST(c7, c0)
1342 1
1343 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1344 def LEAST(c7, c1) 253 30 1 Y 0 39 8
1345 LEAST(c7, c1)
1346 1
1347 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1348 def LEAST(c7, c2) 252 1020 1 Y 0 39 8
1349 LEAST(c7, c2)
1350 1
1351 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1352 def LEAST(c7, c3) 250 262140 1 Y 0 39 8
1353 LEAST(c7, c3)
1354 1
1355 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1356 def LEAST(c7, c4) 251 67108860 1 Y 0 39 8
1357 LEAST(c7, c4)
1358 1
1359 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1360 def LEAST(c7, c5) 251 4294967292 1 Y 0 39 8
1361 LEAST(c7, c5)
1362 1
1363 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1364 def LEAST(c7, c6) 5 17 1 Y 32896 0 63
1365 LEAST(c7, c6)
1366 1
1367 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1368 def LEAST(c7, c7) 253 1 1 Y 0 39 8
1369 LEAST(c7, c7)
1370 1
1371 CALL p1('t1c', 'colt1+colt2');
1372 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1373 def c0+c0 5 23 1 Y 32896 31 63
1374 c0+c0
1375 2
1376 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1377 def c0+c1 5 23 1 Y 32896 31 63
1378 c0+c1
1379 2
1380 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1381 def c0+c2 5 23 1 Y 32896 31 63
1382 c0+c2
1383 2
1384 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1385 def c0+c3 5 23 1 Y 32896 31 63
1386 c0+c3
1387 2
1388 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1389 def c0+c4 5 23 1 Y 32896 31 63
1390 c0+c4
1391 2
1392 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1393 def c0+c5 5 23 1 Y 32896 31 63
1394 c0+c5
1395 2
1396 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1397 def c0+c6 5 23 1 Y 32896 31 63
1398 c0+c6
1399 2
1400 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1401 def c0+c7 5 23 1 Y 32896 31 63
1402 c0+c7
1403 2
1404 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1405 def c1+c0 5 23 1 Y 32896 31 63
1406 c1+c0
1407 2
1408 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1409 def c1+c1 5 23 1 Y 32896 31 63
1410 c1+c1
1411 2
1412 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1413 def c1+c2 5 23 1 Y 32896 31 63
1414 c1+c2
1415 2
1416 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1417 def c1+c3 5 23 1 Y 32896 31 63
1418 c1+c3
1419 2
1420 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1421 def c1+c4 5 23 1 Y 32896 31 63
1422 c1+c4
1423 2
1424 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1425 def c1+c5 5 23 1 Y 32896 31 63
1426 c1+c5
1427 2
1428 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1429 def c1+c6 5 23 1 Y 32896 31 63
1430 c1+c6
1431 2
1432 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1433 def c1+c7 5 23 1 Y 32896 31 63
1434 c1+c7
1435 2
1436 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1437 def c2+c0 5 23 1 Y 32896 31 63
1438 c2+c0
1439 2
1440 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1441 def c2+c1 5 23 1 Y 32896 31 63
1442 c2+c1
1443 2
1444 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1445 def c2+c2 5 23 1 Y 32896 31 63
1446 c2+c2
1447 2
1448 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1449 def c2+c3 5 23 1 Y 32896 31 63
1450 c2+c3
1451 2
1452 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1453 def c2+c4 5 23 1 Y 32896 31 63
1454 c2+c4
1455 2
1456 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1457 def c2+c5 5 23 1 Y 32896 31 63
1458 c2+c5
1459 2
1460 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1461 def c2+c6 5 23 1 Y 32896 31 63
1462 c2+c6
1463 2
1464 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1465 def c2+c7 5 23 1 Y 32896 31 63
1466 c2+c7
1467 2
1468 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1469 def c3+c0 5 23 1 Y 32896 31 63
1470 c3+c0
1471 2
1472 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1473 def c3+c1 5 23 1 Y 32896 31 63
1474 c3+c1
1475 2
1476 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1477 def c3+c2 5 23 1 Y 32896 31 63
1478 c3+c2
1479 2
1480 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1481 def c3+c3 5 23 1 Y 32896 31 63
1482 c3+c3
1483 2
1484 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1485 def c3+c4 5 23 1 Y 32896 31 63
1486 c3+c4
1487 2
1488 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1489 def c3+c5 5 23 1 Y 32896 31 63
1490 c3+c5
1491 2
1492 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1493 def c3+c6 5 23 1 Y 32896 31 63
1494 c3+c6
1495 2
1496 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1497 def c3+c7 5 23 1 Y 32896 31 63
1498 c3+c7
1499 2
1500 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1501 def c4+c0 5 23 1 Y 32896 31 63
1502 c4+c0
1503 2
1504 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1505 def c4+c1 5 23 1 Y 32896 31 63
1506 c4+c1
1507 2
1508 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1509 def c4+c2 5 23 1 Y 32896 31 63
1510 c4+c2
1511 2
1512 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1513 def c4+c3 5 23 1 Y 32896 31 63
1514 c4+c3
1515 2
1516 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1517 def c4+c4 5 23 1 Y 32896 31 63
1518 c4+c4
1519 2
1520 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1521 def c4+c5 5 23 1 Y 32896 31 63
1522 c4+c5
1523 2
1524 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1525 def c4+c6 5 23 1 Y 32896 31 63
1526 c4+c6
1527 2
1528 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1529 def c4+c7 5 23 1 Y 32896 31 63
1530 c4+c7
1531 2
1532 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1533 def c5+c0 5 23 1 Y 32896 31 63
1534 c5+c0
1535 2
1536 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1537 def c5+c1 5 23 1 Y 32896 31 63
1538 c5+c1
1539 2
1540 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1541 def c5+c2 5 23 1 Y 32896 31 63
1542 c5+c2
1543 2
1544 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1545 def c5+c3 5 23 1 Y 32896 31 63
1546 c5+c3
1547 2
1548 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1549 def c5+c4 5 23 1 Y 32896 31 63
1550 c5+c4
1551 2
1552 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1553 def c5+c5 5 23 1 Y 32896 31 63
1554 c5+c5
1555 2
1556 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1557 def c5+c6 5 23 1 Y 32896 31 63
1558 c5+c6
1559 2
1560 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1561 def c5+c7 5 23 1 Y 32896 31 63
1562 c5+c7
1563 2
1564 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1565 def c6+c0 5 23 1 Y 32896 31 63
1566 c6+c0
1567 2
1568 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1569 def c6+c1 5 23 1 Y 32896 31 63
1570 c6+c1
1571 2
1572 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1573 def c6+c2 5 23 1 Y 32896 31 63
1574 c6+c2
1575 2
1576 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1577 def c6+c3 5 23 1 Y 32896 31 63
1578 c6+c3
1579 2
1580 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1581 def c6+c4 5 23 1 Y 32896 31 63
1582 c6+c4
1583 2
1584 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1585 def c6+c5 5 23 1 Y 32896 31 63
1586 c6+c5
1587 2
1588 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1589 def c6+c6 8 12 1 Y 32896 0 63
1590 c6+c6
1591 2
1592 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1593 def c6+c7 8 12 1 Y 32896 0 63
1594 c6+c7
1595 2
1596 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1597 def c7+c0 5 23 1 Y 32896 31 63
1598 c7+c0
1599 2
1600 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1601 def c7+c1 5 23 1 Y 32896 31 63
1602 c7+c1
1603 2
1604 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1605 def c7+c2 5 23 1 Y 32896 31 63
1606 c7+c2
1607 2
1608 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1609 def c7+c3 5 23 1 Y 32896 31 63
1610 c7+c3
1611 2
1612 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1613 def c7+c4 5 23 1 Y 32896 31 63
1614 c7+c4
1615 2
1616 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1617 def c7+c5 5 23 1 Y 32896 31 63
1618 c7+c5
1619 2
1620 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1621 def c7+c6 8 12 1 Y 32896 0 63
1622 c7+c6
1623 2
1624 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1625 def c7+c7 3 3 1 Y 32896 0 63
1626 c7+c7
1627 2
1628 CALL p2('COALESCE(t1.colt1, t2.colt2)');
1629 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1630 def COALESCE(t1.c0, t2.c0) 254 30 1 Y 0 39 8
1631 COALESCE(t1.c0, t2.c0)
1632 1
1633 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1634 def COALESCE(t1.c0, t2.c1) 253 30 1 Y 0 39 8
1635 COALESCE(t1.c0, t2.c1)
1636 1
1637 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1638 def COALESCE(t1.c0, t2.c2) 252 1020 1 Y 0 39 8
1639 COALESCE(t1.c0, t2.c2)
1640 1
1641 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1642 def COALESCE(t1.c0, t2.c3) 250 262140 1 Y 0 39 8
1643 COALESCE(t1.c0, t2.c3)
1644 1
1645 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1646 def COALESCE(t1.c0, t2.c4) 251 67108860 1 Y 0 39 8
1647 COALESCE(t1.c0, t2.c4)
1648 1
1649 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1650 def COALESCE(t1.c0, t2.c5) 251 4294967292 1 Y 0 39 8
1651 COALESCE(t1.c0, t2.c5)
1652 1
1653 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1654 def COALESCE(t1.c0, t2.c6) 254 30 1 Y 0 39 8
1655 COALESCE(t1.c0, t2.c6)
1656 1
1657 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1658 def COALESCE(t1.c0, t2.c7) 254 30 1 Y 0 39 8
1659 COALESCE(t1.c0, t2.c7)
1660 1
1661 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1662 def COALESCE(t1.c0, t2.c8) 254 30 1 Y 0 39 8
1663 COALESCE(t1.c0, t2.c8)
1664 1
1665 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1666 def COALESCE(t1.c0, t2.c9) 254 30 1 Y 0 39 8
1667 COALESCE(t1.c0, t2.c9)
1668 1
1669 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1670 def COALESCE(t1.c0, t2.c10) 254 30 1 Y 0 39 8
1671 COALESCE(t1.c0, t2.c10)
1672 1
1673 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1674 def COALESCE(t1.c0, t2.c11) 254 30 1 Y 0 39 8
1675 COALESCE(t1.c0, t2.c11)
1676 1
1677 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1678 def COALESCE(t1.c0, t2.c12) 253 30 1 Y 0 39 8
1679 COALESCE(t1.c0, t2.c12)
1680 1
1681 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1682 def COALESCE(t1.c1, t2.c0) 253 30 1 Y 0 39 8
1683 COALESCE(t1.c1, t2.c0)
1684 1
1685 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1686 def COALESCE(t1.c1, t2.c1) 253 30 1 Y 0 39 8
1687 COALESCE(t1.c1, t2.c1)
1688 1
1689 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1690 def COALESCE(t1.c1, t2.c2) 252 1020 1 Y 0 39 8
1691 COALESCE(t1.c1, t2.c2)
1692 1
1693 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1694 def COALESCE(t1.c1, t2.c3) 250 262140 1 Y 0 39 8
1695 COALESCE(t1.c1, t2.c3)
1696 1
1697 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1698 def COALESCE(t1.c1, t2.c4) 251 67108860 1 Y 0 39 8
1699 COALESCE(t1.c1, t2.c4)
1700 1
1701 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1702 def COALESCE(t1.c1, t2.c5) 251 4294967292 1 Y 0 39 8
1703 COALESCE(t1.c1, t2.c5)
1704 1
1705 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1706 def COALESCE(t1.c1, t2.c6) 253 30 1 Y 0 39 8
1707 COALESCE(t1.c1, t2.c6)
1708 1
1709 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1710 def COALESCE(t1.c1, t2.c7) 253 30 1 Y 0 39 8
1711 COALESCE(t1.c1, t2.c7)
1712 1
1713 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1714 def COALESCE(t1.c1, t2.c8) 253 30 1 Y 0 39 8
1715 COALESCE(t1.c1, t2.c8)
1716 1
1717 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1718 def COALESCE(t1.c1, t2.c9) 253 30 1 Y 0 39 8
1719 COALESCE(t1.c1, t2.c9)
1720 1
1721 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1722 def COALESCE(t1.c1, t2.c10) 253 30 1 Y 0 39 8
1723 COALESCE(t1.c1, t2.c10)
1724 1
1725 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1726 def COALESCE(t1.c1, t2.c11) 253 30 1 Y 0 39 8
1727 COALESCE(t1.c1, t2.c11)
1728 1
1729 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1730 def COALESCE(t1.c1, t2.c12) 253 30 1 Y 0 39 8
1731 COALESCE(t1.c1, t2.c12)
1732 1
1733 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1734 def COALESCE(t1.c2, t2.c0) 252 1020 1 Y 0 39 8
1735 COALESCE(t1.c2, t2.c0)
1736 1
1737 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1738 def COALESCE(t1.c2, t2.c1) 252 1020 1 Y 0 39 8
1739 COALESCE(t1.c2, t2.c1)
1740 1
1741 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1742 def COALESCE(t1.c2, t2.c2) 252 1020 1 Y 0 39 8
1743 COALESCE(t1.c2, t2.c2)
1744 1
1745 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1746 def COALESCE(t1.c2, t2.c3) 250 262140 1 Y 0 39 8
1747 COALESCE(t1.c2, t2.c3)
1748 1
1749 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1750 def COALESCE(t1.c2, t2.c4) 251 67108860 1 Y 0 39 8
1751 COALESCE(t1.c2, t2.c4)
1752 1
1753 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1754 def COALESCE(t1.c2, t2.c5) 251 4294967292 1 Y 0 39 8
1755 COALESCE(t1.c2, t2.c5)
1756 1
1757 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1758 def COALESCE(t1.c2, t2.c6) 252 1020 1 Y 0 39 8
1759 COALESCE(t1.c2, t2.c6)
1760 1
1761 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1762 def COALESCE(t1.c2, t2.c7) 252 1020 1 Y 0 39 8
1763 COALESCE(t1.c2, t2.c7)
1764 1
1765 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1766 def COALESCE(t1.c2, t2.c8) 252 1020 1 Y 0 39 8
1767 COALESCE(t1.c2, t2.c8)
1768 1
1769 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1770 def COALESCE(t1.c2, t2.c9) 252 1020 1 Y 0 39 8
1771 COALESCE(t1.c2, t2.c9)
1772 1
1773 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1774 def COALESCE(t1.c2, t2.c10) 252 1020 1 Y 0 39 8
1775 COALESCE(t1.c2, t2.c10)
1776 1
1777 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1778 def COALESCE(t1.c2, t2.c11) 252 1020 1 Y 0 39 8
1779 COALESCE(t1.c2, t2.c11)
1780 1
1781 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1782 def COALESCE(t1.c2, t2.c12) 252 1020 1 Y 0 39 8
1783 COALESCE(t1.c2, t2.c12)
1784 1
1785 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1786 def COALESCE(t1.c3, t2.c0) 250 262140 1 Y 0 39 8
1787 COALESCE(t1.c3, t2.c0)
1788 1
1789 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1790 def COALESCE(t1.c3, t2.c1) 250 262140 1 Y 0 39 8
1791 COALESCE(t1.c3, t2.c1)
1792 1
1793 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1794 def COALESCE(t1.c3, t2.c2) 250 262140 1 Y 0 39 8
1795 COALESCE(t1.c3, t2.c2)
1796 1
1797 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1798 def COALESCE(t1.c3, t2.c3) 250 262140 1 Y 0 39 8
1799 COALESCE(t1.c3, t2.c3)
1800 1
1801 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1802 def COALESCE(t1.c3, t2.c4) 251 67108860 1 Y 0 39 8
1803 COALESCE(t1.c3, t2.c4)
1804 1
1805 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1806 def COALESCE(t1.c3, t2.c5) 251 4294967292 1 Y 0 39 8
1807 COALESCE(t1.c3, t2.c5)
1808 1
1809 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1810 def COALESCE(t1.c3, t2.c6) 250 262140 1 Y 0 39 8
1811 COALESCE(t1.c3, t2.c6)
1812 1
1813 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1814 def COALESCE(t1.c3, t2.c7) 250 262140 1 Y 0 39 8
1815 COALESCE(t1.c3, t2.c7)
1816 1
1817 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1818 def COALESCE(t1.c3, t2.c8) 250 262140 1 Y 0 39 8
1819 COALESCE(t1.c3, t2.c8)
1820 1
1821 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1822 def COALESCE(t1.c3, t2.c9) 250 262140 1 Y 0 39 8
1823 COALESCE(t1.c3, t2.c9)
1824 1
1825 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1826 def COALESCE(t1.c3, t2.c10) 250 262140 1 Y 0 39 8
1827 COALESCE(t1.c3, t2.c10)
1828 1
1829 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1830 def COALESCE(t1.c3, t2.c11) 250 262140 1 Y 0 39 8
1831 COALESCE(t1.c3, t2.c11)
1832 1
1833 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1834 def COALESCE(t1.c3, t2.c12) 250 262140 1 Y 0 39 8
1835 COALESCE(t1.c3, t2.c12)
1836 1
1837 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1838 def COALESCE(t1.c4, t2.c0) 251 67108860 1 Y 0 39 8
1839 COALESCE(t1.c4, t2.c0)
1840 1
1841 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1842 def COALESCE(t1.c4, t2.c1) 251 67108860 1 Y 0 39 8
1843 COALESCE(t1.c4, t2.c1)
1844 1
1845 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1846 def COALESCE(t1.c4, t2.c2) 251 67108860 1 Y 0 39 8
1847 COALESCE(t1.c4, t2.c2)
1848 1
1849 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1850 def COALESCE(t1.c4, t2.c3) 251 67108860 1 Y 0 39 8
1851 COALESCE(t1.c4, t2.c3)
1852 1
1853 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1854 def COALESCE(t1.c4, t2.c4) 251 67108860 1 Y 0 39 8
1855 COALESCE(t1.c4, t2.c4)
1856 1
1857 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1858 def COALESCE(t1.c4, t2.c5) 251 4294967292 1 Y 0 39 8
1859 COALESCE(t1.c4, t2.c5)
1860 1
1861 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1862 def COALESCE(t1.c4, t2.c6) 251 67108860 1 Y 0 39 8
1863 COALESCE(t1.c4, t2.c6)
1864 1
1865 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1866 def COALESCE(t1.c4, t2.c7) 251 67108860 1 Y 0 39 8
1867 COALESCE(t1.c4, t2.c7)
1868 1
1869 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1870 def COALESCE(t1.c4, t2.c8) 251 67108860 1 Y 0 39 8
1871 COALESCE(t1.c4, t2.c8)
1872 1
1873 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1874 def COALESCE(t1.c4, t2.c9) 251 67108860 1 Y 0 39 8
1875 COALESCE(t1.c4, t2.c9)
1876 1
1877 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1878 def COALESCE(t1.c4, t2.c10) 251 67108860 1 Y 0 39 8
1879 COALESCE(t1.c4, t2.c10)
1880 1
1881 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1882 def COALESCE(t1.c4, t2.c11) 251 67108860 1 Y 0 39 8
1883 COALESCE(t1.c4, t2.c11)
1884 1
1885 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1886 def COALESCE(t1.c4, t2.c12) 251 67108860 1 Y 0 39 8
1887 COALESCE(t1.c4, t2.c12)
1888 1
1889 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1890 def COALESCE(t1.c5, t2.c0) 251 4294967292 1 Y 0 39 8
1891 COALESCE(t1.c5, t2.c0)
1892 1
1893 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1894 def COALESCE(t1.c5, t2.c1) 251 4294967292 1 Y 0 39 8
1895 COALESCE(t1.c5, t2.c1)
1896 1
1897 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1898 def COALESCE(t1.c5, t2.c2) 251 4294967292 1 Y 0 39 8
1899 COALESCE(t1.c5, t2.c2)
1900 1
1901 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1902 def COALESCE(t1.c5, t2.c3) 251 4294967292 1 Y 0 39 8
1903 COALESCE(t1.c5, t2.c3)
1904 1
1905 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1906 def COALESCE(t1.c5, t2.c4) 251 4294967292 1 Y 0 39 8
1907 COALESCE(t1.c5, t2.c4)
1908 1
1909 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1910 def COALESCE(t1.c5, t2.c5) 251 4294967292 1 Y 0 39 8
1911 COALESCE(t1.c5, t2.c5)
1912 1
1913 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1914 def COALESCE(t1.c5, t2.c6) 251 4294967292 1 Y 0 39 8
1915 COALESCE(t1.c5, t2.c6)
1916 1
1917 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1918 def COALESCE(t1.c5, t2.c7) 251 4294967292 1 Y 0 39 8
1919 COALESCE(t1.c5, t2.c7)
1920 1
1921 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1922 def COALESCE(t1.c5, t2.c8) 251 4294967292 1 Y 0 39 8
1923 COALESCE(t1.c5, t2.c8)
1924 1
1925 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1926 def COALESCE(t1.c5, t2.c9) 251 4294967292 1 Y 0 39 8
1927 COALESCE(t1.c5, t2.c9)
1928 1
1929 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1930 def COALESCE(t1.c5, t2.c10) 251 4294967292 1 Y 0 39 8
1931 COALESCE(t1.c5, t2.c10)
1932 1
1933 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1934 def COALESCE(t1.c5, t2.c11) 251 4294967292 1 Y 0 39 8
1935 COALESCE(t1.c5, t2.c11)
1936 1
1937 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1938 def COALESCE(t1.c5, t2.c12) 251 4294967292 1 Y 0 39 8
1939 COALESCE(t1.c5, t2.c12)
1940 1
1941 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1942 def COALESCE(t1.c6, t2.c0) 254 30 1 Y 0 39 8
1943 COALESCE(t1.c6, t2.c0)
1944 1
1945 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1946 def COALESCE(t1.c6, t2.c1) 253 30 1 Y 0 39 8
1947 COALESCE(t1.c6, t2.c1)
1948 1
1949 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1950 def COALESCE(t1.c6, t2.c2) 252 1020 1 Y 0 39 8
1951 COALESCE(t1.c6, t2.c2)
1952 1
1953 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1954 def COALESCE(t1.c6, t2.c3) 250 262140 1 Y 0 39 8
1955 COALESCE(t1.c6, t2.c3)
1956 1
1957 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1958 def COALESCE(t1.c6, t2.c4) 251 67108860 1 Y 0 39 8
1959 COALESCE(t1.c6, t2.c4)
1960 1
1961 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1962 def COALESCE(t1.c6, t2.c5) 251 4294967292 1 Y 0 39 8
1963 COALESCE(t1.c6, t2.c5)
1964 1
1965 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1966 def COALESCE(t1.c6, t2.c6) 3 11 1 Y 32896 0 63
1967 COALESCE(t1.c6, t2.c6)
1968 1
1969 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1970 def COALESCE(t1.c6, t2.c7) 5 22 1 Y 32896 31 63
1971 COALESCE(t1.c6, t2.c7)
1972 1
1973 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1974 def COALESCE(t1.c6, t2.c8) 246 14 4 Y 32896 2 63
1975 COALESCE(t1.c6, t2.c8)
1976 1.00
1977 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1978 def COALESCE(t1.c6, t2.c9) 253 11 1 Y 0 39 8
1979 COALESCE(t1.c6, t2.c9)
1980 1
1981 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1982 def COALESCE(t1.c6, t2.c10) 253 11 1 Y 0 39 8
1983 COALESCE(t1.c6, t2.c10)
1984 1
1985 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1986 def COALESCE(t1.c6, t2.c11) 253 19 1 Y 0 39 8
1987 COALESCE(t1.c6, t2.c11)
1988 1
1989 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1990 def COALESCE(t1.c6, t2.c12) 253 11 1 Y 0 39 8
1991 COALESCE(t1.c6, t2.c12)
1992 1
1993 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1994 def COALESCE(t1.c7, t2.c0) 253 30 1 Y 0 39 8
1995 COALESCE(t1.c7, t2.c0)
1996 1
1997 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
1998 def COALESCE(t1.c7, t2.c1) 253 30 1 Y 0 39 8
1999 COALESCE(t1.c7, t2.c1)
2000 1
2001 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2002 def COALESCE(t1.c7, t2.c2) 252 1020 1 Y 0 39 8
2003 COALESCE(t1.c7, t2.c2)
2004 1
2005 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2006 def COALESCE(t1.c7, t2.c3) 250 262140 1 Y 0 39 8
2007 COALESCE(t1.c7, t2.c3)
2008 1
2009 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2010 def COALESCE(t1.c7, t2.c4) 251 67108860 1 Y 0 39 8
2011 COALESCE(t1.c7, t2.c4)
2012 1
2013 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2014 def COALESCE(t1.c7, t2.c5) 251 4294967292 1 Y 0 39 8
2015 COALESCE(t1.c7, t2.c5)
2016 1
2017 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2018 def COALESCE(t1.c7, t2.c6) 253 11 1 Y 0 39 8
2019 COALESCE(t1.c7, t2.c6)
2020 1
2021 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2022 def COALESCE(t1.c7, t2.c7) 253 22 1 Y 0 39 8
2023 COALESCE(t1.c7, t2.c7)
2024 1
2025 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2026 def COALESCE(t1.c7, t2.c8) 253 12 1 Y 0 39 8
2027 COALESCE(t1.c7, t2.c8)
2028 1
2029 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2030 def COALESCE(t1.c7, t2.c9) 253 10 1 Y 0 39 8
2031 COALESCE(t1.c7, t2.c9)
2032 1
2033 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2034 def COALESCE(t1.c7, t2.c10) 253 10 1 Y 0 39 8
2035 COALESCE(t1.c7, t2.c10)
2036 1
2037 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2038 def COALESCE(t1.c7, t2.c11) 253 19 1 Y 0 39 8
2039 COALESCE(t1.c7, t2.c11)
2040 1
2041 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2042 def COALESCE(t1.c7, t2.c12) 253 1 1 Y 0 39 8
2043 COALESCE(t1.c7, t2.c12)
2044 1
2045 CALL p2('LEAST(t1.colt1, t2.colt2)');
2046 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2047 def LEAST(t1.c0, t2.c0) 254 30 1 Y 0 39 8
2048 LEAST(t1.c0, t2.c0)
2049 1
2050 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2051 def LEAST(t1.c0, t2.c1) 253 30 1 Y 0 39 8
2052 LEAST(t1.c0, t2.c1)
2053 1
2054 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2055 def LEAST(t1.c0, t2.c2) 252 1020 1 Y 0 39 8
2056 LEAST(t1.c0, t2.c2)
2057 1
2058 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2059 def LEAST(t1.c0, t2.c3) 250 262140 1 Y 0 39 8
2060 LEAST(t1.c0, t2.c3)
2061 1
2062 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2063 def LEAST(t1.c0, t2.c4) 251 67108860 1 Y 0 39 8
2064 LEAST(t1.c0, t2.c4)
2065 1
2066 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2067 def LEAST(t1.c0, t2.c5) 251 4294967292 1 Y 0 39 8
2068 LEAST(t1.c0, t2.c5)
2069 1
2070 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2071 def LEAST(t1.c0, t2.c6) 5 23 1 Y 32896 31 63
2072 LEAST(t1.c0, t2.c6)
2073 1
2074 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2075 def LEAST(t1.c0, t2.c7) 5 23 1 Y 32896 31 63
2076 LEAST(t1.c0, t2.c7)
2077 1
2078 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2079 def LEAST(t1.c0, t2.c8) 5 23 1 Y 32896 31 63
2080 LEAST(t1.c0, t2.c8)
2081 1
2082 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2083 def LEAST(t1.c0, t2.c9) 11 17 15 Y 128 6 63
2084 LEAST(t1.c0, t2.c9)
2085 00:00:01.000000
2086 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2087 def LEAST(t1.c0, t2.c10) 10 10 10 Y 128 0 63
2088 LEAST(t1.c0, t2.c10)
2089 0000-00-00
2090 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2091 def LEAST(t1.c0, t2.c11) 12 26 26 Y 128 6 63
2092 LEAST(t1.c0, t2.c11)
2093 0000-00-00 00:00:00.000000
2094 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2095 def LEAST(t1.c0, t2.c12) 253 30 1 Y 0 39 8
2096 LEAST(t1.c0, t2.c12)
2097 1
2098 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2099 def LEAST(t1.c1, t2.c0) 253 30 1 Y 0 39 8
2100 LEAST(t1.c1, t2.c0)
2101 1
2102 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2103 def LEAST(t1.c1, t2.c1) 253 30 1 Y 0 39 8
2104 LEAST(t1.c1, t2.c1)
2105 1
2106 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2107 def LEAST(t1.c1, t2.c2) 252 1020 1 Y 0 39 8
2108 LEAST(t1.c1, t2.c2)
2109 1
2110 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2111 def LEAST(t1.c1, t2.c3) 250 262140 1 Y 0 39 8
2112 LEAST(t1.c1, t2.c3)
2113 1
2114 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2115 def LEAST(t1.c1, t2.c4) 251 67108860 1 Y 0 39 8
2116 LEAST(t1.c1, t2.c4)
2117 1
2118 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2119 def LEAST(t1.c1, t2.c5) 251 4294967292 1 Y 0 39 8
2120 LEAST(t1.c1, t2.c5)
2121 1
2122 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2123 def LEAST(t1.c1, t2.c6) 5 23 1 Y 32896 31 63
2124 LEAST(t1.c1, t2.c6)
2125 1
2126 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2127 def LEAST(t1.c1, t2.c7) 5 23 1 Y 32896 31 63
2128 LEAST(t1.c1, t2.c7)
2129 1
2130 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2131 def LEAST(t1.c1, t2.c8) 5 23 1 Y 32896 31 63
2132 LEAST(t1.c1, t2.c8)
2133 1
2134 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2135 def LEAST(t1.c1, t2.c9) 11 17 15 Y 128 6 63
2136 LEAST(t1.c1, t2.c9)
2137 00:00:01.000000
2138 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2139 def LEAST(t1.c1, t2.c10) 10 10 10 Y 128 0 63
2140 LEAST(t1.c1, t2.c10)
2141 0000-00-00
2142 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2143 def LEAST(t1.c1, t2.c11) 12 26 26 Y 128 6 63
2144 LEAST(t1.c1, t2.c11)
2145 0000-00-00 00:00:00.000000
2146 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2147 def LEAST(t1.c1, t2.c12) 253 30 1 Y 0 39 8
2148 LEAST(t1.c1, t2.c12)
2149 1
2150 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2151 def LEAST(t1.c2, t2.c0) 252 1020 1 Y 0 39 8
2152 LEAST(t1.c2, t2.c0)
2153 1
2154 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2155 def LEAST(t1.c2, t2.c1) 252 1020 1 Y 0 39 8
2156 LEAST(t1.c2, t2.c1)
2157 1
2158 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2159 def LEAST(t1.c2, t2.c2) 252 1020 1 Y 0 39 8
2160 LEAST(t1.c2, t2.c2)
2161 1
2162 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2163 def LEAST(t1.c2, t2.c3) 250 262140 1 Y 0 39 8
2164 LEAST(t1.c2, t2.c3)
2165 1
2166 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2167 def LEAST(t1.c2, t2.c4) 251 67108860 1 Y 0 39 8
2168 LEAST(t1.c2, t2.c4)
2169 1
2170 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2171 def LEAST(t1.c2, t2.c5) 251 4294967292 1 Y 0 39 8
2172 LEAST(t1.c2, t2.c5)
2173 1
2174 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2175 def LEAST(t1.c2, t2.c6) 5 23 1 Y 32896 31 63
2176 LEAST(t1.c2, t2.c6)
2177 1
2178 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2179 def LEAST(t1.c2, t2.c7) 5 23 1 Y 32896 31 63
2180 LEAST(t1.c2, t2.c7)
2181 1
2182 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2183 def LEAST(t1.c2, t2.c8) 5 23 1 Y 32896 31 63
2184 LEAST(t1.c2, t2.c8)
2185 1
2186 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2187 def LEAST(t1.c2, t2.c9) 11 17 15 Y 128 6 63
2188 LEAST(t1.c2, t2.c9)
2189 00:00:01.000000
2190 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2191 def LEAST(t1.c2, t2.c10) 10 10 10 Y 128 0 63
2192 LEAST(t1.c2, t2.c10)
2193 0000-00-00
2194 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2195 def LEAST(t1.c2, t2.c11) 12 26 26 Y 128 6 63
2196 LEAST(t1.c2, t2.c11)
2197 0000-00-00 00:00:00.000000
2198 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2199 def LEAST(t1.c2, t2.c12) 252 1020 1 Y 0 39 8
2200 LEAST(t1.c2, t2.c12)
2201 1
2202 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2203 def LEAST(t1.c3, t2.c0) 250 262140 1 Y 0 39 8
2204 LEAST(t1.c3, t2.c0)
2205 1
2206 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2207 def LEAST(t1.c3, t2.c1) 250 262140 1 Y 0 39 8
2208 LEAST(t1.c3, t2.c1)
2209 1
2210 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2211 def LEAST(t1.c3, t2.c2) 250 262140 1 Y 0 39 8
2212 LEAST(t1.c3, t2.c2)
2213 1
2214 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2215 def LEAST(t1.c3, t2.c3) 250 262140 1 Y 0 39 8
2216 LEAST(t1.c3, t2.c3)
2217 1
2218 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2219 def LEAST(t1.c3, t2.c4) 251 67108860 1 Y 0 39 8
2220 LEAST(t1.c3, t2.c4)
2221 1
2222 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2223 def LEAST(t1.c3, t2.c5) 251 4294967292 1 Y 0 39 8
2224 LEAST(t1.c3, t2.c5)
2225 1
2226 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2227 def LEAST(t1.c3, t2.c6) 5 23 1 Y 32896 31 63
2228 LEAST(t1.c3, t2.c6)
2229 1
2230 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2231 def LEAST(t1.c3, t2.c7) 5 23 1 Y 32896 31 63
2232 LEAST(t1.c3, t2.c7)
2233 1
2234 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2235 def LEAST(t1.c3, t2.c8) 5 23 1 Y 32896 31 63
2236 LEAST(t1.c3, t2.c8)
2237 1
2238 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2239 def LEAST(t1.c3, t2.c9) 11 17 15 Y 128 6 63
2240 LEAST(t1.c3, t2.c9)
2241 00:00:01.000000
2242 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2243 def LEAST(t1.c3, t2.c10) 10 10 10 Y 128 0 63
2244 LEAST(t1.c3, t2.c10)
2245 0000-00-00
2246 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2247 def LEAST(t1.c3, t2.c11) 12 26 26 Y 128 6 63
2248 LEAST(t1.c3, t2.c11)
2249 0000-00-00 00:00:00.000000
2250 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2251 def LEAST(t1.c3, t2.c12) 250 262140 1 Y 0 39 8
2252 LEAST(t1.c3, t2.c12)
2253 1
2254 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2255 def LEAST(t1.c4, t2.c0) 251 67108860 1 Y 0 39 8
2256 LEAST(t1.c4, t2.c0)
2257 1
2258 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2259 def LEAST(t1.c4, t2.c1) 251 67108860 1 Y 0 39 8
2260 LEAST(t1.c4, t2.c1)
2261 1
2262 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2263 def LEAST(t1.c4, t2.c2) 251 67108860 1 Y 0 39 8
2264 LEAST(t1.c4, t2.c2)
2265 1
2266 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2267 def LEAST(t1.c4, t2.c3) 251 67108860 1 Y 0 39 8
2268 LEAST(t1.c4, t2.c3)
2269 1
2270 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2271 def LEAST(t1.c4, t2.c4) 251 67108860 1 Y 0 39 8
2272 LEAST(t1.c4, t2.c4)
2273 1
2274 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2275 def LEAST(t1.c4, t2.c5) 251 4294967292 1 Y 0 39 8
2276 LEAST(t1.c4, t2.c5)
2277 1
2278 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2279 def LEAST(t1.c4, t2.c6) 5 23 1 Y 32896 31 63
2280 LEAST(t1.c4, t2.c6)
2281 1
2282 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2283 def LEAST(t1.c4, t2.c7) 5 23 1 Y 32896 31 63
2284 LEAST(t1.c4, t2.c7)
2285 1
2286 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2287 def LEAST(t1.c4, t2.c8) 5 23 1 Y 32896 31 63
2288 LEAST(t1.c4, t2.c8)
2289 1
2290 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2291 def LEAST(t1.c4, t2.c9) 11 17 15 Y 128 6 63
2292 LEAST(t1.c4, t2.c9)
2293 00:00:01.000000
2294 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2295 def LEAST(t1.c4, t2.c10) 10 10 10 Y 128 0 63
2296 LEAST(t1.c4, t2.c10)
2297 0000-00-00
2298 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2299 def LEAST(t1.c4, t2.c11) 12 26 26 Y 128 6 63
2300 LEAST(t1.c4, t2.c11)
2301 0000-00-00 00:00:00.000000
2302 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2303 def LEAST(t1.c4, t2.c12) 251 67108860 1 Y 0 39 8
2304 LEAST(t1.c4, t2.c12)
2305 1
2306 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2307 def LEAST(t1.c5, t2.c0) 251 4294967292 1 Y 0 39 8
2308 LEAST(t1.c5, t2.c0)
2309 1
2310 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2311 def LEAST(t1.c5, t2.c1) 251 4294967292 1 Y 0 39 8
2312 LEAST(t1.c5, t2.c1)
2313 1
2314 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2315 def LEAST(t1.c5, t2.c2) 251 4294967292 1 Y 0 39 8
2316 LEAST(t1.c5, t2.c2)
2317 1
2318 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2319 def LEAST(t1.c5, t2.c3) 251 4294967292 1 Y 0 39 8
2320 LEAST(t1.c5, t2.c3)
2321 1
2322 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2323 def LEAST(t1.c5, t2.c4) 251 4294967292 1 Y 0 39 8
2324 LEAST(t1.c5, t2.c4)
2325 1
2326 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2327 def LEAST(t1.c5, t2.c5) 251 4294967292 1 Y 0 39 8
2328 LEAST(t1.c5, t2.c5)
2329 1
2330 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2331 def LEAST(t1.c5, t2.c6) 5 23 1 Y 32896 31 63
2332 LEAST(t1.c5, t2.c6)
2333 1
2334 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2335 def LEAST(t1.c5, t2.c7) 5 23 1 Y 32896 31 63
2336 LEAST(t1.c5, t2.c7)
2337 1
2338 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2339 def LEAST(t1.c5, t2.c8) 5 23 1 Y 32896 31 63
2340 LEAST(t1.c5, t2.c8)
2341 1
2342 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2343 def LEAST(t1.c5, t2.c9) 11 17 15 Y 128 6 63
2344 LEAST(t1.c5, t2.c9)
2345 00:00:01.000000
2346 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2347 def LEAST(t1.c5, t2.c10) 10 10 10 Y 128 0 63
2348 LEAST(t1.c5, t2.c10)
2349 0000-00-00
2350 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2351 def LEAST(t1.c5, t2.c11) 12 26 26 Y 128 6 63
2352 LEAST(t1.c5, t2.c11)
2353 0000-00-00 00:00:00.000000
2354 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2355 def LEAST(t1.c5, t2.c12) 251 4294967292 1 Y 0 39 8
2356 LEAST(t1.c5, t2.c12)
2357 1
2358 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2359 def LEAST(t1.c6, t2.c0) 5 23 1 Y 32896 31 63
2360 LEAST(t1.c6, t2.c0)
2361 1
2362 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2363 def LEAST(t1.c6, t2.c1) 5 23 1 Y 32896 31 63
2364 LEAST(t1.c6, t2.c1)
2365 1
2366 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2367 def LEAST(t1.c6, t2.c2) 5 23 1 Y 32896 31 63
2368 LEAST(t1.c6, t2.c2)
2369 1
2370 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2371 def LEAST(t1.c6, t2.c3) 5 23 1 Y 32896 31 63
2372 LEAST(t1.c6, t2.c3)
2373 1
2374 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2375 def LEAST(t1.c6, t2.c4) 5 23 1 Y 32896 31 63
2376 LEAST(t1.c6, t2.c4)
2377 1
2378 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2379 def LEAST(t1.c6, t2.c5) 5 23 1 Y 32896 31 63
2380 LEAST(t1.c6, t2.c5)
2381 1
2382 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2383 def LEAST(t1.c6, t2.c6) 3 11 1 Y 32896 0 63
2384 LEAST(t1.c6, t2.c6)
2385 1
2386 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2387 def LEAST(t1.c6, t2.c7) 5 23 1 Y 32896 31 63
2388 LEAST(t1.c6, t2.c7)
2389 1
2390 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2391 def LEAST(t1.c6, t2.c8) 246 14 4 Y 32896 2 63
2392 LEAST(t1.c6, t2.c8)
2393 1.00
2394 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2395 def LEAST(t1.c6, t2.c9) 11 10 8 Y 128 0 63
2396 LEAST(t1.c6, t2.c9)
2397 00:00:01
2398 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2399 def LEAST(t1.c6, t2.c10) 10 10 10 Y 128 0 63
2400 LEAST(t1.c6, t2.c10)
2401 0000-00-00
2402 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2403 def LEAST(t1.c6, t2.c11) 12 19 19 Y 128 0 63
2404 LEAST(t1.c6, t2.c11)
2405 0000-00-00 00:00:00
2406 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2407 def LEAST(t1.c6, t2.c12) 5 17 1 Y 32896 0 63
2408 LEAST(t1.c6, t2.c12)
2409 1
2410 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2411 def LEAST(t1.c7, t2.c0) 253 30 1 Y 0 39 8
2412 LEAST(t1.c7, t2.c0)
2413 1
2414 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2415 def LEAST(t1.c7, t2.c1) 253 30 1 Y 0 39 8
2416 LEAST(t1.c7, t2.c1)
2417 1
2418 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2419 def LEAST(t1.c7, t2.c2) 252 1020 1 Y 0 39 8
2420 LEAST(t1.c7, t2.c2)
2421 1
2422 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2423 def LEAST(t1.c7, t2.c3) 250 262140 1 Y 0 39 8
2424 LEAST(t1.c7, t2.c3)
2425 1
2426 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2427 def LEAST(t1.c7, t2.c4) 251 67108860 1 Y 0 39 8
2428 LEAST(t1.c7, t2.c4)
2429 1
2430 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2431 def LEAST(t1.c7, t2.c5) 251 4294967292 1 Y 0 39 8
2432 LEAST(t1.c7, t2.c5)
2433 1
2434 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2435 def LEAST(t1.c7, t2.c6) 5 17 1 Y 32896 0 63
2436 LEAST(t1.c7, t2.c6)
2437 1
2438 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2439 def LEAST(t1.c7, t2.c7) 5 23 1 Y 32896 31 63
2440 LEAST(t1.c7, t2.c7)
2441 1
2442 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2443 def LEAST(t1.c7, t2.c8) 5 19 4 Y 32896 2 63
2444 LEAST(t1.c7, t2.c8)
2445 1.00
2446 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2447 def LEAST(t1.c7, t2.c9) 11 10 8 Y 128 0 63
2448 LEAST(t1.c7, t2.c9)
2449 00:00:01
2450 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2451 def LEAST(t1.c7, t2.c10) 10 10 10 Y 128 0 63
2452 LEAST(t1.c7, t2.c10)
2453 0000-00-00
2454 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2455 def LEAST(t1.c7, t2.c11) 12 19 19 Y 128 0 63
2456 LEAST(t1.c7, t2.c11)
2457 0000-00-00 00:00:00
2458 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2459 def LEAST(t1.c7, t2.c12) 253 1 1 Y 0 39 8
2460 LEAST(t1.c7, t2.c12)
2461 1
2462 CALL p2('t1.colt1+t2.colt2');
2463 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2464 def t1.c0+t2.c0 5 23 1 Y 32896 31 63
2465 t1.c0+t2.c0
2466 2
2467 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2468 def t1.c0+t2.c1 5 23 1 Y 32896 31 63
2469 t1.c0+t2.c1
2470 2
2471 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2472 def t1.c0+t2.c2 5 23 1 Y 32896 31 63
2473 t1.c0+t2.c2
2474 2
2475 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2476 def t1.c0+t2.c3 5 23 1 Y 32896 31 63
2477 t1.c0+t2.c3
2478 2
2479 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2480 def t1.c0+t2.c4 5 23 1 Y 32896 31 63
2481 t1.c0+t2.c4
2482 2
2483 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2484 def t1.c0+t2.c5 5 23 1 Y 32896 31 63
2485 t1.c0+t2.c5
2486 2
2487 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2488 def t1.c0+t2.c6 5 23 1 Y 32896 31 63
2489 t1.c0+t2.c6
2490 2
2491 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2492 def t1.c0+t2.c7 5 23 1 Y 32896 31 63
2493 t1.c0+t2.c7
2494 2
2495 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2496 def t1.c0+t2.c8 5 23 4 Y 32896 31 63
2497 t1.c0+t2.c8
2498 2.23
2499 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2500 def t1.c0+t2.c9 5 23 6 Y 32896 31 63
2501 t1.c0+t2.c9
2502 102031
2503 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2504 def t1.c0+t2.c10 5 23 8 Y 32896 31 63
2505 t1.c0+t2.c10
2506 20010102
2507 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2508 def t1.c0+t2.c11 5 23 14 Y 32896 31 63
2509 t1.c0+t2.c11
2510 20010101102031
2511 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2512 def t1.c0+t2.c12 5 23 1 Y 32896 31 63
2513 t1.c0+t2.c12
2514 2
2515 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2516 def t1.c1+t2.c0 5 23 1 Y 32896 31 63
2517 t1.c1+t2.c0
2518 2
2519 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2520 def t1.c1+t2.c1 5 23 1 Y 32896 31 63
2521 t1.c1+t2.c1
2522 2
2523 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2524 def t1.c1+t2.c2 5 23 1 Y 32896 31 63
2525 t1.c1+t2.c2
2526 2
2527 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2528 def t1.c1+t2.c3 5 23 1 Y 32896 31 63
2529 t1.c1+t2.c3
2530 2
2531 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2532 def t1.c1+t2.c4 5 23 1 Y 32896 31 63
2533 t1.c1+t2.c4
2534 2
2535 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2536 def t1.c1+t2.c5 5 23 1 Y 32896 31 63
2537 t1.c1+t2.c5
2538 2
2539 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2540 def t1.c1+t2.c6 5 23 1 Y 32896 31 63
2541 t1.c1+t2.c6
2542 2
2543 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2544 def t1.c1+t2.c7 5 23 1 Y 32896 31 63
2545 t1.c1+t2.c7
2546 2
2547 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2548 def t1.c1+t2.c8 5 23 4 Y 32896 31 63
2549 t1.c1+t2.c8
2550 2.23
2551 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2552 def t1.c1+t2.c9 5 23 6 Y 32896 31 63
2553 t1.c1+t2.c9
2554 102031
2555 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2556 def t1.c1+t2.c10 5 23 8 Y 32896 31 63
2557 t1.c1+t2.c10
2558 20010102
2559 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2560 def t1.c1+t2.c11 5 23 14 Y 32896 31 63
2561 t1.c1+t2.c11
2562 20010101102031
2563 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2564 def t1.c1+t2.c12 5 23 1 Y 32896 31 63
2565 t1.c1+t2.c12
2566 2
2567 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2568 def t1.c2+t2.c0 5 23 1 Y 32896 31 63
2569 t1.c2+t2.c0
2570 2
2571 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2572 def t1.c2+t2.c1 5 23 1 Y 32896 31 63
2573 t1.c2+t2.c1
2574 2
2575 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2576 def t1.c2+t2.c2 5 23 1 Y 32896 31 63
2577 t1.c2+t2.c2
2578 2
2579 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2580 def t1.c2+t2.c3 5 23 1 Y 32896 31 63
2581 t1.c2+t2.c3
2582 2
2583 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2584 def t1.c2+t2.c4 5 23 1 Y 32896 31 63
2585 t1.c2+t2.c4
2586 2
2587 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2588 def t1.c2+t2.c5 5 23 1 Y 32896 31 63
2589 t1.c2+t2.c5
2590 2
2591 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2592 def t1.c2+t2.c6 5 23 1 Y 32896 31 63
2593 t1.c2+t2.c6
2594 2
2595 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2596 def t1.c2+t2.c7 5 23 1 Y 32896 31 63
2597 t1.c2+t2.c7
2598 2
2599 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2600 def t1.c2+t2.c8 5 23 4 Y 32896 31 63
2601 t1.c2+t2.c8
2602 2.23
2603 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2604 def t1.c2+t2.c9 5 23 6 Y 32896 31 63
2605 t1.c2+t2.c9
2606 102031
2607 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2608 def t1.c2+t2.c10 5 23 8 Y 32896 31 63
2609 t1.c2+t2.c10
2610 20010102
2611 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2612 def t1.c2+t2.c11 5 23 14 Y 32896 31 63
2613 t1.c2+t2.c11
2614 20010101102031
2615 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2616 def t1.c2+t2.c12 5 23 1 Y 32896 31 63
2617 t1.c2+t2.c12
2618 2
2619 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2620 def t1.c3+t2.c0 5 23 1 Y 32896 31 63
2621 t1.c3+t2.c0
2622 2
2623 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2624 def t1.c3+t2.c1 5 23 1 Y 32896 31 63
2625 t1.c3+t2.c1
2626 2
2627 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2628 def t1.c3+t2.c2 5 23 1 Y 32896 31 63
2629 t1.c3+t2.c2
2630 2
2631 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2632 def t1.c3+t2.c3 5 23 1 Y 32896 31 63
2633 t1.c3+t2.c3
2634 2
2635 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2636 def t1.c3+t2.c4 5 23 1 Y 32896 31 63
2637 t1.c3+t2.c4
2638 2
2639 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2640 def t1.c3+t2.c5 5 23 1 Y 32896 31 63
2641 t1.c3+t2.c5
2642 2
2643 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2644 def t1.c3+t2.c6 5 23 1 Y 32896 31 63
2645 t1.c3+t2.c6
2646 2
2647 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2648 def t1.c3+t2.c7 5 23 1 Y 32896 31 63
2649 t1.c3+t2.c7
2650 2
2651 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2652 def t1.c3+t2.c8 5 23 4 Y 32896 31 63
2653 t1.c3+t2.c8
2654 2.23
2655 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2656 def t1.c3+t2.c9 5 23 6 Y 32896 31 63
2657 t1.c3+t2.c9
2658 102031
2659 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2660 def t1.c3+t2.c10 5 23 8 Y 32896 31 63
2661 t1.c3+t2.c10
2662 20010102
2663 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2664 def t1.c3+t2.c11 5 23 14 Y 32896 31 63
2665 t1.c3+t2.c11
2666 20010101102031
2667 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2668 def t1.c3+t2.c12 5 23 1 Y 32896 31 63
2669 t1.c3+t2.c12
2670 2
2671 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2672 def t1.c4+t2.c0 5 23 1 Y 32896 31 63
2673 t1.c4+t2.c0
2674 2
2675 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2676 def t1.c4+t2.c1 5 23 1 Y 32896 31 63
2677 t1.c4+t2.c1
2678 2
2679 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2680 def t1.c4+t2.c2 5 23 1 Y 32896 31 63
2681 t1.c4+t2.c2
2682 2
2683 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2684 def t1.c4+t2.c3 5 23 1 Y 32896 31 63
2685 t1.c4+t2.c3
2686 2
2687 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2688 def t1.c4+t2.c4 5 23 1 Y 32896 31 63
2689 t1.c4+t2.c4
2690 2
2691 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2692 def t1.c4+t2.c5 5 23 1 Y 32896 31 63
2693 t1.c4+t2.c5
2694 2
2695 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2696 def t1.c4+t2.c6 5 23 1 Y 32896 31 63
2697 t1.c4+t2.c6
2698 2
2699 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2700 def t1.c4+t2.c7 5 23 1 Y 32896 31 63
2701 t1.c4+t2.c7
2702 2
2703 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2704 def t1.c4+t2.c8 5 23 4 Y 32896 31 63
2705 t1.c4+t2.c8
2706 2.23
2707 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2708 def t1.c4+t2.c9 5 23 6 Y 32896 31 63
2709 t1.c4+t2.c9
2710 102031
2711 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2712 def t1.c4+t2.c10 5 23 8 Y 32896 31 63
2713 t1.c4+t2.c10
2714 20010102
2715 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2716 def t1.c4+t2.c11 5 23 14 Y 32896 31 63
2717 t1.c4+t2.c11
2718 20010101102031
2719 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2720 def t1.c4+t2.c12 5 23 1 Y 32896 31 63
2721 t1.c4+t2.c12
2722 2
2723 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2724 def t1.c5+t2.c0 5 23 1 Y 32896 31 63
2725 t1.c5+t2.c0
2726 2
2727 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2728 def t1.c5+t2.c1 5 23 1 Y 32896 31 63
2729 t1.c5+t2.c1
2730 2
2731 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2732 def t1.c5+t2.c2 5 23 1 Y 32896 31 63
2733 t1.c5+t2.c2
2734 2
2735 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2736 def t1.c5+t2.c3 5 23 1 Y 32896 31 63
2737 t1.c5+t2.c3
2738 2
2739 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2740 def t1.c5+t2.c4 5 23 1 Y 32896 31 63
2741 t1.c5+t2.c4
2742 2
2743 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2744 def t1.c5+t2.c5 5 23 1 Y 32896 31 63
2745 t1.c5+t2.c5
2746 2
2747 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2748 def t1.c5+t2.c6 5 23 1 Y 32896 31 63
2749 t1.c5+t2.c6
2750 2
2751 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2752 def t1.c5+t2.c7 5 23 1 Y 32896 31 63
2753 t1.c5+t2.c7
2754 2
2755 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2756 def t1.c5+t2.c8 5 23 4 Y 32896 31 63
2757 t1.c5+t2.c8
2758 2.23
2759 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2760 def t1.c5+t2.c9 5 23 6 Y 32896 31 63
2761 t1.c5+t2.c9
2762 102031
2763 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2764 def t1.c5+t2.c10 5 23 8 Y 32896 31 63
2765 t1.c5+t2.c10
2766 20010102
2767 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2768 def t1.c5+t2.c11 5 23 14 Y 32896 31 63
2769 t1.c5+t2.c11
2770 20010101102031
2771 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2772 def t1.c5+t2.c12 5 23 1 Y 32896 31 63
2773 t1.c5+t2.c12
2774 2
2775 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2776 def t1.c6+t2.c0 5 23 1 Y 32896 31 63
2777 t1.c6+t2.c0
2778 2
2779 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2780 def t1.c6+t2.c1 5 23 1 Y 32896 31 63
2781 t1.c6+t2.c1
2782 2
2783 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2784 def t1.c6+t2.c2 5 23 1 Y 32896 31 63
2785 t1.c6+t2.c2
2786 2
2787 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2788 def t1.c6+t2.c3 5 23 1 Y 32896 31 63
2789 t1.c6+t2.c3
2790 2
2791 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2792 def t1.c6+t2.c4 5 23 1 Y 32896 31 63
2793 t1.c6+t2.c4
2794 2
2795 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2796 def t1.c6+t2.c5 5 23 1 Y 32896 31 63
2797 t1.c6+t2.c5
2798 2
2799 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2800 def t1.c6+t2.c6 8 12 1 Y 32896 0 63
2801 t1.c6+t2.c6
2802 2
2803 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2804 def t1.c6+t2.c7 5 23 1 Y 32896 31 63
2805 t1.c6+t2.c7
2806 2
2807 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2808 def t1.c6+t2.c8 246 15 4 Y 32896 2 63
2809 t1.c6+t2.c8
2810 2.23
2811 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2812 def t1.c6+t2.c9 8 12 6 Y 32896 0 63
2813 t1.c6+t2.c9
2814 102031
2815 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2816 def t1.c6+t2.c10 8 12 8 Y 32896 0 63
2817 t1.c6+t2.c10
2818 20010102
2819 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2820 def t1.c6+t2.c11 8 16 14 Y 32896 0 63
2821 t1.c6+t2.c11
2822 20010101102031
2823 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2824 def t1.c6+t2.c12 8 12 1 Y 32896 0 63
2825 t1.c6+t2.c12
2826 2
2827 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2828 def t1.c7+t2.c0 5 23 1 Y 32896 31 63
2829 t1.c7+t2.c0
2830 2
2831 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2832 def t1.c7+t2.c1 5 23 1 Y 32896 31 63
2833 t1.c7+t2.c1
2834 2
2835 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2836 def t1.c7+t2.c2 5 23 1 Y 32896 31 63
2837 t1.c7+t2.c2
2838 2
2839 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2840 def t1.c7+t2.c3 5 23 1 Y 32896 31 63
2841 t1.c7+t2.c3
2842 2
2843 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2844 def t1.c7+t2.c4 5 23 1 Y 32896 31 63
2845 t1.c7+t2.c4
2846 2
2847 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2848 def t1.c7+t2.c5 5 23 1 Y 32896 31 63
2849 t1.c7+t2.c5
2850 2
2851 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2852 def t1.c7+t2.c6 8 12 1 Y 32896 0 63
2853 t1.c7+t2.c6
2854 2
2855 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2856 def t1.c7+t2.c7 5 23 1 Y 32896 31 63
2857 t1.c7+t2.c7
2858 2
2859 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2860 def t1.c7+t2.c8 246 13 4 Y 32896 2 63
2861 t1.c7+t2.c8
2862 2.23
2863 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2864 def t1.c7+t2.c9 3 9 6 Y 32896 0 63
2865 t1.c7+t2.c9
2866 102031
2867 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2868 def t1.c7+t2.c10 8 10 8 Y 32896 0 63
2869 t1.c7+t2.c10
2870 20010102
2871 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2872 def t1.c7+t2.c11 8 16 14 Y 32896 0 63
2873 t1.c7+t2.c11
2874 20010101102031
2875 Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
2876 def t1.c7+t2.c12 3 3 1 Y 32896 0 63
2877 t1.c7+t2.c12
2878 2
2879 DROP PROCEDURE p1;
2880 DROP PROCEDURE p2;
2881 DROP TABLE t1, t1c, t2;
2882 #
2883 # MDEV-30646 View created via JSON_ARRAYAGG returns incorrect json object
2884 #
2885 CREATE VIEW v1 AS SELECT JSON_OBJECT('plugin','unix_socket') as v1_json;
2886 SELECT JSON_ARRAYAGG(v1_json) FROM v1;
2887 JSON_ARRAYAGG(v1_json)
2888 [{"plugin": "unix_socket"}]
2889 DROP VIEW v1;
2890 #
2891 # End of 10.5 tests
2892 #