MySQL Bugs: #44343: Workbench not showing all available referenced columns with manual relations

Bug #44343	Workbench not showing all available referenced columns with manual relations
Submitted:	17 Apr 2009 11:22	Modified:	15 Jun 2009 11:49
Reporter:	Ken Brown	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.1.10a	OS:	Windows (Vista)
Assigned to:		CPU Architecture:	Any
Tags:	manual, referenced column, relation, workbench

Description:
creating manual relations does not allow correct relation joining.  System only shows a subset of columns for the join

How to repeat:
create table1 col1, col3, col4, col5, col6, col7, col8
create table2 col2, col1
create manual relation on table 2 joining col1
relation will not show all available columns (may need more columns to demonstrate)

Thank you for the problem report. Please, send .mwb file that demonstrates the problem. Maybe columns have different types, so not all of them can be referenced.

I got round it in the table causing me the problem by deleting the ref column and adding via the button as I needed to move forward.

And just pick a table with more than 1 relation - it will delete them all correctly unless it is the last on the list - this will give you a memory error

Thank you for the feedback. Then you have resolved the problem but having exception when deleting the relations? (that is a bug already reported). Thanks in advance.

No I haven't resolved the problem.
The relations still have a number of errors.
1. Deleting relations will cause a memory error when the last relation is deleted
2. Manually creating relations does not show all the parent columns to bind to.
3. When using the button and tables it does not use the exiting column if already there - it creates a new one
4. Button relations still fail on occasions and if they do they leave the relation column lying in the child table
5. Button relations still causing application hangs.

While you can click through the exceptions - they are memory exceptions and the only way to clear them down is to shut down the app - appears to be consuming 50mb every time the memory exception appears.

there was only 1 bug with the relations in 5.1.9 (a big one - hang) but you haven't fixed that either as I am still getting hangs

This is serious as the hang prevents saving or work

Sorry, but I don't understand your problem and I am not able to find a problem in your mwb file.

Please can you give a step by step description how to reproduce this problem.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".