Bug #14064 information_schema test fails on opnsrv6c
Submitted: 17 Oct 2005 9:11 Modified: 19 Oct 2005 3:45
Reporter: Ramil Kalimullin
Status: Closed
Category:Server Severity:S2 (Serious)
Version:5.0.15 OS:Other (SCO_SV)
Assigned to: Ramil Kalimullin Target Version:

[17 Oct 2005 9:11] Ramil Kalimullin 
Description:
12703: information_schema             [ fail ]
12704: 
12705: Errors are (from
/home/mysqldev/opnsrv6c/test/mysql-debug-5.0.15-sco-osr6-i686/mysql-test/var/log/mysqltest
-time) :
12706: mysqltest: At line 135906888: Result length mismatch
12707: (the last lines may be the most important ones)
12708: Below are the diffs between actual and expected results:
12709: -------------------------------------------------------
12710: *** r/information_schema.result Sun Oct 16 08:19:43 2005
12711: --- r/information_schema.reject Sun Oct 16 17:56:32 2005
12712: ***************
12713: *** 933,940 ****
12714:   from information_schema.columns
12715:   where table_name='t1';
12716:   column_name	data_type	CHARACTER_OCTET_LENGTH	CHARACTER_MAXIMUM_LENGTH
12717: ! f1	longblob	4294967295	4294967295
12718: ! f2	longtext	4294967295	4294967295
12719:   drop table t1;
12720:   create table t1(f1 tinyint, f2 SMALLINT, f3 mediumint, f4 int,
12721:   f5 BIGINT, f6 BIT, f7 bit(64));
12722: --- 933,940 ----
12723:   from information_schema.columns
12724:   where table_name='t1';
12725:   column_name	data_type	CHARACTER_OCTET_LENGTH	CHARACTER_MAXIMUM_LENGTH
12726: ! f1	longblob	9223372036854775807	4294967295
12727: ! f2	longtext	9223372036854775807	4294967295
12728:   drop table t1;
12729:   create table t1(f1 tinyint, f2 SMALLINT, f3 mediumint, f4 int,
12730:   f5 BIGINT, f6 BIT, f7 bit(64));
12731: -------------------------------------------------------

How to repeat:
run the test case.
[17 Oct 2005 10:58] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/31171
[18 Oct 2005 14:25] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/31212
[18 Oct 2005 14:50] Ramil Kalimullin 
fixed in 5.0.15
[19 Oct 2005 3:45] Paul DuBois 
Noted in 5.0.15 changelog.