~drizzle-trunk/drizzle/development

create table ADDDATE(a int);

drop table ADDDATE;

create table ADDDATE (a int);

drop table ADDDATE;

create table CAST(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'CAST(a int)' at line 1

create table CAST (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'CAST (a int)' at line 1

create table COUNT(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'COUNT(a int)' at line 1

create table COUNT (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'COUNT (a int)' at line 1

create table CURDATE(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'CURDATE(a int)' at line 1

create table CURDATE (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'CURDATE (a int)' at line 1

create table DATE_ADD(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'DATE_ADD(a int)' at line 1

create table DATE_ADD (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'DATE_ADD (a int)' at line 1

create table DATE_SUB(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'DATE_SUB(a int)' at line 1

create table DATE_SUB (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'DATE_SUB (a int)' at line 1

create table EXTRACT(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'EXTRACT(a int)' at line 1

create table EXTRACT (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'EXTRACT (a int)' at line 1

create table GROUP_CONCAT(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'GROUP_CONCAT(a int)' at line 1

create table GROUP_CONCAT (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'GROUP_CONCAT (a int)' at line 1

create table GROUP_UNIQUE_USERS(a int);

drop table GROUP_UNIQUE_USERS;

create table GROUP_UNIQUE_USERS (a int);

drop table GROUP_UNIQUE_USERS;

create table MAX(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MAX(a int)' at line 1

create table MAX (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MAX (a int)' at line 1

create table MID(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MID(a int)' at line 1

create table MID (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MID (a int)' at line 1

create table MIN(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MIN(a int)' at line 1

create table MIN (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MIN (a int)' at line 1

create table NOW(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'NOW(a int)' at line 1

create table NOW (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'NOW (a int)' at line 1

create table POSITION(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'POSITION(a int)' at line 1

create table POSITION (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'POSITION (a int)' at line 1

create table SESSION_USER(a int);

drop table SESSION_USER;

create table SESSION_USER (a int);

drop table SESSION_USER;

create table STD(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STD(a int)' at line 1

create table STD (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STD (a int)' at line 1

create table STDDEV(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV(a int)' at line 1

create table STDDEV (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV (a int)' at line 1

create table STDDEV_POP(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV_POP(a int)' at line 1

create table STDDEV_POP (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV_POP (a int)' at line 1

create table STDDEV_SAMP(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV_SAMP(a int)' at line 1

create table STDDEV_SAMP (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV_SAMP (a int)' at line 1

create table SUBDATE(a int);

drop table SUBDATE;

create table SUBDATE (a int);

drop table SUBDATE;

create table SUBSTR(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SUBSTR(a int)' at line 1

create table SUBSTR (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SUBSTR (a int)' at line 1

create table SUM(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SUM(a int)' at line 1

create table SUM (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SUM (a int)' at line 1

create table SYSDATE(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SYSDATE(a int)' at line 1

create table SYSDATE (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SYSDATE (a int)' at line 1

create table SYSTEM_USER(a int);

drop table SYSTEM_USER;

create table SYSTEM_USER (a int);

drop table SYSTEM_USER;

create table TRIM(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'TRIM(a int)' at line 1

create table TRIM (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'TRIM (a int)' at line 1

create table UNIQUE_USERS(a int);

drop table UNIQUE_USERS;

create table UNIQUE_USERS (a int);

drop table UNIQUE_USERS;

create table VARIANCE(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VARIANCE(a int)' at line 1

create table VARIANCE (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VARIANCE (a int)' at line 1

create table VAR_POP(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VAR_POP(a int)' at line 1

create table VAR_POP (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VAR_POP (a int)' at line 1

create table VAR_SAMP(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VAR_SAMP(a int)' at line 1

create table VAR_SAMP (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VAR_SAMP (a int)' at line 1

create table ADDDATE(a int);

drop table ADDDATE;

create table ADDDATE (a int);

drop table ADDDATE;

create table CAST(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'CAST(a int)' at line 1

create table CAST (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'CAST (a int)' at line 1

create table COUNT(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'COUNT(a int)' at line 1

create table COUNT (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'COUNT (a int)' at line 1

create table CURDATE(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'CURDATE(a int)' at line 1

create table CURDATE (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'CURDATE (a int)' at line 1

create table DATE_ADD(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'DATE_ADD(a int)' at line 1

create table DATE_ADD (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'DATE_ADD (a int)' at line 1

create table DATE_SUB(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'DATE_SUB(a int)' at line 1

create table DATE_SUB (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'DATE_SUB (a int)' at line 1

create table EXTRACT(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'EXTRACT(a int)' at line 1

create table EXTRACT (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'EXTRACT (a int)' at line 1

create table GROUP_CONCAT(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'GROUP_CONCAT(a int)' at line 1

create table GROUP_CONCAT (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'GROUP_CONCAT (a int)' at line 1

create table GROUP_UNIQUE_USERS(a int);

drop table GROUP_UNIQUE_USERS;

create table GROUP_UNIQUE_USERS (a int);

drop table GROUP_UNIQUE_USERS;

create table MAX(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MAX(a int)' at line 1

create table MAX (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MAX (a int)' at line 1

create table MID(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MID(a int)' at line 1

create table MID (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MID (a int)' at line 1

create table MIN(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MIN(a int)' at line 1

create table MIN (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'MIN (a int)' at line 1

create table NOW(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'NOW(a int)' at line 1

create table NOW (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'NOW (a int)' at line 1

create table POSITION(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'POSITION(a int)' at line 1

create table POSITION (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'POSITION (a int)' at line 1

create table SESSION_USER(a int);

drop table SESSION_USER;

create table SESSION_USER (a int);

drop table SESSION_USER;

create table STD(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STD(a int)' at line 1

create table STD (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STD (a int)' at line 1

create table STDDEV(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV(a int)' at line 1

create table STDDEV (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV (a int)' at line 1

create table STDDEV_POP(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV_POP(a int)' at line 1

create table STDDEV_POP (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV_POP (a int)' at line 1

create table STDDEV_SAMP(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV_SAMP(a int)' at line 1

create table STDDEV_SAMP (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'STDDEV_SAMP (a int)' at line 1

create table SUBDATE(a int);

drop table SUBDATE;

create table SUBDATE (a int);

drop table SUBDATE;

create table SUBSTR(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SUBSTR(a int)' at line 1

create table SUBSTR (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SUBSTR (a int)' at line 1

create table SUBSTRING(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SUBSTRING(a int)' at line 1

create table SUBSTRING (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SUBSTRING (a int)' at line 1

create table SUM(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SUM(a int)' at line 1

create table SUM (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SUM (a int)' at line 1

create table SYSDATE(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SYSDATE(a int)' at line 1

create table SYSDATE (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'SYSDATE (a int)' at line 1

create table SYSTEM_USER(a int);

drop table SYSTEM_USER;

create table SYSTEM_USER (a int);

drop table SYSTEM_USER;

create table TRIM(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'TRIM(a int)' at line 1

create table TRIM (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'TRIM (a int)' at line 1

create table UNIQUE_USERS(a int);

drop table UNIQUE_USERS;

create table UNIQUE_USERS (a int);

drop table UNIQUE_USERS;

create table VARIANCE(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VARIANCE(a int)' at line 1

create table VARIANCE (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VARIANCE (a int)' at line 1

create table VAR_POP(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VAR_POP(a int)' at line 1

create table VAR_POP (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VAR_POP (a int)' at line 1

create table VAR_SAMP(a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VAR_SAMP(a int)' at line 1

create table VAR_SAMP (a int);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'VAR_SAMP (a int)' at line 1

DROP TABLE IF EXISTS table_25930_a;

DROP TABLE IF EXISTS table_25930_b;

CREATE TABLE table_25930_a ( "blah" INT );

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '"blah" INT )' at line 1

CREATE TABLE table_25930_a ( blah INT );

CREATE TABLE table_25930_b SELECT "blah" - 1 FROM table_25930_a;

desc table_25930_b;

Field	Type	Null	Default	Default_is_NULL	On_Update

"blah" - 1	DOUBLE	NO		NO	

DROP TABLE table_25930_a;

DROP TABLE table_25930_b;

select pi(3.14);

ERROR 42000: Incorrect parameter count in the call to native function 'pi'

select tan();

ERROR 42000: Incorrect parameter count in the call to native function 'tan'

select tan(1, 2);

ERROR 42000: Incorrect parameter count in the call to native function 'tan'

select makedate(1);

ERROR 42000: Incorrect parameter count in the call to native function 'makedate'

select makedate(1, 2, 3);

ERROR 42000: Incorrect parameter count in the call to native function 'makedate'

select atan();

ERROR 42000: Incorrect parameter count in the call to native function 'atan'

select atan2(1, 2, 3);

ERROR 42000: Incorrect parameter count in the call to native function 'atan2'

select concat();

ERROR 42000: Incorrect parameter count in the call to native function 'concat'

select concat("foo");

concat("foo")

foo

select concat_ws();

ERROR 42000: Incorrect parameter count in the call to native function 'concat_ws'

select concat_ws("foo");

ERROR 42000: Incorrect parameter count in the call to native function 'concat_ws'

select elt();

ERROR 42000: Incorrect parameter count in the call to native function 'elt'

select elt(1);

ERROR 42000: Incorrect parameter count in the call to native function 'elt'

select export_set();

ERROR 42000: Incorrect parameter count in the call to native function 'export_set'

select export_set("p1");

ERROR 42000: Incorrect parameter count in the call to native function 'export_set'

select export_set("p1", "p2");

ERROR 42000: Incorrect parameter count in the call to native function 'export_set'

select export_set("p1", "p2", "p3", "p4", "p5", "p6");

ERROR 42000: Incorrect parameter count in the call to native function 'export_set'

select field();

ERROR 42000: Incorrect parameter count in the call to native function 'field'

select field("p1");

ERROR 42000: Incorrect parameter count in the call to native function 'field'

select from_unixtime();

ERROR 42000: Incorrect parameter count in the call to native function 'from_unixtime'

select from_unixtime(1, 2, 3);

ERROR 42000: Incorrect parameter count in the call to native function 'from_unixtime'

select unix_timestamp(1, 2);

ERROR 42000: Incorrect parameter count in the call to native function 'unix_timestamp'

select greatest();

ERROR 42000: Incorrect parameter count in the call to native function 'greatest'

select greatest(12);

ERROR 42000: Incorrect parameter count in the call to native function 'greatest'

select last_insert_id(1, 2);

ERROR 42000: Incorrect parameter count in the call to native function 'last_insert_id'

select least();

ERROR 42000: Incorrect parameter count in the call to native function 'least'

select least(12);

ERROR 42000: Incorrect parameter count in the call to native function 'least'

select locate();

ERROR 42000: Incorrect parameter count in the call to native function 'locate'

select locate(1);

ERROR 42000: Incorrect parameter count in the call to native function 'locate'

select locate(1, 2, 3, 4);

ERROR 42000: Incorrect parameter count in the call to native function 'locate'

select log();

ERROR 42000: Incorrect parameter count in the call to native function 'log'

select log(1, 2, 3);

ERROR 42000: Incorrect parameter count in the call to native function 'log'

select make_set();

ERROR 42000: Incorrect parameter count in the call to native function 'make_set'

select make_set(1);

ERROR 42000: Incorrect parameter count in the call to native function 'make_set'

select rand(1, 2, 3);

ERROR 42000: Incorrect parameter count in the call to native function 'rand'

select round(1, 2, 3);

ERROR 42000: Incorrect parameter count in the call to native function 'round'

select abs(3);

abs(3)

3

select abs(3 AS three);

ERROR 42000: Incorrect parameters in the call to native function 'abs'

select abs(3 three);

ERROR 42000: Incorrect parameters in the call to native function 'abs'

select abs(3 AS "three");

ERROR 42000: Incorrect parameters in the call to native function 'abs'

select abs(3 "three");

ERROR 42000: Incorrect parameters in the call to native function 'abs'

set @bar="bar";

set @foobar="foobar";

select instr("foobar", "bar");

instr("foobar", "bar")

4

select instr("foobar" AS p1, "bar");

ERROR 42000: Incorrect parameters in the call to native function 'instr'

select instr("foobar" p1, "bar");

ERROR 42000: Incorrect parameters in the call to native function 'instr'

select instr("foobar" AS "p1", "bar");

ERROR 42000: Incorrect parameters in the call to native function 'instr'

select instr("foobar" "p1", "bar");

instr("foobar" "p1", "bar")

4

select instr(@foobar "p1", "bar");

ERROR 42000: Incorrect parameters in the call to native function 'instr'

select instr("foobar", "bar" AS p2);

ERROR 42000: Incorrect parameters in the call to native function 'instr'

select instr("foobar", "bar" p2);

ERROR 42000: Incorrect parameters in the call to native function 'instr'

select instr("foobar", "bar" AS "p2");

ERROR 42000: Incorrect parameters in the call to native function 'instr'

select instr("foobar", "bar" "p2");

instr("foobar", "bar" "p2")

0

select instr("foobar", @bar "p2");

ERROR 42000: Incorrect parameters in the call to native function 'instr'

select instr("foobar" AS p1, "bar" AS p2);

ERROR 42000: Incorrect parameters in the call to native function 'instr'

select conv(255, 10, 16);

conv(255, 10, 16)

FF

select conv(255 AS p1, 10, 16);

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255 p1, 10, 16);

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255 AS "p1", 10, 16);

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255 "p1", 10, 16);

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255, 10 AS p2, 16);

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255, 10 p2, 16);

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255, 10 AS "p2", 16);

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255, 10 "p2", 16);

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255, 10, 16 AS p3);

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255, 10, 16 p3);

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255, 10, 16 AS "p3");

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255, 10, 16 "p3");

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select conv(255 AS p1, 10 AS p2, 16 AS p3);

ERROR 42000: Incorrect parameters in the call to native function 'conv'

select atan(10);

atan(10)

1.47112767430373

select atan(10 AS p1);

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10 p1);

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10 AS "p1");

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10 "p1");

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10, 20);

atan(10, 20)

0.463647609000806

select atan(10 AS p1, 20);

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10 p1, 20);

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10 AS "p1", 20);

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10 "p1", 20);

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10, 20 AS p2);

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10, 20 p2);

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10, 20 AS "p2");

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10, 20 "p2");

ERROR 42000: Incorrect parameters in the call to native function 'atan'

select atan(10 AS p1, 20 AS p2);

ERROR 42000: Incorrect parameters in the call to native function 'atan'

DROP TABLE IF EXISTS t1;

SELECT "1997-12-31 23:59:59" + INTERVAL 1 SECOND;

"1997-12-31 23:59:59" + INTERVAL 1 SECOND

1998-01-01 00:00:00

SELECT 1 + INTERVAL(1,0,1,2) + 1;

1 + INTERVAL(1,0,1,2) + 1

4

SELECT INTERVAL(1,0,1,2) + 1;

INTERVAL(1,0,1,2) + 1

3

SELECT INTERVAL(1,0+1,2,3) * 5.5;

INTERVAL(1,0+1,2,3) * 5.5

5.5

SELECT INTERVAL(3,3,1+3,4+4) / 0.5;

INTERVAL(3,3,1+3,4+4) / 0.5

2.0000

SELECT (INTERVAL(1,0,1,2) + 5) * 7 + INTERVAL(1,0,1,2) / 2;

(INTERVAL(1,0,1,2) + 5) * 7 + INTERVAL(1,0,1,2) / 2

50.0000

SELECT INTERVAL(1,0,1,2) + 1, 5 * INTERVAL(1,0,1,2);

INTERVAL(1,0,1,2) + 1	5 * INTERVAL(1,0,1,2)

3	10

SELECT INTERVAL(0,(1*5)/2) + INTERVAL(5,4,3);

INTERVAL(0,(1*5)/2) + INTERVAL(5,4,3)

2

CREATE TABLE t1 (a INT, b DATETIME);

INSERT INTO t1 VALUES (INTERVAL(3,2,1) + 1, "1997-12-31 23:59:59" + INTERVAL 1 SECOND);

SELECT * FROM t1 WHERE a = INTERVAL(3,2,1) + 1;

a	b

3	1998-01-01 00:00:00

DROP TABLE t1;

DROP TABLE IF EXISTS t1,t2,t3;

CREATE TABLE t1 (a1 INT, a2 INT, a3 INT, a4 DATETIME);

CREATE TABLE t2 LIKE t1;

CREATE TABLE t3 LIKE t1;

SELECT t1.* FROM t1 AS t0, { OJ t2 INNER JOIN t1 ON (t1.a1=t2.a1) } WHERE t0.a3=2;

a1	a2	a3	a4

SELECT t1.*,t2.* FROM { OJ ((t1 INNER JOIN t2 ON (t1.a1=t2.a2)) LEFT OUTER JOIN t3 ON t3.a3=t2.a1)};

a1	a2	a3	a4	a1	a2	a3	a4

SELECT t1.*,t2.* FROM { OJ ((t1 LEFT OUTER JOIN t2 ON t1.a3=t2.a2) INNER JOIN t3 ON (t3.a1=t2.a2))};

a1	a2	a3	a4	a1	a2	a3	a4

SELECT t1.*,t2.* FROM { OJ (t1 LEFT OUTER JOIN t2 ON t1.a1=t2.a2) CROSS JOIN t3 ON (t3.a2=t2.a3)};

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'ON (t3.a2=t2.a3)}' at line 1

SELECT t1.*,t2.* FROM { OJ (t1 LEFT OUTER JOIN t2 ON t1.a1=t2.a2) INNER JOIN t3 ON (t3.a2=t2.a3)};

a1	a2	a3	a4	a1	a2	a3	a4

SELECT * FROM {oj t1 LEFT OUTER JOIN t2 ON t1.a1=t2.a3} WHERE t1.a2 > 10;

a1	a2	a3	a4	a1	a2	a3	a4

SELECT {fn CONCAT(a1,a2)} FROM t1;

{fn CONCAT(a1,a2)}

UPDATE t3 SET a4={d '1789-07-14'} WHERE a1=0;

SELECT a1, a4 FROM t2 WHERE a4 LIKE {fn UCASE('1789-07-14')};

a1	a4

DROP TABLE t1, t2, t3;

BACKUP DATABASE *, test to 'broken.bak';

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'BACKUP DATABASE *, test to 'broken.bak'' at line 1

BACKUP DATABASE *, db1, db2, db3 to 'broken.bak';

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'BACKUP DATABASE *, db1, db2, db3 to 'broken.bak'' at line 1