Bug #11809 ps_1general.test fails on QNX
Submitted: 8 Jul 2005 7:17 Modified: 18 Jul 2005 20:23
Reporter: Ramil Kalimullin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.9 OS:Other (QNX 6.2.1)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[8 Jul 2005 7:17] Ramil Kalimullin
Description:
ps_1general.test fails on QNX

ps_1general                     [ fail ]
10272: Errors are (from /home/mysqldev/buildqnx2/test/mysql-debug-5.0.9-beta-nto-qnx6.2.1-i386/mysql-test/var/log/mysqltest-time) :
10273: /home/mysqldev/buildqnx2/test/mysql-debug-5.0.9-beta-nto-qnx6.2.1-i386/bin/mysqltest: At line 935: Result length mismatch
10274: (the last lines may be the most important ones)
10275: Below are the diffs between actual and expected results:
10276: -------------------------------------------------------
10277: *** r/ps_1general.result	Thu Jul  7 10:45:48 2005
10278: --- r/ps_1general.reject	Thu Jul  7 19:14:07 2005
10279: ***************
10280: *** 290,300 ****
10281:   prepare stmt4 from ' show table status from test like ''t2%'' ';
10282:   execute stmt4;
10283:   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
10284: ! t2	MyISAM	10	Fixed	0	0	0	4222124650659839	1024	0	NULL	#	#	#	latin1_swedish_ci	NULL		
10285:   prepare stmt4 from ' show table status from test like ''t9%'' ';
10286:   execute stmt4;
10287:   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
10288: ! t9	MyISAM	10	Dynamic	2	216	432	281474976710655	2048	0	NULL	#	#	#	latin1_swedish_ci	NULL		
10289:   prepare stmt4 from ' show status like ''Threads_running'' ';
10290:   execute stmt4;
10291:   Variable_name	Value
10292: --- 290,300 ----
10293:   prepare stmt4 from ' show table status from test like ''t2%'' ';
10294:   execute stmt4;
10295:   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
10296: ! t2	MyISAM	10	Fixed	0	0	0	64424509439	1024	0	NULL	#	#	#	latin1_swedish_ci	NULL		
10297:   prepare stmt4 from ' show table status from test like ''t9%'' ';
10298:   execute stmt4;
10299:   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
10300: ! t9	MyISAM	10	Dynamic	2	216	432	4294967295	2048	0	NULL	#	#	#	latin1_swedish_ci	NULL		
10301:   prepare stmt4 from ' show status like ''Threads_running'' ';
10302:   execute stmt4;
10303:   Variable_name	Value
10304: -------------------------------------------------------

How to repeat:
run the test
[8 Jul 2005 7:53] 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/26804
[8 Jul 2005 8:29] Ramil Kalimullin
fixed in 5.0.9
[18 Jul 2005 20:23] Paul DuBois
No changelog entry needed.