syntax errors in generated sql
Posted by:
Paul Whipp
Date: October 19, 2008 05:55PM
When I attempt to synchronize a model to a local database, validation passes but I get syntax errors in the SQL that workbench is generating. They seem strange -
For some reason where I've entered a BOOLEAN column which is displayed as BOOLEAN in the workbench it gets written into the alter script as BOOLEAN(2). I can't see any way to stop it doing this and it breaks when the script is imported into MySQL 5.
If I delete all the tables in the db and use a create script where workbench writes in boolean without the (2) it works OK.
I can't believe something this basic is a bug - what am I doing wrong?
Subject
Written By
Posted
syntax errors in generated sql
October 19, 2008 05:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.