MySQL Bugs: #4918: Bottom section does not update when doing a three part master-detail view

Bug #4918	Bottom section does not update when doing a three part master-detail view
Submitted:	6 Aug 2004 1:11	Modified:	19 Sep 2005 10:14
Reporter:	Mike Hillyer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.0.5	OS:	Windows (Windows XP SP1)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
If you create a three part master-detail query the third part does not update when rows change in the top panel, only when you change rows in the middle.

How to repeat:
Lets say I am doing a master-detail set of queries on the world database... 

Query one:

SELECT C.Country, C.Language, C.IsOfficial, C.Percentage FROM CountryLanguage C

Query Two:
SELECT C.Code, C.Name FROM Country C WHERE code =:Country

And so far so good, if I click a country/language pair in query one the country in query two changes.

But let's say I get ambitious and split the tabsheet a third time with the query:

SELECT C.Id, C.Name, C.Country FROM City C WHERE Country =:Code

The third panel never gets updated with changes in the second panel.

If the middle panel has multiple rows and I click a new row, the bottom panel updates, but if there is a single row in the middle panel I can never click on a new one, and the bottom never updates.

Suggested fix:
Cascade row changes when the top query updates.

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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html