MySQL Bugs: #46838: "REFERENCED_TABLE_CATALOG does not belong to table" in VS2008 DataSet Designer

Bug #46838	"REFERENCED_TABLE_CATALOG does not belong to table" in VS2008 DataSet Designer
Submitted:	20 Aug 2009 18:10	Modified:	21 Aug 2009 12:51
Reporter:	Doug Robertson	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	6.0.4	OS:	Windows (WIN XP x64)
Assigned to:		CPU Architecture:	Any
Tags:	Connector/Net, REFERENCED_TABLE_CATALOG

Description:
When trying to add a query or table to the DataSet designer in Visual Studio 2008 I recieve an error;

Failed to merge object(s)
Column 'REFERENCED_TABLE_CATALOG' does not belong to table...

This error prevents me from adding table or queries to the DataSet designer.  The only workaround I have found is to downgrade the connector to v5.2.7.  After doing all the design work with connector 5.2.7 I can then upgrade back to a higher level version of the connector with no ill effects.  This error seems to only effect the Visual Studio DataSet Designer.

How to repeat:
Using version 6.0.4 of the Connector/NET in Visual Studio 2008.  Link to a MySQL database (InnoDB) with multiple tables that contain foriegn key linkages.  Add a few tables to the DataSet designer and this error should happen by the second table added.

Suggested fix:
Possibly comparing the code between v5.2.7 and the higher versions to see the changes to the handling of the 'REFERENCED_TABLE_CATALOG'information.  This functionality works in the Connector/NEt 5.2.7 and below, but breaks in all higher versions I have tried.

Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Explanation: Hi Doug and thanks for your report. It is a duplicate of Bug#45170, please see details there.

My apologies, but I did do a search for this bug before submiting, including looking for any reference to REFERENCED_TABLE_CATALOG and found nothing.  I will follow the bug on the other submission now that I know it is there.

Doug

NP Doug.

I have the same problem.
Visual Studio 2008
MySql 5.1
Connector/.Net 6.1.2

What I need to do ?

Tks
Gerson

This one is marked as a duplicate of Bug #45170, but that Bug has been marked as "No Feedback."

What has to be done to get this bug active again? Does another one have to be submitted and then feedback provided?