MySQL Bugs: #45881: Filter prevents from reversing only one table

Bug #45881	Filter prevents from reversing only one table
Submitted:	1 Jul 2009 14:45	Modified:	18 Nov 2009 14:19
Reporter:	Marc MENDEZ	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.1.16	OS:	Windows (XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	filter, reverse

Description:
On Reverse Engineer Database, I can't reverse only one table by selecting it on the "Select Object" step.

How to repeat:
On Reverse Engineer Database, on the select objects step, I select only one table : the Execute button does not work.
I uncheck the other filters : no action.
However, if I check all the filters but does not select any item in each of them, I can reverse my table

Thank you for the bug report. Could you please provide a model file and step by step instructions how to repeat. Thanks in advance.

Hi,

There is no specific model. I discover this bug while I tried the new version, starting from scratch.
Here are the steps :

I connect to a MySql DB, using MySql Native driver.
None advanced options are checked.
Then, I go to Database -> Reverse Engineer
I choose the stored connection and click "Next" twice
I check one schema and click next twice
On the Select Objects tab, I have 4 frames : 
- Table objects (144 objects / 144 selected)
- View Objects (1 object / 1 selected)
- Routine Objects (16 objets / 16 selected )
- Trigger Objects (20 objects / 20 selected)

The "Place objects on the diagram" is checked
I click on the Table object filter button. First, I move to right all the tables and then selected from right just one table
(so 144 objects / 1 selected)
Then I click "Execute" : nothing happens
I uncheck all the other import check box and click "Execute" : nothing happens
I get into each filter (which are still unchecked) and move all items from left to right. 
I click "Execute" and then, I succeed in importing my table.

Was it enough accurate ?

Best regards

Sorry, but I can not repeat this with 5.1.16 on Mac OS X. What operating system do you use?

Hi,

I works under Windows XP Professional.

Best Regards,

Verified just as described in your comment dated

[2 Jul 9:28] Marc MENDEZ

with 5.1.16 on Windows XP.

For only taking one table (or any other object) into account you have to first move all objects from the left list (which is the inclusion list) to the right one (the exclusion list). After that not only select your single table but move it back to the inclusion list. The text above these lists should read like

X Total Objects, 1 Selected

Then, and only then, you will process this one single object. You can easily go back and forward from the object filter page to the Review Generated Script page, to the effect of moving objects between the lists or adding ignore filter rules (with wild cards).

Please let me know if that solve your problem of processing only one object.

Mike

Verified with 5.1.16 on Linux.

I wasn't able to verify this on 5.1.17 because of another bug.

this is not repeatable in 5.1.8 and 5.2.7 anymore so it can be considered fixed in that verisons.

An entry was added to the 5.1.8 and 5.2.7 changelogs:

In the Reverse Engineer Database wizard it was not possible to select only one table to reverse engineer, and then proceed to the next step.