469,592 Members | 2,026 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,592 developers. It's quick & easy.

lower_case_table_names not working for SELECT

>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
ro**@mrburns.amasol.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/my***************@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/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 3169

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by worldcyclist | last post: by
reply views Thread by Hans Maurer | last post: by
2 posts views Thread by Martin | last post: by
4 posts views Thread by Elroyskimms | last post: by
17 posts views Thread by kalamos | last post: by
10 posts views Thread by bsn | last post: by
5 posts views Thread by RioRanchoMan | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.