~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);

130

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

131

135

create table CURDATE (a int);

132

136

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

133

141

create table DATE_ADD(a int);

134

142

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

135

143

create table DATE_ADD (a int);

241

249

CREATE TABLE table_25930_a ( blah INT );

242

250

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

243

251

desc table_25930_b;

244

Field Type Null Default Default_is_NULL On_Update

245

"blah" - 1 DOUBLE NO NO

252

Field Type Null Key Default Extra

253

"blah" - 1 double NO NULL

246

254

DROP TABLE table_25930_a;

247

255

DROP TABLE table_25930_b;

248

256

select pi(3.14);

255

263

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

256

264

select makedate(1, 2, 3);

257

265

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'

258

274

select atan();

259

275

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

260

276

select atan2(1, 2, 3);

261

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

277

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

262

278

select concat();

263

279

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

264

280

select concat("foo");

314

330

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

315

331

select make_set(1);

316

332

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

333

select master_pos_wait();

334

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

335

select master_pos_wait(1);

336

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

337

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

338

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

317

339

select rand(1, 2, 3);

318

340

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

319

341

select round(1, 2, 3);

320

342

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

343

select yearweek();

344

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

345

select yearweek(1, 2, 3);

346

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

321

347

select abs(3);

322

348

abs(3)

323

349

324

350

select abs(3 AS three);

325

abs(3 AS three)

326

351

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

327

352

select abs(3 three);

328

abs(3 three)

329

353

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

330

354

select abs(3 AS "three");

331

abs(3 AS "three")

332

355

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

333

356

select abs(3 "three");

334

abs(3 "three")

335

357

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

336

358

set @bar="bar";

337

359

set @foobar="foobar";

338

360

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

393

415

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

394

416

select atan(10);

395

417

atan(10)

396

1.47112767430373

418

1.4711276743037347

397

419

select atan(10 AS p1);

398

atan(10 AS p1)

399

1.47112767430373

420

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

400

421

select atan(10 p1);

401

atan(10 p1)

402

1.47112767430373

422

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

403

423

select atan(10 AS "p1");

404

atan(10 AS "p1")

405

1.47112767430373

424

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

406

425

select atan(10 "p1");

407

atan(10 "p1")

408

1.47112767430373

426

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

409

427

select atan(10, 20);

410

428

atan(10, 20)

411

0.463647609000806

429

0.4636476090008061

412

430

select atan(10 AS p1, 20);

413

atan(10 AS p1, 20)

414

0.463647609000806

431

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

415

432

select atan(10 p1, 20);

416

atan(10 p1, 20)

417

0.463647609000806

433

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

418

434

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

419

atan(10 AS "p1", 20)

420

0.463647609000806

435

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

421

436

select atan(10 "p1", 20);

422

atan(10 "p1", 20)

423

0.463647609000806

437

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

424

438

select atan(10, 20 AS p2);

425

atan(10, 20 AS p2)

426

0.463647609000806

439

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

427

440

select atan(10, 20 p2);

428

atan(10, 20 p2)

429

0.463647609000806

441

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

430

442

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

431

atan(10, 20 AS "p2")

432

0.463647609000806

443

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

433

444

select atan(10, 20 "p2");

434

atan(10, 20 "p2")

435

0.463647609000806

445

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

436

446

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

437

atan(10 AS p1, 20 AS p2)

438

0.463647609000806

447

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

439

448

DROP TABLE IF EXISTS t1;

449

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

450

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

451

NULL

452

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

453

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

454

NULL

440

455

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

441

456

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

442

1998-01-01 00:00:00.000000

457

1998-01-01 00:00:00

443

458

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

444

459

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

445

460

478

493

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

479

494

a1 a2 a3 a4 a1 a2 a3 a4

480

495

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

481

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

482

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

483

496

a1 a2 a3 a4 a1 a2 a3 a4

484

497

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

485

498

a1 a2 a3 a4 a1 a2 a3 a4

Older »