Bug #62156 | main.func_str fails when run with --repeat=2 | ||
---|---|---|---|
Submitted: | 12 Aug 2011 15:57 | Modified: | 12 Aug 2011 16:12 |
Reporter: | Oleg Tsarev | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
Version: | 5.5 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[12 Aug 2011 15:57]
Oleg Tsarev
[12 Aug 2011 16:11]
MySQL Verification Team
Thank you for the bug report. C:\build\5.5-2011-07-26\mysql-test>mysql-test-run.pl func_str --repeat=2 Found handle.exe version 3.42 Logging: C:\build\5.5-2011-07-26\mysql-test\mysql-test-run.pl func_str --repeat=2 110812 13:08:07 [Note] Plugin 'FEDERATED' is disabled. MySQL Version 5.5.16 Checking supported features... - skipping ndbcluster - SSL connections supported Collecting tests... vardir: C:/build/5.5-2011-07-26/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory 'C:/build/5.5-2011-07-26/mysql-test/var'... Installing system database... Using server port 63321 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.func_str [ pass ] 5033 main.func_str [ fail ] Test ended at 2011-08-12 13:08:32 CURRENT_TEST: main.func_str mysqltest: At line 1378: query 'SELECT 'aaaaaaaaaaaaaa' INTO OUTFILE 'bug58165.txt'' failed: 1086: File 'bug58165.txt' already exists The result from queries just before the failure was: < snip > 1 1 DROP TABLE t1; # # Bug#57913 large negative number to string conversion functions crash # Bug#57810 case/when/then : Assertion failed: length || !scale # SELECT '1' IN ('1', SUBSTRING(-9223372036854775809, 1)); '1' IN ('1', SUBSTRING(-9223372036854775809, 1)) 1 SELECT CONVERT(('' IN (REVERSE(CAST(('') AS DECIMAL)), '')), CHAR(3)); CONVERT(('' IN (REVERSE(CAST(('') AS DECIMAL)), '')), CHAR(3)) 1 Warnings: Warning 1292 Truncated incorrect DECIMAL value: '' # # Bug#58165: "my_empty_string" gets modified and causes LOAD DATA to fail # and other crashes # CREATE TABLE t1 ( a TEXT ); More results from queries before failure can be found in C:\build\5.5-2011-07-26\mysql-test\var\log\func_str.log - saving 'C:/build/5.5-2011-07-26/mysql-test/var/log/main.func_str/' to 'C:/build/5.5-2011-07-26/mysql-test/var/log/main.func_str/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 5.033 of 26 seconds executing testcases Completed: Failed 1/2 tests, 50.00% were successful. Failing test(s): main.func_str The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases C:\build\5.5-2011-07-26\mysql-test>
[5 Aug 2013 12:42]
Laurynas Biveinis
There was a very closely related change in 5.1.71 [1], but it still failed to fix the --repeat=2 failure, even though the commit message says "Cleanup test case (left outfile in data dir)". [1] revno: 4024 tags: clone-5.1.71-build, mysql-5.1.71 committer: Tor Didriksen <tor.didriksen@oracle.com> branch nick: 5.1 timestamp: Mon 2013-07-01 15:30:55 +0200 message: Bug#58165: "my_empty_string" gets modified and causes LOAD DATA to fail and Cleanup test case (left outfile in data dir)