259
259
ERROR 42000: Incorrect parameter count in the call to native function 'atan'
260
260
select atan2(1, 2, 3);
261
ERROR 42000: Incorrect parameter count in the call to native function 'atan2'
261
ERROR 42000: Incorrect parameter count in the call to native function 'atan'
263
263
ERROR 42000: Incorrect parameter count in the call to native function 'concat'
264
264
select concat("foo");
324
324
select abs(3 AS three);
325
ERROR 42000: Incorrect parameters in the call to native function 'abs'
326
327
select abs(3 three);
327
ERROR 42000: Incorrect parameters in the call to native function 'abs'
328
330
select abs(3 AS "three");
329
ERROR 42000: Incorrect parameters in the call to native function 'abs'
330
333
select abs(3 "three");
331
ERROR 42000: Incorrect parameters in the call to native function 'abs'
333
337
set @foobar="foobar";
334
338
select instr("foobar", "bar");
393
397
select atan(10 AS p1);
394
ERROR 42000: Incorrect parameters in the call to native function 'atan'
395
400
select atan(10 p1);
396
ERROR 42000: Incorrect parameters in the call to native function 'atan'
397
403
select atan(10 AS "p1");
398
ERROR 42000: Incorrect parameters in the call to native function 'atan'
399
406
select atan(10 "p1");
400
ERROR 42000: Incorrect parameters in the call to native function 'atan'
401
409
select atan(10, 20);
403
411
0.463647609000806
404
412
select atan(10 AS p1, 20);
405
ERROR 42000: Incorrect parameters in the call to native function 'atan'
406
415
select atan(10 p1, 20);
407
ERROR 42000: Incorrect parameters in the call to native function 'atan'
408
418
select atan(10 AS "p1", 20);
409
ERROR 42000: Incorrect parameters in the call to native function 'atan'
410
421
select atan(10 "p1", 20);
411
ERROR 42000: Incorrect parameters in the call to native function 'atan'
412
424
select atan(10, 20 AS p2);
413
ERROR 42000: Incorrect parameters in the call to native function 'atan'
414
427
select atan(10, 20 p2);
415
ERROR 42000: Incorrect parameters in the call to native function 'atan'
416
430
select atan(10, 20 AS "p2");
417
ERROR 42000: Incorrect parameters in the call to native function 'atan'
418
433
select atan(10, 20 "p2");
419
ERROR 42000: Incorrect parameters in the call to native function 'atan'
420
436
select atan(10 AS p1, 20 AS p2);
421
ERROR 42000: Incorrect parameters in the call to native function 'atan'
437
atan(10 AS p1, 20 AS p2)
422
439
DROP TABLE IF EXISTS t1;
423
440
SELECT "1997-12-31 23:59:59" + INTERVAL 1 SECOND;
424
441
"1997-12-31 23:59:59" + INTERVAL 1 SECOND