Bug #33681 Import from sql script doesn't show any error when the sql file contain errors
Submitted: 3 Jan 2008 22:50 Modified: 8 Jan 2008 13:23
Reporter: Edwin Cruz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.11 OS:Windows (XP SP2)
Assigned to: Sergei Tkachenko CPU Architecture:Any
Tags: importing, reverse engineering, sql script

[3 Jan 2008 22:50] Edwin Cruz
Description:
When importing scripts that contain sitaxis errors, the Workbench does not show any error/warnings dialog.

How to repeat:
File->Import->Reverse Engineer MySQL Create Script

Select any sql file with sintax errors like this:

CREATE  TABLE IF NOT EXISTS `mydb`.`TVehicle` (
  `idTVehicle` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `VIM` CHAR(50) NULL ,
  `model` CHAR(50) NULL ,
  `active` NULL DEFAULT 'A',       #[datatype missing]
  PRIMARY KEY (`idTVehiculo`) )
;

In the Output console something like this is shown:
Finished parsing MySQL SQL Script. Totally processed statements: Successfull(1), errors(1), warnings(1)

But no sintax error or warning is fetched into the Output log.

Suggested fix:
Open a dialog showing "Parsing Errors" or add in the Output console the errors.
[3 Jan 2008 23:29] MySQL Verification Team
Thank you for the bug report.
[8 Jan 2008 13:20] Sergei Tkachenko
You may still notice empty log entries in log panel, for which only timestamps are set. Those entries are multiline error messages, referencing excerpts from original SQL statement. The problem is with improperly set vertical alignment for the control. To be fixed in forthcoming version.
[8 Jan 2008 13:23] Sergei Tkachenko
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html