~drizzle-trunk/drizzle/development

create table t1 (a int, b int, d int, e bigint, f float(3,2), g double(4,3), h decimal(5,4), j date, k timestamp, l datetime, m enum('a','b'), o char(10));

444

SHOW CREATE TABLE t1;

445

Table Create Table

446

t1 CREATE TABLE `t1` (

447

`a` INT DEFAULT NULL,

448

`b` INT DEFAULT NULL,

449

`d` INT DEFAULT NULL,

450

`e` BIGINT DEFAULT NULL,

451

`f` DOUBLE(3,2) DEFAULT NULL,

452

`g` DOUBLE(4,3) DEFAULT NULL,

453

`h` DECIMAL(5,4) DEFAULT NULL,

454

`j` DATE DEFAULT NULL,

455

`k` TIMESTAMP NULL DEFAULT NULL,

456

`l` DATETIME DEFAULT NULL,

457

`m` ENUM('a','b') DEFAULT NULL,

458

`o` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL

459

) ENGINE=InnoDB COLLATE = utf8_general_ci

460

444

create table t2 select ifnull(a,a), ifnull(b,b), ifnull(d,d), ifnull(e,e), ifnull(f,f), ifnull(g,g), ifnull(h,h), ifnull(j,j), ifnull(k,k), ifnull(l,l), ifnull(m,m), ifnull(o,o) from t1;

461

445

show create table t2;

462

446

Table Create Table

540

524

create table t1(test.column.name int);

541

525

ERROR 42000: Incorrect table name 'column'

542

526

create table t1(xyz.t1.name int);

543

ERROR 42000: Incorrect schema name 'xyz'

527

ERROR 42000: Incorrect database name 'xyz'

544

528

create table t1(t1.name int);

545

529

create table t2(test.t2.name int);

546

530

drop table t1,t2;

559

543

use mysqltest;

560

544

drop database mysqltest;

561

545

create table test.t1 like x;

562

ERROR 3D000: No schema selected

546

ERROR 3D000: No database selected

563

547

drop table if exists test.t1;

564

548

create database mysqltest;

565

549

create database if not exists mysqltest;

566

550

Warnings:

567

Note 1007 Can't create schema 'mysqltest'; schema exists

551

Note 1007 Can't create database 'mysqltest'; database exists

568

552

show create database mysqltest;

569

553

Database Create Database

570

554

mysqltest CREATE DATABASE `mysqltest` COLLATE = utf8_general_ci

682

666

) ENGINE=DEFAULT COLLATE = utf8_general_ci

683

667

drop table t1, t2;

684

668

create table t1 select * from t2;

685

ERROR 42S02: Unknown table 'test.t2'

669

ERROR 42S02: Table 'test.t2' doesn't exist

686

670

create table t1 select * from t1;

687

671

ERROR HY000: You can't specify target table 't1' for update in FROM clause

688

672

create table t1 select coalesce('a' collate utf8_swedish_ci,'b' collate utf8_bin);

710

694

711

695

drop temporary table t1;

712

696

select * from t1;

713

ERROR 42S02: Unknown table 'test.t1'

697

ERROR 42S02: Table 'test.t1' doesn't exist

714

698

drop table t1;

715

699

ERROR 42S02: Unknown table 't1'

716

700

create table t1 (upgrade int);

1415

1399

a b

1416

1400

drop table t1,t2;

1417

1401

CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;

1418

ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

1402

ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

1419

1403

DROP DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;

1420

ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

1404

ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

1421

1405

USE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;

1422

ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

1406

ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

1423

1407

SHOW CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;

1424

Database Create Database

1408

ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

1425

1409

create database имя_базы_в_кодировке_утф8_длиной_больше_чем_45;

1426

1410

use имя_базы_в_кодировке_утф8_длиной_больше_чем_45;

1427

1411

select database();

1460

1444

) ENGINE=DEFAULT COLLATE = utf8_general_ci

1461

1445

drop table имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48;

1462

1446

create table t1 like data_dictionary.processlist;

1463

Got one of the listed errors

1447

ERROR HY000: Can't create table 'test.t1' (errno: 1)

1464

1448

create table t1 like data_dictionary.processlist engine=innodb;

1465

1449

show create table t1;

1466

1450

Table Create Table

1467

1451

t1 CREATE TABLE `t1` (

1468

1452

`ID` BIGINT NOT NULL,

1469

`USERNAME` VARCHAR(16) NOT NULL,

1453

`USER` VARCHAR(16) NOT NULL,

1470

1454

`HOST` VARCHAR(1025) NOT NULL,

1471

`DB` VARCHAR(256) DEFAULT NULL,

1455

`DB` VARCHAR(256) NOT NULL,

1472

1456

`COMMAND` VARCHAR(16) NOT NULL,

1473

`TIME` BIGINT UNSIGNED NOT NULL,

1457

`TIME` BIGINT NOT NULL,

1474

1458

`STATE` VARCHAR(256) DEFAULT NULL,

1475

`INFO` VARCHAR(100) DEFAULT NULL,

1476

`HAS_GLOBAL_LOCK` BOOLEAN NOT NULL

1459

`INFO` VARCHAR(100) DEFAULT NULL

1477

1460

) ENGINE=InnoDB COLLATE = utf8_general_ci

1478

1461

drop table t1;

1479

1462

create temporary table t1 like data_dictionary.processlist;

1480

Got one of the listed errors

1463

ERROR HY000: Can't create table 'test.#t1' (errno: 138)

1481

1464

create temporary table t1 like data_dictionary.processlist engine=myisam;

1482

1465

show create table t1;

1483

1466

Table Create Table

1484

1467

t1 CREATE TEMPORARY TABLE `t1` (

1485

1468

`ID` BIGINT NOT NULL,

1486

`USERNAME` VARCHAR(16) NOT NULL,

1469

`USER` VARCHAR(16) NOT NULL,

1487

1470

`HOST` VARCHAR(1025) NOT NULL,

1488

`DB` VARCHAR(256) DEFAULT NULL,

1471

`DB` VARCHAR(256) NOT NULL,

1489

1472

`COMMAND` VARCHAR(16) NOT NULL,

1490

`TIME` BIGINT UNSIGNED NOT NULL,

1473

`TIME` BIGINT NOT NULL,

1491

1474

`STATE` VARCHAR(256) DEFAULT NULL,

1492

`INFO` VARCHAR(100) DEFAULT NULL,

1493

`HAS_GLOBAL_LOCK` BOOLEAN NOT NULL

1475

`INFO` VARCHAR(100) DEFAULT NULL

1494

1476

) ENGINE=MyISAM COLLATE = utf8_general_ci

1495

1477

drop table t1;

1496

1478

Older »