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/

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.