Hi Marko,
Marko Mäkelä schrieb:
> On Sat, Mar 03, 2007 at 12:57:50PM +0100, Ingo Strüwing wrote:
...
>> 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);
Yes. You are right. I didn't think of the "#mysql50#" prefix.
This is to allow creating tables with the file name convention of 5.0.
And indeed we should also be able to handle old tables.
So I do now agree with the initial patch, provided that MY_REPLACE_EXT
does indeed replace arbitrary strings starting at the last dot. (I
didn't check it.)
> 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.
Yes, I agree. Thanks for remembering me of this.
Regards
Ingo
--
Ingo Strüwing, Senior Software Developer
MySQL GmbH, Radlkoferstr. 2, D-81373 München
Geschäftsführer: Hans von Bell, Kaj Arnö - HRB München 162140
