| Bug #32667 | lowercase_table3.test reports to error log | ||
|---|---|---|---|
| Submitted: | 23 Nov 2007 17:46 | Modified: | 15 Mar 0:58 |
| Reporter: | Ingo Strüwing | ||
| Status: | Closed | ||
| Category: | Tests: Engine | Severity: | S2 (Serious) |
| Version: | 5.1.23 | OS: | Any |
| Assigned to: | Patrick Crews | Target Version: | 5.1+ |
| Tags: | pbwarn | ||
| Triage: | D3 (Medium) | ||
[23 Nov 2007 17:46]
Ingo Strüwing
[28 Nov 2007 11:24]
Bugs System
Pushed into 6.0.4-alpha
[28 Nov 2007 11:26]
Bugs System
Pushed into 5.1.23-rc
[23 Jan 2: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.
[11 Feb 0: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.
[11 Feb 0: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 16: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 22: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 14: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 21:14]
Paul DuBois
Test case changes. No changelog entry needed. Setting report to NDI pending push into 5.1.x.
[13 Mar 20: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)
[15 Mar 0:58]
Paul DuBois
Test case changes. No changelog entry needed.
[9 May 18: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 19: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 20: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)
