Bug #15057 unable to create myIsam table against Mysql4 server
Submitted: 18 Nov 2005 21:55 Modified: 10 Aug 2006 19:36
Reporter: Mark Grabowski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.1.4 and 1.1.5 OS:Windows (Windows)
Assigned to: Michael G. Zinner CPU Architecture:Any
Tags: Object Editors

[18 Nov 2005 21:55] Mark Grabowski
Description:
cant create myIsam table against version 4.0.17 mysql server using Mysql Administrator.
MySQL admin doesnt take into account version of db server and therefore doesnt seem to use appropriate syntax.
4.0.17 does not understand ENGINE=MYISAM that my SQLAdmin generates.

How to repeat:
create a new myISAM table or change an exisiting innodb table to myISAM in mySQL Adminisitrator against version 4.0.17 mySQL dbServer 

Suggested fix:
have mySQL Administrator genreate appropriate syntax for appropriate level of db server, since it does detect the server version to which it is connected.
In this case TYPE=MYISAM should be genrated instead of ENGINE=MYISAM.

I understand that TYPE= is deprecated, but it is not always easy to upgrade a server.
[21 Nov 2005 17:45] Jorge del Conde
Thanks for your bug report.  I was able to reproduce this problem with early versions of 4.0
[10 Aug 2006 19:36] Michael G. Zinner
Tested against 4.0.17.