Bug #18736 test case 'upgrade' fails
Submitted: 3 Apr 2006 13:47 Modified: 14 Apr 2006 13:10
Reporter: Kristian Nielsen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.9 OS:Windows (Windows, OSX)
Assigned to: Alexander Barkov CPU Architecture:Any

[3 Apr 2006 13:47] Kristian Nielsen
Description:
The testcase 'upgrade' fails on Windows and Mac OSX in 5.1:

upgrade                        [ fail ]

Errors are (from /Users/mysqldev/pb/mysql-5.1-new/push-knielsen@mysql.com-20060403110519.info/mysql-5.1.9-beta-standard/mysql-test/var-n_stm-5/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/upgrade.result	Mon Apr  3 12:22:54 2006
--- r/upgrade.reject	Mon Apr  3 14:11:15 2006
***************
*** 46,52 ****
  create table `txu#P#p1` (s1 int);
  insert into `txu#P#p1` values (1);
  select * from `txu@0023P@0023p1`;
! ERROR 42S02: Table 'test.txu@0023P@0023p1' doesn't exist
  create table `txu@0023P@0023p1` (s1 int);
  insert into `txu@0023P@0023p1` values (2);
  select * from `txu@0023P@0023p1`;
--- 46,52 ----
  create table `txu#P#p1` (s1 int);
  insert into `txu#P#p1` values (1);
  select * from `txu@0023P@0023p1`;
! ERROR 42S02: Table 'test.txu@0023p@0023p1' doesn't exist
  create table `txu@0023P@0023p1` (s1 int);
  insert into `txu@0023P@0023p1` values (2);
  select * from `txu@0023P@0023p1`;
-------------------------------------------------------

How to repeat:
perl mysql-test-run.pl upgrade

(on Windows or OSX only).

Suggested fix:
It looks very much like this is related to the use of case-insensitive file systems. Not sure if it shows a bug in the server, or just a bug in the testcase.
[10 Apr 2006 20:10] Brian Pontz
Assigning to test creator and raising priority as this happens in 5.1.9-pre
[12 Apr 2006 9:52] 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/4845
[12 Apr 2006 9:58] Alexander Barkov
Fixed in 5.1.10
[12 Apr 2006 20:42] Paul DuBois
No changelog entry needed.