MySQL Bugs: #35339: Cannot reverse engineer existing database

Bug #35339	Cannot reverse engineer existing database
Submitted:	17 Mar 2008 14:12	Modified:	17 Mar 2008 17:02
Reporter:	Chris Goodrich	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	rc15	OS:	Windows (XP Home)
Assigned to:		CPU Architecture:	Any
Tags:	reverse engineer

Description:
When attempting to to retrieve existing schemata from v5 or v4 database fails with the following error;

Fetching table list.
OK
Fetching view list.
OK
Fetching routine list.
OK
Fetching trigger list.
Unknown column 'DEFINER' in 'field list'
Failed to fetch selected schemata objects.

How to repeat:
Database, Reverse Engineer
Reverse Engineer Dialog Box
Choose stored connection, for MySQL Server, Driver=MySQL Native Driver, Hostname=localhost, Port=3306, Username=root, Password=
Next
Tasks to execute; connect to DBMS=ok, Retrieve schemata description from DBMS=ok
Next
Select Schemata (click, then next -- Why not double click also?)
Tasks to Execute --> Error Message as in previous box 'Unknown column 'DEFINER' in 'field list' Failed to fetch schemata objects
No Next option available
Cancel

Thank you for a problem report. Please, send dump of the database (schema only) that demonstrates the behaviour described.

Pointing precise version number of MySQL Server will be enough. Note that brunch 4.x is not officially supported by MySQL Workbench.

File uploaded as requested.

Please note this problem occurs when attempting to reverse engineer;
v5 databases locally on my WinXP Home machine
v4 databases located on Linux NAS

MySQL Server Version 5.0.15

Recerse Eng

Attachment: jobdatadb.PNG (image/png, text), 42.16 KiB.

Thank you for the feedback. I wasn't able to repeat with Workbench 5.0.14a
(see attached picture).

NB reported for rc15 -- though same problems with 14a

I would recommend you to upgrade DBMS to one of the latest versions. We didn't test Workbench with early releases of v5.0.x brunch. Preliminary information regarding supported DBMS says it will be MySQL Server v5.0.51 as a minimum supported version.