Bug #18066 | Different results when running query twice | ||
---|---|---|---|
Submitted: | 8 Mar 2006 9:06 | Modified: | 7 Apr 2006 12:21 |
Reporter: | Lars Borg | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 4.1.7 | OS: | Linux (Linux Fedora core 1) |
Assigned to: | CPU Architecture: | Any |
[8 Mar 2006 9:06]
Lars Borg
[8 Mar 2006 10:38]
Heikki Tuuri
Lars, are these MyISAM or InnoDB tables? Are you using the query cache? 4.1.7 is rather old. Does the bug still exist in 4.1.18? Regards, Heikki
[8 Mar 2006 10:45]
Lars Borg
All tables are InnoDB. I'll try to upgrade to 4.1.18 to see if the problem remains. /Lasse
[8 Mar 2006 14:35]
MySQL Verification Team
Thank you for the bug report. Could you please test with latest released server, if the issue continues could you please provide a dump for to test the offended query? Thanks in advance.
[6 Apr 2006 14:20]
Lars Borg
Tried the exact same query on version 5.0.19. This version seems to behave correctly. I've not tried any other versions than 4.1.7 and 5.0.19. If it is extreamly necessary to test other versions, let me know and I'll try to find the time for it.
[6 Apr 2006 15:14]
MySQL Verification Team
Thank you for the feedback. Could you please try with the latest release 4.1.18. Thanks in advance.
[7 Apr 2006 10:36]
Lars Borg
4.1.18 seems to behave correctly.
[7 Apr 2006 12:21]
MySQL Verification Team
Thank you for the feedback. I am closing this bug report.