| Subject: | Creating a key named user(length) |
Hello,
MySQL has a (mis)feature that it allows to use field names which are also function names. This is problematic if using a field name like "user" and using this in a key definition with a length, e.g.
KEY something (user(length))
This will choke if piped to the mysql client program. Instead one has to write
KEY something (user (length))
(note the additional space). It would be nice if mysqldiff and
related modules would add this space automatically, either for fields
which match a known list of functions or for all field names.
mysqldump seems to provide the wrong results, too.
Here's another link for this problem:
http://groups.google.de/groups?hl=de&lr=&ie=UTF-8&th=d5913f7a4be1cf91&seekm=aabeof%242blb%241%40FreeBSD.csie.NCTU.edu.tw&frame=off
Regards,
Slaven