Bug #27190 Information Schema test fails

• Submitted: 15 Mar 2007 21:30
• Modified: 15 Mar 2007 21:54
• Reporter: Joshua Kugler (Basic Quality Contributor)
• Status: Can't repeat
• Category: MySQL Server: Compiling
• Severity: S2 (Serious)
• Version: 5.0.37
• OS: Linux (Linux (tar.gz download))
• CPU Architecture: Any

[15 Mar 2007 21:30] Joshua Kugler

Description:
When running make test after compiling 5.0.37, the following is generated:

information_schema             [ fail ]

Errors are (from /home/jkugler/src/mysql-5.0.37/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/information_schema.result Mon Mar  5 22:40:30 2007
--- r/information_schema.reject Fri Mar 16 00:24:49 2007
***************
*** 1096,1102 ****
  group by column_type order by num;
  column_type   group_concat(table_schema, '.', table_name)     num
  varchar(20)   information_schema.COLUMNS,information_schema.PROFILING 2
! varchar(7)    information_schema.PROFILING,information_schema.PROFILING,information_schema.PROFILING,information_schema.ROUTINES,information_schema.VIEWS     5
  create table t1(f1 char(1) not null, f2 char(9) not null)
  default character set utf8;
  select CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH from
--- 1096,1102 ----
  group by column_type order by num;
  column_type   group_concat(table_schema, '.', table_name)     num
  varchar(20)   information_schema.COLUMNS,information_schema.PROFILING 2
! varchar(7)    information_schema.ROUTINES,information_schema.VIEWS    2
  create table t1(f1 char(1) not null, f2 char(9) not null)
  default character set utf8;
  select CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH from
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Result from queries before failure can be found in r/information_schema.log

Stopping All Servers
Shutting-down Instance Manager

How to repeat:
Compile, and run make test

[15 Mar 2007 21:54] MySQL Verification Team

Thank you for the bug report. I was unable to repeat with current
source tree on Ubuntu 6.10 32-bit.

Starting Tests in the 'main' suite

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

information_schema             [ pass ]          10527
-------------------------------------------------------
Stopping All Servers
skipped 9 bytes from file: socket (3)
All 1 tests were successful.
The servers where restarted 1 times
Spent 10.527 seconds actually executing testcases

miguel@light:~/dbs/mysql-5.0/mysql-test$