MySQL Bugs: #18358: Imposible to create MyIsam table

Bug #18358	Imposible to create MyIsam table
Submitted:	20 Mar 2006 16:23	Modified:	15 Sep 2006 6:42
Reporter:	Michal Aichinger	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	up to 1.1.9	OS:	Windows (Windows XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
It is impossible to create MyIsam tables with table editor. Because it generate wrong code:

CREATE TABLE `michal`.`product_multilang` (
  `id_product_multilang` INTEGER UNSIGNED NOT NULL DEFAULT 0 AUTO_INCREMENT,
  `id_product` INTEGER UNSIGNED NOT NULL DEFAULT 0,
  `body` TEXT NOT NULL DEFAULT '',
  `txtParam1` VARCHAR(255) NOT NULL DEFAULT '',
  `txtParam2` VARCHAR(255) NOT NULL DEFAULT '',
  `txtParam3` VARCHAR(255) NOT NULL DEFAULT '',
  `id_lang` INTEGER UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY(`id_product_multilang`),
  INDEX `id_product`(`id_product`),
  INDEX `id_lang`(`id_lang`)
)
ENGINE = MYISAM;

correct is with TYPE = MYISAM at the end. 
(I use this tool with MySQL 4.0.xx)

How to repeat:
Try create some MyIsam table with MySQL Administrator.

Thank you for the bug report. I was able to create an MyISAM table
with MySQL Administrator against server 4.0.26. Below I show you
using the mysql client what was the create table statement performed by MA:

c:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 4.0.26-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show create table tb_myisam\G
*************************** 1. row ***************************
       Table: tb_myisam
Create Table: CREATE TABLE `tb_myisam` (
  `col1` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`col1`)
) TYPE=MyISAM
1 row in set (0.02 sec)

mysql>

So I tried it once again on two computers (XP, W2K) with local and remote databases in 4.x, 5.x versions. I was connected as root. I select schema and click Create Table. Input table name and some columns. Then on Table Option tab I check first option. Then after Apply Changes I got this error:

MySQL Error Number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE = MYISAM' at line 5

Thank you for the report.

Verified as described in MySQL Administrator 1.2.3 rc. Bug is only repeatable when connect to remote database.

There is duplicate bug #22304

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html