Bug #49267 innodb-autoinc.test fails on windows because of different case mode
Submitted: 1 Dec 2009 15:59 Modified: 19 Jun 2010 17:42
Reporter: Georgi Kodinov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious)
Version:Betony (M2), Celosia (M3) OS:Microsoft Windows
Assigned to: Vasil Dimov CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[1 Dec 2009 15:59] Georgi Kodinov
Description:
innodb-autoinc fails with the following error when run on a MS Windows host: 

main.innodb-autoinc                      [ exp-fail ]
        Test ended at 2009-11-30 12:55:44

CURRENT_TEST: main.innodb-autoinc
'diff' is not recognized as an internal or external command,
operable program or batch file.
--- G:/pb2/test/sb_1-1017284-1259579985.74/mysql-5.1.42-win-x86_64-test/mysql-test/r/innodb-autoinc.result	2009-11-30 14:06:49.000000000 +0300
+++ G:\pb2\test\sb_1-1017284-1259579985.74\mysql-5.1.42-win-x86_64-test\mysql-test\r\innodb-autoinc.reject	2009-11-30 14:55:44.690780700 +0300
@@ -1115,7 +1115,7 @@
 CREATE INDEX i1 on T1(c2);
 SHOW CREATE TABLE T1;
 Table	Create Table
