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: | |
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
[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)