Bug #64178 Add ability to check SQL syntax before creating models

Submitted: 31 Jan 2012 10:11 Modified: 31 Jan 2012 15:09
Reporter: Peter Spain Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: check, model, SQL, syntax

[31 Jan 2012 10:11] Peter Spain
Description:
When creating new schemas I like to bash out the SQL into a file and then use that file to create a model. I find writing the bones of a script much faster than creating each entity in a model one by one. I can then go ahead and make any tweaks/changes in the model.

However, I sometimes find I have made a mistake in my SQL script, and I don't find out about it after MySQL Workbench has imported a bunch of models. If there were errors, Workbench carries on as best it can and produces a broken model.

Suffice it to say, I don't relish unpicking problems/inconsistencies in my model due to a typo or omission in my SQL script.

If MySQL Workbench had an ability to validate a script to check there are no errors in syntax before creating a possibly broken model, it would save me a bunch of time. It would be handy feature in general, not just for the modelling component. 

How to repeat:
Create a new ERD model from an SQL file that has syntax errors.

Suggested fix:
Syntax validation before going ahead and creating the model.
[31 Jan 2012 15:09] Valeriy Kravchuk
Thank you for the feature request.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.