Bug #62340 | main.endspace sporadic fails | ||
---|---|---|---|
Submitted: | 3 Sep 2011 7:55 | Modified: | 26 Dec 2011 20:14 |
Reporter: | Oleg Tsarev | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
Version: | 5.1.60,5.5.20,5.6.4 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[3 Sep 2011 7:55]
Oleg Tsarev
[5 Sep 2011 17:35]
MySQL Verification Team
Could you please try MySQL source. I couldn't repeat: ============================================================================= TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.endspace [ pass ] 2596 ------------------------------------------------------------ The servers were restarted 0 times Spent 2.596 of 25 seconds executing testcases Thanks.
[5 Sep 2011 18:31]
Oleg Tsarev
Anycase - this test case is incorrect, because we have no guarantees about output order. On your current source code all right, on XtraDB (innodb_plugin based) order is different, and this order can be different on new version of InnoDB. According to what I have written before, test case should be fixed.h
[16 Dec 2011 8:13]
Bjørn Munch
An alternative fix is to add a --sorted_result before the query; this is the typical use case for that.
[26 Dec 2011 20:14]
Sveta Smirnova
Thank you for the report. Verified as described: these 2 queries could produce different result.