diff options
| -rw-r--r-- | mysql-test/r/create.result | 5 | ||||
| -rw-r--r-- | mysql-test/t/create.test | 5 |
2 files changed, 7 insertions, 3 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index 35565457274..90b163c8e19 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -16,6 +16,8 @@ b drop table t1; +create table t1 (a int not null auto_increment,primary key (a)) type=heap; +drop table t1; create table t2 type=heap select * from t1; ERROR 42S02: Table 'test.t1' doesn't exist create table t2 select auto+1 from t1; @@ -26,10 +28,11 @@ Note 1051 Unknown table 't1' Note 1051 Unknown table 't2' create table t1 (b char(0) not null, index(b)); ERROR 42000: The used storage engine can't index column 'b' -create table t1 (a int not null auto_increment,primary key (a)) type=heap; create table t1 (a int not null,b text) type=heap; ERROR 42000: The used table type doesn't support BLOB/TEXT columns drop table if exists t1; +Warnings: +Note 1051 Unknown table 't1' create table t1 (ordid int(8) not null auto_increment, ord varchar(50) not null, primary key (ord,ordid)) type=heap; ERROR 42000: Incorrect table definition; There can only be one auto column and it must be defined as a key create table not_existing_database.test (a int); diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test index 0148fa9431a..bc71c597270 100644 --- a/mysql-test/t/create.test +++ b/mysql-test/t/create.test @@ -17,6 +17,9 @@ insert into t1 values (""),(null); select * from t1; drop table t1; +create table t1 (a int not null auto_increment,primary key (a)) type=heap; +drop table t1; + # # Test of some CREATE TABLE'S that should fail # @@ -28,8 +31,6 @@ create table t2 select auto+1 from t1; drop table if exists t1,t2; --error 1167 create table t1 (b char(0) not null, index(b)); ---error 1164 -create table t1 (a int not null auto_increment,primary key (a)) type=heap; --error 1163 create table t1 (a int not null,b text) type=heap; drop table if exists t1; |