lower_case_table_names not working for SELECT

[Hans Maurer]

>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 column names in its SELECT statements to uppercase.

Since MySQL is case-sensitive on Unix, I added the statement
set-variable = lower_case_tabl e_names=1
to /etc/my.cnf. However, statements like
SELECT COLUMN FROM TABLE;
still fail with error 1146, while
SELECT COLUMN FROM table
works. It seems that lower_case_tabl e_names is not utilized in SELECT
(and probably other) statements.[color=blue]
>How-To-Repeat:[/color]
Create a table with lower-case name, activate lower_case_tabl e_names=1,
try to access the table in upper-case with SELECT statement.[color=blue]
>Fix:[/color]
Support lower_case_tabl e_names for SELECT statments, too.
[color=blue]
>Submitter-Id: <submitter ID>
>Originator: Hans Maurer
>Organization : amasol AG
>
>MySQL support: none
>Synopsis: lower_case_tabl e_names not working for SELECT
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Source distribution)[/color]
[color=blue]
>Environment:[/color]

System: FreeBSD mrburns.amasol. de 4.8-STABLE FreeBSD 4.8-STABLE #12: Sun Aug
17 12:24:50 CEST 2003
root@mrburns.am asol.de:/usr/obj/usr/src/sys/GENERIC i386


Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.4 20020320 [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe' CXX='c++' CXXFLAGS='-O -pipe
-felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1224554 Aug 17 21:52 /usr/lib/libc.a
lrwxrwxr-x 1 root wheel 9 Aug 17 21:52 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 578880 Aug 17 21:52 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/var/db/mysql --without-perl
--without-debug --without-readline --without-bench --with-mit-threads=no
--with-libwrap --with-low-memory --enable-assembler --prefix=/usr/local
i386--freebsd4.2
Perl: This is perl, version 5.005_03 built for i386-freebsd

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=ThemC@bp.com


_______________ _______________ _______________ _______________ ____________
This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit

http://www.messagelabs.com

_______________ _______________ _______________ _______________ ____________

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw