MySQL 5.0.37 - Failing the test(s): information_schema
Hi,
Running "./mysql-test-run.pl --do-test information_schema" result :
information_schema [ fail ]
Errors are (from /tmp/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 2007-03-05 22:40:30.000000000 +0300
--- r/information_schema.reject 2007-03-09 13:17:21.000000000 +0300
***************
*** 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
-------------------------------------------------------
All the others tests succeed.
It seems it's not a bug, as INFORMATION_SCHEMA.PROFILING is a new table in this version. Is this test need to be updated ?
Regards.