-T1	CREATE TABLE `T1` (
+T1	CREATE TABLE `t1` (
   `c1` int(11) NOT NULL AUTO_INCREMENT,
   `c2` int(11) DEFAULT NULL,
   PRIMARY KEY (`c1`),
@@ -1128,13 +1128,13 @@
 DROP TABLE T1;
 DROP TABLE IF EXISTS T1;
 Warnings:
-Note	1051	Unknown table 'T1'
+Note	1051	Unknown table 't1'
 CREATE TABLE T1(C1 DOUBLE AUTO_INCREMENT KEY, C2 CHAR(10)) ENGINE=InnoDB;
 INSERT INTO T1(C1, C2) VALUES (1, 'innodb'), (3, 'innodb');
 INSERT INTO T1(C2) VALUES ('innodb');
 SHOW CREATE TABLE T1;
 Table	Create Table
-T1	CREATE TABLE `T1` (
+T1	CREATE TABLE `t1` (
   `C1` double NOT NULL AUTO_INCREMENT,
   `C2` char(10) DEFAULT NULL,
   PRIMARY KEY (`C1`)
@@ -1145,7 +1145,7 @@
 INSERT INTO T1(C2) VALUES ('innodb');
 SHOW CREATE TABLE T1;
 Table	Create Table
-T1	CREATE TABLE `T1` (
+T1	CREATE TABLE `t1` (
   `C1` float NOT NULL AUTO_INCREMENT,
   `C2` char(10) DEFAULT NULL,
   PRIMARY KEY (`C1`)

mysqltest: Result content mismatch

How to repeat:
Run innodb-autoinc.test on windows.

Suggested fix:
fix the test so its output is not dependent on the casemode.
[1 Dec 2009 16:02] Georgi Kodinov
Started happening after applying InnoDB Plugin 1.0.6 snapshot, part 2 (applied revisions: r6134, r6137, r6153)
mysql revision id in mysql-5.1-bugteam: satya.bn@sun.com-20091130105420-43di188meb3jo22x
[2 Dec 2009 7:04] Satya B
The testcases for BUG#47125 and BUG#49032 use Uppercase tablenames and Coulumn names which causes problem with SHOW CREATE TABLE output on windows.
[2 Dec 2009 7:12] 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/92383

3237 Satya B	2009-12-02
      Fix for BUG#49267 - innodb-autoinc.test fails on windows because of different case mode
      
      The testcases for BUG#47125 and BUG#49032 use Uppercase table names and Coulumn names which
      causes problem with SHOW CREATE TABLE output on windows.
      
      In windows the tables are in lowercase eventhough Uppercase table name is used for creating
      table.
      
      Fixed by using lowercase table names and column names.
[2 Dec 2009 9:46] 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/92410

3238 Satya B	2009-12-02
      Disable the test case innodb-autonic.test until BUG#49267 is fixed
      
      Add the test to disabled list and remove from the experimental list.
[2 Dec 2009 9:48] 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/92411

3238 Satya B	2009-12-02
      Disable the test case innodb-autonic.test until BUG#49267 is fixed
            
      Add the test to disabled list and remove from the experimental list.
[4 Dec 2009 10:55] 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/92854

2939 Alexey Kopytov	2009-12-04
      Disable the test case innodb-autonic.test until BUG#49267 is fixed
      
      Add the test to disabled list and remove from the experimental list.
[16 Dec 2009 8:39] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091216083311-xorsasf5kopjxshf) (version source revid:alik@sun.com-20091215065750-5m04ogppd5l0pol5) (merge vers: 6.0.14-alpha) (pib:14)
[16 Dec 2009 8:46] Bugs System
Pushed into 5.5.0-beta (revid:alik@sun.com-20091216082430-s0gtzibcgkv4pqul) (version source revid:alik@sun.com-20091204132603-mkgeu02qg6ifsrzs) (merge vers: 5.5.0-beta) (pib:14)
[16 Dec 2009 8:53] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20091216083231-rp8ecpnvkkbhtb27) (version source revid:alik@sun.com-20091212203859-fx4rx5uab47wwuzd) (merge vers: 5.6.0-beta) (pib:14)
[21 Dec 2009 10:12] 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/95187

3290 Satya B	2009-12-21
      Applying InnoDB snapshot 5.1-ss6344, part 1. Fixes BUG#49267
      
      Detailed revision comments:
      
      r6306 | calvin | 2009-12-14 15:12:46 +0200 (Mon, 14 Dec 2009) | 5 lines
      branches/5.1: fix bug#49267: innodb-autoinc.test fails on windows
      because of different case mode
      
      There is no change to the InnoDB code, only to fix test case by
      changing "T1" to "t1".
[23 Dec 2009 7:25] Satya B
patch queued to mysql-5.1-bugteam and NULL MERGED to mysql-pe
[15 Jan 2010 8:58] Bugs System
Pushed into 5.1.43 (revid:joro@sun.com-20100115085139-qkh0i0fpohd9u9p5) (version source revid:satya.bn@sun.com-20091221101138-g76odf50uidcir4s) (merge vers: 5.1.42) (pib:16)
[15 Jan 2010 18:40] Paul Dubois
Changes to test case. No changelog entry needed.
[5 Feb 2010 11:46] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100204063540-9czpdmpixi3iw2yb) (version source revid:alik@sun.com-20100119163614-172adculixyu26j5) (pib:16)
[5 Feb 2010 11:52] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100205113942-oqovjy0eoqbarn7i) (version source revid:alik@sun.com-20100204064210-ljwanqvrjs83s1gq) (merge vers: 6.0.14-alpha) (pib:16)
[5 Feb 2010 11:58] Bugs System
Pushed into 5.5.2-m2 (revid:alik@sun.com-20100203172258-1n5dsotny40yufxw) (version source revid:alexey.kopytov@sun.com-20091225091516-mbk3c41dhl1vunpo) (merge vers: 5.5.1-m2) (pib:16)
[5 Mar 2010 8:50] Alexander Nozdrin
The test case is still disabled in Betony(M2)/Celosia(M3).
[12 Mar 2010 14:13] Bugs System
Pushed into 5.1.44-ndb-7.0.14 (revid:jonas@mysql.com-20100312135944-t0z8s1da2orvl66x) (version source revid:jonas@mysql.com-20100312115609-woou0te4a6s4ae9y) (merge vers: 5.1.44-ndb-7.0.14) (pib:16)
[12 Mar 2010 14:29] Bugs System
Pushed into 5.1.44-ndb-6.2.19 (revid:jonas@mysql.com-20100312134846-tuqhd9w3tv4xgl3d) (version source revid:jonas@mysql.com-20100312060623-mx6407w2vx76h3by) (merge vers: 5.1.44-ndb-6.2.19) (pib:16)
[12 Mar 2010 14:45] Bugs System
Pushed into 5.1.44-ndb-6.3.33 (revid:jonas@mysql.com-20100312135724-xcw8vw2lu3mijrhn) (version source revid:jonas@mysql.com-20100312103652-snkltsd197l7q2yg) (merge vers: 5.1.44-ndb-6.3.33) (pib:16)
[6 Apr 2010 7:59] Bugs System
Pushed into 5.1.46 (revid:sergey.glukhov@sun.com-20100405111026-7kz1p8qlzglqgfmu) (version source revid:svoj@sun.com-20100401151005-c6re90vdvutln15d) (merge vers: 5.1.46) (pib:16)
[6 Apr 2010 21:04] Calvin Sun
Sergey - please remove this test from disabled.def, and close this bug.
[5 May 2010 15:15] Bugs System
Pushed into 5.1.47 (revid:joro@sun.com-20100505145753-ivlt4hclbrjy8eye) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[13 May 2010 16:50] Vasil Dimov
This test has been fixed.
[28 May 2010 5:49] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (pib:16)
[28 May 2010 6:18] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100524190941-nuudpx60if25wsvx) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[28 May 2010 6:46] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100524185725-c8k5q7v60i5nix3t) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[29 May 2010 15:36] Paul Dubois
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.
Re-closing.
[15 Jun 2010 8:14] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100615080459-smuswd9ooeywcxuc) (version source revid:mmakela@bk-internal.mysql.com-20100415070122-1nxji8ym4mao13ao) (merge vers: 5.1.47) (pib:16)
[15 Jun 2010 8:31] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100615080558-cw01bzdqr1bdmmec) (version source revid:mmakela@bk-internal.mysql.com-20100415070122-1nxji8ym4mao13ao) (pib:16)
[17 Jun 2010 11:49] Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 12:27] Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 13:15] Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)