>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]