Bug #45181 workbench synchronize incorrect with BOOLEAN field
Submitted: 29 May 2009 3:32 Modified: 10 Jun 2009 11:24
Reporter: Michael Tibben Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Data Types Severity:S2 (Serious)
Version:5.0, 5.1, 6.0 OS:Any
Assigned to: CPU Architecture:Any

[29 May 2009 3:32] Michael Tibben 
Description:
When synchronizing a database, the boolean column is altered unnecessarily. On large tables this causes long delays on synchronization

How to repeat:
Open testcase1.mwb

go to Database->Synchronize

run through the wizard to create the table

when finished, go to Database->Synchronize

run through the wizard to synchronise. Workbench insists on altering the table when it is unnecessary

Suggested fix:
Workbench should recognize that TINYINT=BOOLEAN
[29 May 2009 3:32] Michael Tibben 
boolean testcase

Attachment: testcase1.mwb (application/octet-stream, text), 3.71 KiB.
[10 Jun 2009 11:24] Susanne Ebrecht 
The problem here is that the server don't support another behaviour.

The server needs to be fixed here first then it will work with Workbench too.

This is a duplicate of bug #8485