Bug #70129 ROW_FORMAT=COMPACT issues

• Submitted: 23 Aug 2013 5:08
• Modified: 6 Feb 2014 9:46
• Reporter: Stas V
• Status: Closed
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: all
• OS: Any
• 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.