From: Ben Clewett
Date: May 23 2006 7:27am
Subject: InnoDB problems under 5.1.9
List-Archive: http://lists.mysql.com/mysql/198194
Message-Id: <4472B955.30100@clewett.org.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dear MySQL,

I've installed 5.1.9 from source on a SUSE 10 box.  But I can't get 
InnoDB tables respected.

I have used the correct compilation flag (--with-innodb).
SHOW VARIABLES; lists all the usual innodb variables.
The innodb table space has been created in ~/var/ibdata1.

But if I enter:

CREATE TABLE a (
   a int NOT NULL PRIMARY KEY
) ENGINE=InnoDB;

SHOW CREATE TABLE a;

CREATE TABLE `a` (
   `a` int(10) NOT NULL PRIMARY KEY
) ENGINE=MyISAM

As you can see, an InnoDB has become an MyISAM and will be stored in 
~/var/test/a.*

I am using the large table .cnf file.  Everything else is much as default.

Can anybody help me?

Regards,

Ben