Bug #4888 Compare button corrupting resultsets
Submitted: 4 Aug 2004 4:22 Modified: 6 Aug 2004 9:17
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: Ulrich Bayer CPU Architecture:Any

[4 Aug 2004 4:22] Mike Hillyer 
Description:
When I open two resultsets using the world sample database:

SELECT * FROM City C ORDER BY Id
SELECT * FROM City C WHERE mod(id, 2) ORDER BY Id

Both have proper ordering and look fine, one with all rows, one with odd rows. 

If I click the compare button, both result sets appear in what is almost random order, with almost all fields highlighted blue. It would appear that even though the rows are out of order, they are still being associated, thus all fields are highlighted blue.

If I remove the ORDER BY clauses, some rows are properly matched, but for the most part the rows are blocks of green and red, where there should be alternating green/red with white.

How to repeat:
Do as I did above.

Suggested fix:
Not sure what to suggest, the system is screwing up the ordering of the result sets for comparing. No matter what I try I cannot make the compare work properly.
[6 Aug 2004 9:17] Alfredo Kojima 
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