Hello, I am using MySql-5.0.21 on Suse-Linux-10, i created tables using lowercase names for example ; mysql> create table a (id int); Query OK, 0 rows affected (0.04 sec)
mysql> select * from A; ERROR 1146 (42S02): Table 'mysql.A' doesn't exist mysql> select * from a; Empty set (0.01 sec) I have upgraded from mysql-4.0.17 to 5.0.21 ,and all the ANSI-SQL queries from my application using UPPERCASE table names are bombing, i immediately had to stop 5.0.21 and restart mysql-4.0.17. Is there any way to get around this problem and have a smooth upgrade. Regards Digz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
