Bug #70129 ROW_FORMAT=COMPACT issues
Submitted: 23 Aug 2013 5:08 Modified: 6 Feb 2014 9:46
Reporter: Stas V Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:all OS:Any
Assigned to: CPU Architecture:Any
Tags: sql error synch generate row_format compact

[23 Aug 2013 5:08] Stas V
Description:
Synching table with database table that has row format compact results in incorrectly generated sql (model synch)

ALTER TABLE `my_ict`.`ict_nice_table` 
ROW_FORMAT =  

How to repeat:
1) create new modeing schema
2) create new table
3) database/synchronize model, but stop when query log is displayed
4) alter log by adding ", ROW_FORMAT = COMPACT;" after COLLATE (this will tell mysql to create a table that has row format = COMPACT)
5) run synch
6) do database/synchronize model again
7) this time sql generated by workbench will be broken and will not run.
[23 Jan 2014 13:27] Miguel Tadeu Mota
bug #40500 is a dupicate of this one.
[6 Feb 2014 9:46] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.1.2 release, and here's the changelog entry:

While executing "Database", "Synchronize Model...", adding a ROW_FORMAT
definition (such as "ROW_FORMAT = COMPACT;") would not add a valid
ROW_FORMAT definition on the next execution of "Synchronize Model...", and
instead an invalid (empty) "ROW_FORMAT =" was added.

Thank you for the bug report.