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:
None 
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
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
[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)