Hi,
first of all: I'm currently not reading this mailing list,
so if you answer I would be happy to receive a Cc:
I'm currently trying to switch a web site on a complete
new machine. The old machine was runnig MySQL 3.22.32,
the new machine runs on 3.23.49
The application used Phorum for generating a web based forum
for each article. Table name was a md5() string in order
to get a unique table name for each forum.
I dumped the whole database and tried to read it via
mysql command line tool on the new machine.
Some tables were created correctly:
| 002ace3219ab50ab4d277e7357355f25 |
| 002ace3219ab50ab4d277e7357355f25_bodies |
| 00bcd73fc818f7b57c48ce8d140dab70 |
| 00bcd73fc818f7b57c48ce8d140dab70_bodies |
| 00bcd73fc818f7b57c48ce8d140dab70_seq |
But with one table (table structure the same as the
above tables) MySQL reported error 1064:
table name: 021e0a5d20e6bf8211cfe55bd003a7c2
First of all I've seen no difference to the above
table names which were created correctly. Then I tried
to use
ph_021e0a5d20e6bf8211cfe55bd003a7c2
as table name, and everything was okay. But this is only
a workaround, so I tried to look up into the docs regarding
legal naming conventions. It seemed to be correct as the
documentation said that everything with digits and chars
is okay.
But then I saw:
> It is recommended that you do not use names like 1e, because an expression
> like 1e+1 is ambiguous. It may be interpreted as the expression 1e + 1 or as
> the number 1e+1.
and saw that the table name which was not working has had
an "e" as the 4th character:
021e0a5d20e6bf8211cfe55bd003a7c2
^
I changed the "e" to an a:
021a0a5d20e6bf8211cfe55bd003a7c2
and everything worked fine.
So, my questions:
1.) is this a bug? Regarding the passage in the documentation I thought
only table names like "1e" or "2e" are not correct
2.) why does MySQL think in 1e dimensions when having
021e0a5d20e6bf8211cfe55bd003a7c2 as a table name?
3.) if it is not a bug, should the documentation be extended?
4.) where am I wrong with my thoughts?
5.) if I'm not wrong, what can I do besides changing the table
name to prefix_md5?
TIA, Björn.
--
PHP-Support * realitätsnahe Performance-Messungen mit Code-Analyse
Webapplikationsentwicklung * PHP-Schulungen * Consulting
0700-THINKPHP -*- [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
