| 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 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)
Description: main.func_str [ fail ] Test ended at 2011-08-12 18:55:35 CURRENT_TEST: main.func_str mysqltest: At line 1377: 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 /storage/dev/percona/repeat/bug_report/Percona-Server-5.1.58-rel12.9/mysql-test/var/log/func_str.log How to repeat: ./mysql-test-run func_str --repeat=2 Suggested fix: https://code.launchpad.net/~tsarev/percona-server/func_str-repeatable-fix/+merge/70914