Bug #33942 DBDesigner4 imported table generates incorrect ROW_FORMAT
Submitted: 19 Jan 2008 20:55 Modified: 31 Jan 2008 17:43
Reporter: Daniel Thonon Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.0.12 SE beta OS:Windows
Assigned to: Sergei Tkachenko CPU Architecture:Any

[19 Jan 2008 20:55] Daniel Thonon 
Description:
Tables created with DBDesigner4 and imported in Workbench generate SQL CREATE TABLE statement with the following options:
PACK_KEYS = 0
ROW_FORMAT = 0

0 is not and acceptable value for ROW_FORMAT

How to repeat:
Using the following DBDesigner4 table :

<TABLE ID="1009" Tablename="ecozone" PrevTableName="Ecozone" XPos="37" YPos="56" 
TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" 
TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" 
Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" >

Generates the following erroneous statement
-- -----------------------------------------------------
-- Table `mydb`.`ecozone`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`ecozone` (
  `idEcozone` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `NameFR` VARCHAR(255) NULL ,
  `NameEN` VARCHAR(255) NULL ,
  PRIMARY KEY (`idEcozone`) )
PACK_KEYS = 0
ROW_FORMAT = 0;
[19 Jan 2008 20:56] Daniel Thonon 
DBDesigner4 file

Attachment: ObsDB.xml (text/xml), 169.54 KiB.
[20 Jan 2008 16:28] Valeriy Kravchuk 
Thank you for a bug report. Verified just as described.
[31 Jan 2008 17:43] Sergei Tkachenko 
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.