diff options
author | unknown <monty@mashka.mysql.fi> | 2003-10-16 08:34:17 +0300 |
---|---|---|
committer | unknown <monty@mashka.mysql.fi> | 2003-10-16 08:34:17 +0300 |
commit | e83a7c2cf7b95247e639d9dc5318edfa91416e79 (patch) | |
tree | 9c5053024c17924a437b61dbfeddb064a9fa2171 /mysql-test/r/create.result | |
parent | 9c9ff4cce56305031ec8ac320758bdd4aefabddb (diff) | |
download | mariadb-git-e83a7c2cf7b95247e639d9dc5318edfa91416e79.tar.gz |
Fix test after merge
mysql-test/r/create.result:
update test results
Diffstat (limited to 'mysql-test/r/create.result')
-rw-r--r-- | mysql-test/r/create.result | 5 |
1 files changed, 4 insertions, 1 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); |