>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_table_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_table_names is not utilized in SELECT
(and probably other) statements.
>How-To-Repeat:
Create a table with lower-case name, activate lower_case_table_names=1,
try to access the table in upper-case with SELECT statement.
>Fix:
Support lower_case_table_names for SELECT statments, too.
>Submitter-Id: <submitter ID>
>Originator: 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 distribution)
>Environment:
System: FreeBSD mrburns.amasol.de 4.8-STABLE FreeBSD 4.8-STABLE #12: Sun Aug 17
12:24:50 CEST 2003 [EMAIL PROTECTED]:/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/[EMAIL PROTECTED]
