From 70e053fba0c96be907c674a29f0627cfe46186ad Mon Sep 17 00:00:00 2001 From: "monty@hundin.mysql.fi" <> Date: Thu, 13 Dec 2001 19:06:14 +0200 Subject: Fixed problem with default & InnoDB tables. --- mysql-test/r/innodb.result | 2 ++ mysql-test/t/innodb.test | 8 ++++++++ 2 files changed, 10 insertions(+) (limited to 'mysql-test') diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result index 333bbc45196..a422f55767d 100644 --- a/mysql-test/r/innodb.result +++ b/mysql-test/r/innodb.result @@ -499,3 +499,5 @@ table type possible_keys key key_len ref rows Extra t1 index NULL b 4 NULL 4 Using index table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 4 +Field Type Null Key Default Extra +testint int(11) 1 diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index f0e9f8cf72f..a962f120d4e 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -529,3 +529,11 @@ explain select a,b from t1 order by b; explain select a,b from t1; explain select a,b,c from t1; drop table t1; + +# +# Check describe +# + +create table t1 (testint int not null default 1) type=innodb; +desc t1; +drop table t1; -- cgit v1.2.1