~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 'IS TRUE IS TRUE' at line 1

411

select FALSE IS NOT TRUE IS NOT TRUE IS NOT TRUE;

412

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 'IS NOT TRUE IS NOT TRUE' at line 1

413

select NULL IS FALSE IS FALSE IS FALSE;

414

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 'IS FALSE IS FALSE' at line 1

415

select TRUE IS NOT FALSE IS NOT FALSE IS NOT FALSE;

416

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 'IS NOT FALSE IS NOT FALSE' at line 1

417

select FALSE IS UNKNOWN IS UNKNOWN IS UNKNOWN;

418

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 'IS UNKNOWN IS UNKNOWN' at line 1

419

select TRUE IS NOT UNKNOWN IS NOT UNKNOWN IS NOT UNKNOWN;

420

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 'IS NOT UNKNOWN IS NOT UNKNOWN' at line 1

421

Testing that IS [NOT] NULL predicates are associative

422

select FALSE IS NULL IS NULL IS NULL;

423

FALSE IS NULL IS NULL IS NULL

424

425

select TRUE IS NOT NULL IS NOT NULL IS NOT NULL;

426

TRUE IS NOT NULL IS NOT NULL IS NOT NULL

427

428

Testing that comparison operators are left associative

429

select 1 <=> 2 <=> 2, (1 <=> 2) <=> 2, 1 <=> (2 <=> 2);

430

1 <=> 2 <=> 2 (1 <=> 2) <=> 2 1 <=> (2 <=> 2)

431

0 0 1

432

select 1 = 2 = 2, (1 = 2) = 2, 1 = (2 = 2);

433

1 = 2 = 2 (1 = 2) = 2 1 = (2 = 2)

434

0 0 1

435

select 1 != 2 != 3, (1 != 2) != 3, 1 != (2 != 3);

436

1 != 2 != 3 (1 != 2) != 3 1 != (2 != 3)

437

1 1 0

438

select 1 <> 2 <> 3, (1 <> 2) <> 3, 1 <> (2 <> 3);

439

1 <> 2 <> 3 (1 <> 2) <> 3 1 <> (2 <> 3)

440

1 1 0

441

select 1 < 2 < 3, (1 < 2) < 3, 1 < (2 < 3);

442

1 < 2 < 3 (1 < 2) < 3 1 < (2 < 3)

443

1 1 0

444

select 3 <= 2 <= 1, (3 <= 2) <= 1, 3 <= (2 <= 1);

445

3 <= 2 <= 1 (3 <= 2) <= 1 3 <= (2 <= 1)

446

1 1 0

447

select 1 > 2 > 3, (1 > 2) > 3, 1 > (2 > 3);

448

1 > 2 > 3 (1 > 2) > 3 1 > (2 > 3)

449

0 0 1

450

select 1 >= 2 >= 3, (1 >= 2) >= 3, 1 >= (2 >= 3);

451

1 >= 2 >= 3 (1 >= 2) >= 3 1 >= (2 >= 3)

452

0 0 1

453

Testing that binary + is associative

454

select 1 + 2 + 3, (1 + 2) + 3, 1 + (2 + 3);

455

1 + 2 + 3 (1 + 2) + 3 1 + (2 + 3)

456

6 6 6

457

Testing that binary - is left associative

458

select 1 - 2 - 3, (1 - 2) - 3, 1 - (2 - 3);

459

1 - 2 - 3 (1 - 2) - 3 1 - (2 - 3)

460

-4 -4 2

461

Testing that binary + and binary - have the same precedence

462

select 1 + 2 - 3, (1 + 2) - 3, 1 + (2 - 3);

463

1 + 2 - 3 (1 + 2) - 3 1 + (2 - 3)

464

0 0 0

465

select 1 - 2 + 3, (1 - 2) + 3, 1 - (2 + 3);

466

1 - 2 + 3 (1 - 2) + 3 1 - (2 + 3)

467

2 2 -4

468

Testing that * is associative

469

select 2 * 3 * 4, (2 * 3) * 4, 2 * (3 * 4);

470

2 * 3 * 4 (2 * 3) * 4 2 * (3 * 4)

471

24 24 24

472

Testing that * has precedence over binary +

473

select 2 * 3 + 4, (2 * 3) + 4, 2 * (3 + 4);

474

2 * 3 + 4 (2 * 3) + 4 2 * (3 + 4)

475

10 10 14

476

select 2 + 3 * 4, (2 + 3) * 4, 2 + (3 * 4);

477

2 + 3 * 4 (2 + 3) * 4 2 + (3 * 4)

478

14 20 14

479

Testing that * has precedence over binary -

480

select 4 * 3 - 2, (4 * 3) - 2, 4 * (3 - 2);

481

4 * 3 - 2 (4 * 3) - 2 4 * (3 - 2)

482

10 10 4

483

select 4 - 3 * 2, (4 - 3) * 2, 4 - (3 * 2);

484

4 - 3 * 2 (4 - 3) * 2 4 - (3 * 2)

485

-2 2 -2

486

Testing that / is left associative

487

select 15 / 5 / 3, (15 / 5) / 3, 15 / (5 / 3);

488

15 / 5 / 3 (15 / 5) / 3 15 / (5 / 3)

489

1.00000000 1.00000000 9.0000

490

Testing that / has precedence over binary +

491

select 0x80 / 2 + 2, (0x80 / 2) + 2, 0x80 / (2 + 2);

492

0x80 / 2 + 2 (0x80 / 2) + 2 0x80 / (2 + 2)

493

66.0000 66.0000 32.0000

494

select 0x80 + 2 / 2, (0x80 + 2) / 2, 0x80 + (2 / 2);

495

0x80 + 2 / 2 (0x80 + 2) / 2 0x80 + (2 / 2)

496

129.0000 65.0000 129.0000

497

Testing that / has precedence over binary -

498

select 0x80 / 4 - 2, (0x80 / 4) - 2, 0x80 / (4 - 2);

499

0x80 / 4 - 2 (0x80 / 4) - 2 0x80 / (4 - 2)

500

30.0000 30.0000 64.0000

501

select 0x80 - 4 / 2, (0x80 - 4) / 2, 0x80 - (4 / 2);

502

0x80 - 4 / 2 (0x80 - 4) / 2 0x80 - (4 / 2)

503

126.0000 62.0000 126.0000

Older »