Re: lower_case_table_names not working for SELECT

2003-08-21 Thread Victoria Reznichenko
Hans Maurer <[EMAIL PROTECTED]> wrote: >>Description: > We're running our current TTS application with MySQL (on Unix). All database, > table and column names are in lower-case. However, we need to access this > database with a new application which (for some reason) converts all > table and colu

lower_case_table_names not working for SELECT

2003-08-21 Thread Hans Maurer
ator:Hans Maurer >Organization: amasol AG > >MySQL support: none >Synopsis: lower_case_table_names not working for SELECT >Severity: non-critical >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.32 (Source distri

lower_case_table_names not working?

2001-11-30 Thread Shankar Unni
OK, so I'm on a slightly older version for this experiment (3.23.36).. I tried restarting mysqld with the line set=lower_case_table_names=1 in my my.cnf (on RedHat 7.1), and have a table called "ipaddr" in my database (the files are ipaddr.frm, ipaddr.MYD and ipaddr.MYI). (I have verified