Bug #27331 func_in test failed
Submitted: 21 Mar 2007 14:11 Modified: 24 Mar 2007 11:50
Reporter: Doug Gilbert Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:Ver 8.41 Distrib 5.0.27 OS:Solaris (Solaris 8 SPARC)
Assigned to: CPU Architecture:Any

[21 Mar 2007 14:11] Doug Gilbert
Description:
While running mysql-test-run.pl after initial package install

func_in                        [ fail ]

Errors are (from /opt/local/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 209: query 'select count(*) from (
select @str:=concat(@str, @cnt:=@cnt+1, ",")
from t1 A, t1 B, t1 C, t1 D) Z' failed: 126: Incorrect key file for table '/opt/local/mysql/mysql-test/var/tmp/#sql_123c_0.MYI'; try to repair it
(the last lines may be the most important ones)
Result from queries before failure can be found in r/func_in.log

Matches bug report 26888 against 5.0.37 on winx64.

How to repeat:
Run mysql-test-run.pl as either a root or non-root user
[21 Mar 2007 19:20] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.37, and inform about the results.
[23 Mar 2007 13:16] Doug Gilbert
Version 5.0.37 Community does not fail this test.
[24 Mar 2007 3:56] Valeriy Kravchuk
So, this bug is not repeatable with a newer version.
[24 Mar 2007 11:50] Doug Gilbert
Yes. That is correct.