summaryrefslogtreecommitdiff
path: root/mysql-test/r/create.result
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2003-10-16 08:34:17 +0300
committerunknown <monty@mashka.mysql.fi>2003-10-16 08:34:17 +0300
commite83a7c2cf7b95247e639d9dc5318edfa91416e79 (patch)
tree9c5053024c17924a437b61dbfeddb064a9fa2171 /mysql-test/r/create.result
parent9c9ff4cce56305031ec8ac320758bdd4aefabddb (diff)
downloadmariadb-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.result5
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);