Bug #45730 Test case disabled in show_check.test due to WL#1324
Submitted: 24 Jun 2009 19:13 Modified: 28 Jan 2011 15:46
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.4 OS:Any
Assigned to: John Embretsen CPU Architecture:Any
Tags: disabled

[24 Jun 2009 19:13] Alexander Nozdrin
WL#1324 is complete, but show_check.test contains:

# This test fails on MAC OSX, so it is temporary disabled.
# This needs WL#1324 to be done.
#set names latin1;
#create database `ä`;
#create table `ä`.`ä` (a int) engine=heap;
#--replace_column 7 # 8 # 9 #
#show table status from `ä` LIKE 'ä';
#drop database `ä`;

How to repeat:
[20 Dec 2010 8:59] John Embretsen
Another subtest that probably should be enabled:

# Bug#4374 SHOW TABLE STATUS FROM ignores collation_connection
#set names latin1;
#create database `�`;
#create table `�`.`�` (a int) engine=heap;
#--replace_column 7 # 8 # 9 #
#show table status from `�` LIKE '�';
#drop database `�`;

Commit comment for revid sp1r-serg@serg.mylan-20040726192059-43811 which commented out the subtest:

"one more test should wait for WL#1324 (tablename to filename encoding)
non-ascii filenames work weird (e.g. on MacOSX)"
[20 Dec 2010 9:21] John Embretsen
Doh, it is basically the same test, except with slightly different non-ASCII characters. The latter one should probably just be removed.
[20 Dec 2010 11:42] John Embretsen
I will defer commits for this issue until fix for Bug#58414 is pushed (currently Patch Approved), to avoid potential conflicts (touches the same files).
[12 Jan 2011 15:35] 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:

[14 Jan 2011 10:52] Alexander Barkov
http://lists.mysql.com/commits/128530 is Ok to push.
[17 Jan 2011 7:16] Bugs System
Pushed into mysql-trunk 5.6.2 (revid:john.embretsen@oracle.com-20110117071427-u0y6dmgbuhc00uo8) (version source revid:john.embretsen@oracle.com-20110117071427-u0y6dmgbuhc00uo8) (merge vers: 5.6.2) (pib:24)
[17 Jan 2011 7:16] Bugs System
Pushed into mysql-5.5 5.5.10 (revid:john.embretsen@oracle.com-20110117071238-kez2rfgsujofb9os) (version source revid:john.embretsen@oracle.com-20110117071238-kez2rfgsujofb9os) (merge vers: 5.5.10) (pib:24)
[18 Jan 2011 8:05] John Embretsen
Test fails intermittently on Windows and FreeBSD x86 debug_max:

CURRENT_TEST: main.show_check
--- /export/home2/pb2/test/sb_1-2828373-1295254349.49/mysql-5.5.10-freebsd7.0-i386-test/mysql-test/r/show_check.result	2011-01-17 10:38:49.000000000 +0300
+++ /export/home2/pb2/test/sb_1-2828373-1295254349.49/mysql-5.5.10-freebsd7.0-i386-test/mysql-test/r/show_check.reject	2011-01-17 12:13:47.000000000 +0300
@@ -1334,7 +1334,7 @@
 CREATE TABLE `ä`.`ä` (a int) ENGINE=Memory;
 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
-ä	MEMORY	10	Fixed	0	8	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
+ä	MEMORY	10	Fixed	0	5	#	#	#	0	NULL	NULL	NULL	NULL	latin1_swedish_ci	NULL		
 show columns from `#mysql50#????????`;
 Got one of the listed errors

mysqltest: Result content mismatch
[18 Jan 2011 8:38] John Embretsen
Looks like "Avg_row_length" varies, so the fix will be to mask that out along with the other already masked out values.
[18 Jan 2011 14:40] Bugs System
Pushed into mysql-trunk 5.6.2 (revid:john.embretsen@oracle.com-20110118130935-dfwm3owvzej26cif) (version source revid:john.embretsen@oracle.com-20110118130935-dfwm3owvzej26cif) (merge vers: 5.6.2) (pib:24)
[18 Jan 2011 19:36] John Embretsen
Follow-up fix pushed to mysql-5.5 as revid john.embretsen@oracle.com-20110118120417-bu3cpzne4myzmmvj, although with wrong bug number (45740) in the commit comment. Merged to mysql-trunk.
[28 Jan 2011 15:46] Paul DuBois
Changes to test suite. No changelog entry needed.