Bug #42 Current 4.1 tree fails in test "analyse"
Submitted: 27 Jan 2003 13:53 Modified: 8 Feb 2003 7:09
Reporter: Lenz Grimmer Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[27 Jan 2003 13:53] Lenz Grimmer
Description:
When compiling the current 4.1 BK tree (last ChangeSet: 1.1429 from 
2003-01-24) using BUILD/compile-pentium-max on build.mysql2.com, "make test" 
fails in test "analyse" with the following output: 
 
 TEST                         USER   SYSTEM  ELAPSED        RESULT 
------------------------------------------------------------------------ 
alias                         0.01     0.01     0.04       [ pass ] 
alter_table                   0.01     0.01     0.08       [ pass ] 
analyse                       ....     ....     ....       [ fail ] 
 
   >> Error at line 17: Result length mismatch<< 
Below are the diffs between actual and expected results: 
------------------------------------------------------- 
*** r/analyse.result    Mon Jan 27 08:06:45 2003 
--- r/analyse.reject    Mon Jan 27 08:24:23 2003 
*************** 
*** 3,9 **** 
  insert into t1 values (1,2), (3,4), (5,6), (7,8); 
  select count(*) from t1 procedure analyse(); 
  Field_name    Min_value       Max_value       Min_length      Max_length 
!                       -6510615555426900571    -6510615555426900571    
-6510615 
  select * from t1 procedure analyse(); 
  Field_name    Min_value       Max_value       Min_length      Max_length 
  t1.i  1       7       1       1       0       0       4.0000  2.2361  
ENUM('1' 
--- 3,9 ---- 
  insert into t1 values (1,2), (3,4), (5,6), (7,8); 
  select count(*) from t1 procedure analyse(); 
  Field_name    Min_value       Max_value       Min_length      Max_length 
!                       0       0       32      65535 
  select * from t1 procedure analyse(); 
  Field_name    Min_value       Max_value       Min_length      Max_length 
  t1.i  1       7       1       1       0       0       4.0000  2.2361  
ENUM('1' 
------------------------------------------------------- 
 

How to repeat:
Compile with BUILD/compile-pentium-max on build and run "make test" 

Suggested fix:
Unknown
[8 Feb 2003 7:09] Sergei Golubchik
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/