~drizzle-trunk/drizzle/development

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 CURTIME(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 'CURTIME(a int)' at line 1

create table CURTIME (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 'CURTIME (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);

134

130

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

135

131

create table CURDATE (a int);

136

132

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

137

create table CURTIME(a int);

138

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 'CURTIME(a int)' at line 1

139

create table CURTIME (a int);

140

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 'CURTIME (a int)' at line 1

141

133

create table DATE_ADD(a int);

142

134

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

143

135

create table DATE_ADD (a int);

263

255

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

264

256

select makedate(1, 2, 3);

265

257

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

266

select maketime();

267

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

268

select maketime(1);

269

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

270

select maketime(1, 2);

271

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

272

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

273

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

274

258

select atan();

275

259

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

276

260

select atan2(1, 2, 3);

436

420

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

437

421

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

438

422

DROP TABLE IF EXISTS t1;

439

SELECT STR_TO_DATE('10:00 PM', '%h:%i %p') + INTERVAL 10 MINUTE;

440

STR_TO_DATE('10:00 PM', '%h:%i %p') + INTERVAL 10 MINUTE

441

NULL

442

SELECT STR_TO_DATE('10:00 PM', '%h:%i %p') + INTERVAL (INTERVAL(1,2,3) + 1) MINUTE;

443

STR_TO_DATE('10:00 PM', '%h:%i %p') + INTERVAL (INTERVAL(1,2,3) + 1) MINUTE

444

NULL

445

423

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

446

424

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

447

425

1998-01-01 00:00:00

Older »