Debian Codegraph @

mysql-test/suite/compat/oracle/r/func_qualified.result

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