| Bug #30843 | Bad Test addition to t/archive.test | ||
|---|---|---|---|
| Submitted: | 5 Sep 2007 21:10 | Modified: | 24 Oct 2007 2:58 |
| Reporter: | Brian Aker | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Archive storage engine | Severity: | S3 (Non-critical) |
| Version: | 5.0 test cases (maybe before) | OS: | Any |
| Assigned to: | Magnus Blåudd | CPU Architecture: | Any |
[21 Sep 2007 7:49]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/34449 ChangeSet@1.2496, 2007-09-21 09:48:30+02:00, msvensson@shellback.(none) +2 -0 Bug#30843 Bad Test addition to t/archive.test - Add extra insert
[22 Sep 2007 10:17]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/34485 ChangeSet@1.2529, 2007-09-22 12:17:14+02:00, msvensson@shellback.(none) +2 -0 Bug#30843 Bad Test addition to t/archive.test
[18 Oct 2007 21:35]
Bugs System
Pushed into 5.1.23-beta
[18 Oct 2007 21:36]
Bugs System
Pushed into 5.0.52
[24 Oct 2007 2:58]
Paul DuBois
Test case change. No changelog entry needed.
Description: This was added: # Test INSERT DELAYED and wait until the table has one more record SELECT COUNT(auto) FROM t2; INSERT DELAYED INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily',''); while (`SELECT COUNT(auto)!=1214 FROM t2`) { sleep 0.1; } SELECT COUNT(auto) FROM t2; In Archive delayed values are only guaranteed to materialize based on either: 1) A new row showing up from a normal insert 2) A flush table has occurred. So this test may, or may never work. In practice it will probably work most of the time How to repeat: Run the test several thousand times. Suggested fix: Restore the original test or add a flush table or additional insert before the while loop.