Bug #27397 information_schema test fails

• Submitted: 23 Mar 2007 13:12
• Modified: 28 Oct 2007 20:45
• Reporter: Doug Gilbert
• Status: Duplicate
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.0.37 Community
• OS: Linux (Linux, Solaris 8 SPARC,Solaris 10 x86)
• CPU Architecture: Any

[23 Mar 2007 13:12] Doug Gilbert

Description:
Running mysql-test-run.pl after initial pkg version install:

information_schema             [ fail ]

Errors are (from /usr2/mysql/mysql/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 Fri Mar  2 18:13:21 2007
--- r/information_schema.reject Fri Mar 23 16:04:59 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

How to repeat:
Run mysql-test-run.pl

[23 Mar 2007 13:59] Sveta Smirnova

Thank you for the report.

Verified as described.

Only community tree is affected.

[27 Mar 2007 13:00] Chad MILLER

This error can be safely ignored.  It's a rather silly test anyway; it's not verifying functionality, but emitting data that can and will change often.  It should probably be removed altogether.

FWIW, it's already fixed in patch for Bug#26600.

[27 Mar 2007 13:11] Doug Gilbert

Thanks!

[28 Oct 2007 20:45] Trudy Pelzer

Basically a duplicate of Bug #26600 "table PROFILING in INFORMATION SCHEMA h
as wrong data type", already fixed per Chad's comment.