[BUG Report] [InfiniDB] Wrong Create Table Syntax

Hi,

If I create a nmew Table with InfiniDB (MySQL 5.1.783-log InfiniDB 4.6.7-1), I got a Error. SQL Error (138)

The roor cause is, that the create statement for InfiniDB is slightly different.

HeidiSQL create this Statement

CREATE TABLE ODD ( NUM INT NULL, ODD INT NULL ) COLLATE='latin1_swedish_ci' ENGINE=InfiniDB ;

But InfiniDB don't support the collate Statement and it is impossible not to choose a collate in the GUI.

The equivalent for InfiniDB is

CREATE TABLE ODD_NUMS2 ( NUMS INT NULL, ODD INT NULL ) ENGINE=InfiniDB DEFAULT CHARACTER SET = UTF8 ;

The second possibility is the possibility not to choose a collate, so that Database default will be choosen.

Richard