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
[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: http://lists.mysql.com/commits/128530
[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; SHOW TABLE STATUS FROM `ä` LIKE 'ä'; 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 DROP DATABASE `ä`; 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.