"Bluemel, Marco" <[EMAIL PROTECTED]> wrote:
> I have a problem with mysql 4.0.18 on WindowsXP
> I set the lower_case_table_names=2 as it is mentioned for windows
> t the mysql website.
>
> (before I'm using version 4.0.15 and had set it to 0)
> so the tablenames should be stored in this case as I wrote it.
>
> So I create a table in Java with an index (this is only a part of the
> table)
>
> String sql = "";
> sql += "CREATE TABLE AB_OBJECTS";
> sql += "(";
> sql += "id INTEGER PRIMARY KEY,";
> sql += "objectId INTEGER NOT NULL,";
> sql += ")";
> _statement.execute(sql);
> _statement.execute("CREATE INDEX ab_object_objectid_index ON
> AB_OBJECTS(objectId) ");
> the problem is that the table is created in lower cases as 'ab_objects'
>
> but if I don't create the index, only the table, its created in upper
> case 'AB_OBJECTS' as it should be.
>
> I have some other tables with and without an index and all should be
> stored in upper case.
Thank you for report!
This bug is already entered to the bug database:
http://bugs.mysql.com/bug.php?id=3109
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
