Bug #7139 compare button returns inaccurate result & toggles?
Submitted: 9 Dec 2004 17:46 Modified: 14 Dec 2004 12:52
Reporter: Soetji Anto Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.2 OS:Windows (Win 2000 SP4)
Assigned to: Mike Lischke CPU Architecture:Any

[9 Dec 2004 17:46] Soetji Anto 
Description:
On first click the compare button returns inaccurate result. On 2nd click it does. I can keep clicking and the result toggles.

How to repeat:
Compare two result sets.
[9 Dec 2004 19:59] Soetji Anto 
Now no matter how many times I click the compare button, the result is incorrect. It still toggles between 2 different result.
[9 Dec 2004 20:06] Soetji Anto 
Well, I found out what the problem was. On one sql I used the table name alias prefix in the SELECT (e.g, a.field1, a.field2) and on the other I didn't (e.g., simply field1, field2). The result sets both show the same field names; i.e., without "a.", thus giving the impression that I got the same field names.
[14 Dec 2004 12:51] Mike Lischke 
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.
[14 Dec 2004 12:52] Mike Lischke 
Sorry, but I cannot reproduce that problem, regardless whether I use column aliases or not.