On Sat, Mar 03, 2007 at 12:57:50PM +0100, Ingo Strüwing wrote:
> Hi David,
>
> Am Freitag, den 02.03.2007, 08:24 -0500 schrieb David Shrewsbury:
> > Also, in response to your other question, this bug
> > does not exist in 5.0. Apparently, this code was
> > reworked for 5.1.
>
> Good. In 5.1 table names don't have dots in them on the file system
> level. Please go ahead and create a table with a dot in its name. You'll
> see the name is recoded to avoid most special characters in the file
> name.
CREATE TABLE `#mysql50#dotted.table`(a INT);
I hope that this prefix won't be disabled, because doing so would make
it very hard to upgrade InnoDB tables to 5.1 format.
Regards,
Marko