Bug #32667 lowercase_table3.test reports to error log
Submitted: 23 Nov 2007 16:46 Modified: 14 Mar 2009 23:58
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Engine Severity:S7 (Test Cases)
Version:5.1.23 OS:Any
Assigned to: Patrick Crews CPU Architecture:Any
Tags: pbwarn

[23 Nov 2007 16:46] Ingo Strüwing
Description:
master.err: main.lowercase_table3: 071122 15:39:35 [ERROR] Cannot find or open table test/BUG29839 from

Disabling test case. Please re-enable after fix.

How to repeat:
See pushbuild, for example https://intranet.mysql.com/secure/pushbuild/showdir.pl?dir=mysql-5.1-engines
log https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-5.1-engines&entry=istruewi...
See also https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...
[28 Nov 2007 10:24] Bugs System
Pushed into 6.0.4-alpha
[28 Nov 2007 10:26] Bugs System
Pushed into 5.1.23-rc
[23 Jan 2009 1:39] Patrick Crews
It is possible that some other bug fixed this, but I am unable to duplicate the bug at this time.

lowercase_table3.test is enabled and passes without incident when run alone or as part of the full test suite on multiple runs.
[10 Feb 2009 23:05] 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/65825

2752 Patrick Crews	2009-02-10
      Bug#32667: lowercase_table3.test reports to error log
      
      Reordered FLUSH and DROP statements as this test was failing with the following warning:
      Warning: Table: ./test/t1 is open on delete.
      
      Also some minor cosmetic changes.
[10 Feb 2009 23:06] Patrick Crews
Re-opened this bug as I noticed the following warning was causing test failures when I was looking to re-enable the test:
Warning:  Table: ./test/t1 is open on delete
[11 Feb 2009 15:32] Matthias Leich
Hi Patrick,

the formal stuff:
1. CREATE TABLE t1 (a int);
   --> CREATE TABLE t1 (a INT);
2. IMHO the
   call mtr.add_suppression("Cannot find or open table test/BUG29839 from");
   should be placed direct before the one and only
   position where it is needed and useful means before
   SELECT * from BUG29839;

Regarding the t1/T1 and lower_case_table_names = 0
--------------------------------------------------
IMHO the description within the manual is too
short in case of "lower_case_table_names = 0"
meets case insensitive filesystem.
My guess about lower_case_table_names = 0:
In whatever statement a table name is given the server
does not do any conversion (upper/lower case) when
translating this to a filename. But of course the
filesystem layer of the OS could do a translation.

"Name comparisons are case sensitive." means most
probably that for example the optimizer is not allowed
to assume "T1" and "t1" are the same table and to do
some corresponding optimizations.

I was unable to run the test on my Linux box with
case sensitive filesystems.

Ok to push
[13 Feb 2009 21:13] 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/66301

2797 Patrick Crews	2009-02-13
      BUG#32667: lowercase_table3.test reports to error log
      
      Cleaned up SQL code in the test.
      Needed to move the FLUSH TABLES statement prior to the DROP TABLE t1 to prevent a warning of
      Table open on delete and a test fail.
[19 Feb 2009 13:03] Bugs System
Pushed into 6.0.10-alpha (revid:sergey.glukhov@sun.com-20090218125737-5y5b2xo3duo1wlvo) (version source revid:patrick.crews@sun.com-20090214225411-80r6c064s3cx9u83) (merge vers: 6.0.10-alpha) (pib:6)
[27 Feb 2009 20:14] Paul DuBois
Test case changes. No changelog entry needed.

Setting report to NDI pending push into 5.1.x.
[13 Mar 2009 19:05] Bugs System
Pushed into 5.1.33 (revid:joro@sun.com-20090313111355-7bsi1hgkvrg8pdds) (version source revid:vvaintroub@mysql.com-20090218093153-sjzxf01i4ezte0xp) (merge vers: 5.1.33) (pib:6)
[14 Mar 2009 23:58] Paul DuBois
Test case changes. No changelog entry needed.
[9 May 2009 16:43] Bugs System
Pushed into 5.1.34-ndb-6.2.18 (revid:jonas@mysql.com-20090508185236-p9b3as7qyauybefl) (version source revid:jonas@mysql.com-20090508100057-30ote4xggi4nq14v) (merge vers: 5.1.33-ndb-6.2.18) (pib:6)
[9 May 2009 17:40] Bugs System
Pushed into 5.1.34-ndb-6.3.25 (revid:jonas@mysql.com-20090509063138-1u3q3v09wnn2txyt) (version source revid:jonas@mysql.com-20090508175813-s6yele2z3oh6o99z) (merge vers: 5.1.33-ndb-6.3.25) (pib:6)
[9 May 2009 18:38] Bugs System
Pushed into 5.1.34-ndb-7.0.6 (revid:jonas@mysql.com-20090509154927-im9a7g846c6u1hzc) (version source revid:jonas@mysql.com-20090509073226-09bljakh9eppogec) (merge vers: 5.1.33-ndb-7.0.6) (pib:6)