At 04:23 19/08/2001 -0700, Lars Bruun Hansen wrote:
Hi,
This behavior is fixed in the release 3.23.41. Into
the next 6 hours I will send the distribution files
for our Web master, so maybe at Monday or Tuesday
you can get it from our download page.
Take a look in the printed samples below, how is
the new behavior having lower_case_table_names=0.
Microsoft Windows 2000 [Versăo 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
c:\mysql\bin>mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.41-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create table MyTable (x char(1));
Query OK, 0 rows affected (0.02 sec)
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| MyTable |
+----------------+
1 row in set (0.00 sec)
mysql> alter table MyTable add (y char(1));
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| MyTable |
+----------------+
1 row in set (0.00 sec)
mysql> alter table MyTaBLE add (z char(1));
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| MyTaBLE |
+----------------+
1 row in set (0.00 sec)
mysql>
Regards,
Miguel
>Version: MySQL v. 3.23.40 (Windows NT)
>
>Hello,
>
>I would like MySQL to preserve the case of my table names and therefore I
>have set
>lower_case_table_names=0 in my configuration. I use Windows NT.
>
>This works fine for CREATE TABLE statements but the moment I use a ALTER
>TABLE statement the name of the table will be converted to lowercase. My
>conclusion is that CREATE TABLE respects lower_case_table_names but ALTER
>TABLE does not and this seems like a bug to me?
>
>See example:
>
>
>mysql> create table MyTable (x char(1));
>mysql> show tables from test;
>+----------------+
>| Tables_in_test |
>+----------------+
>| MyTable |
>+----------------+
>
>mysql> alter table MyTable add (y char(1));
>mysql> show tables from test;
>+----------------+
>| Tables_in_test |
>+----------------+
>| mytable |
>+----------------+
>
>If this is not a bug how do I then get MySQL to be case-preserving for the
>table names?
>
>Hope somebody can help.
>
>Lars Bruun Hansen
>Denmark
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil
<___/ www.mysql.com
---------------------------------------------------------------------
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
