Bug #14065 tests containing 'show table status...' fail on opnsrv6c
Submitted: 17 Oct 2005 7:33 Modified: 18 Oct 2005 11:02
Reporter: Ramil Kalimullin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.15 OS:Other (SCO_SV)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[17 Oct 2005 7:33] Ramil Kalimullin
Description:
heap, information_schema, ps, ps_1general, show_check and view tests fail on opnsrv6c with the same symptoms, for instance:

12583: heap                           [ fail ]
12584: 
12585: Errors are (from /home/mysqldev/opnsrv6c/test/mysql-max-5.0.15-rc-sco-osr6/mysql-test/var/log/mysqltest-time) :
12586: mysqltest: At line 135784764: Result length mismatch
12587: (the last lines may be the most important ones)
12588: Below are the diffs between actual and expected results:
12589: -------------------------------------------------------
12590: *** r/heap.result Thu Oct 13 04:34:22 2005
12591: --- r/heap.reject Thu Oct 13 05:00:44 2005
12592: ***************
12593: *** 705,710 ****
12594:   create table t2 (c varchar(10)) engine=memory;
12595:   show table status like 't_';
12596:   Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
12597: ! t1	MEMORY	10	Fixed	0	11	0	#	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
12598: ! t2	MEMORY	10	Fixed	0	12	0	#	0	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
12599:   drop table t1, t2;
12600: --- 705,710 ----
12601:   create table t2 (c varchar(10)) engine=memory;
12602:   show table status like 't_';
12603:   Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
12604: ! t1	MEMORY	10	Fixed	0	11	-9223372036854775808	#	-9223372036854775808	-9223372036854775808	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
12605: ! t2	MEMORY	10	Fixed	0	12	-9223372036854775808	#	-9223372036854775808	-9223372036854775808	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
12606:   drop table t1, t2;
12607: -------------------------------------------------------

How to repeat:
run the tests on opnsrv6c.
[18 Oct 2005 10:41] Ramil Kalimullin
fixed in 5.0.15
[18 Oct 2005 11:02] Stefan Hinz
Added to 5.0.15 changelog (asked developer about version).