Re: Case-preserving is not consistent

2001-08-22 Thread Tim Bunce
On Sun, Aug 19, 2001 at 10:21:46AM -0400, Philip Mak wrote: > On Sun, 19 Aug 2001, Sinisa Milivojevic wrote: > > > If this is happening on Windows, we truly can not do anything about > > it. > > > > You could help there by forcing all table names to be lower-case by > > starting mysql service wit

Re: Case-preserving is not consistent

2001-08-19 Thread Gerald R. Jensen
From: "Philip Mak" <[EMAIL PROTECTED]> To: "Sinisa Milivojevic" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, August 19, 2001 9:21 AM Subject: Re: Case-preserving is not consistent On Sun, 19 Aug 2001, Sinisa Mili

Re: Case-preserving is not consistent

2001-08-19 Thread Philip Mak
On Sun, 19 Aug 2001, Sinisa Milivojevic wrote: > If this is happening on Windows, we truly can not do anything about > it. > > You could help there by forcing all table names to be lower-case by > starting mysql service with a corresponding option. No, it's happening on Linux. Here's a transcrip

Re: Case-preserving is not consistent

2001-08-19 Thread Sinisa Milivojevic
Philip Mak writes: > On Sun, 19 Aug 2001, Lars Bruun Hansen wrote: > > > mysql> show tables from test; > > ++ > > | Tables_in_test | > > ++ > > | MyTable| > > ++ > > > > mysql> alter table MyTable add (y char(1)); > > mysql> show tables from

Re: Case-preserving is not consistent

2001-08-18 Thread Miguel Angel Solórzano
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 i

Re: Case-preserving is not consistent

2001-08-18 Thread Philip Mak
On Sun, 19 Aug 2001, Lars Bruun Hansen wrote: > mysql> show tables from test; > ++ > | Tables_in_test | > ++ > | MyTable| > ++ > > mysql> alter table MyTable add (y char(1)); > mysql> show tables from test; > ++ > | Tables_in

Case-preserving is not consistent

2001-08-18 Thread Lars Bruun Hansen
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 na