Hi,
I however see the problem when I create the table enclosing the table
name in quotes,
which is expected.
ij> create table "simpletable"(i int);
0 rows inserted/updated/deleted
ij> select * from SIMPLETABLE;
ERROR 42X05: Table/View 'SIMPLETABLE' does not exist.
ij> select * from simpletable;
ERROR 42X05: Table/View 'SIMPLETABLE' does not exist.
ij>
Narayanan
John Baker wrote:
Hi,
Is there any known issue with executing queries of databases that have
table names in lowercase?
If I create a table with a lowercase name and execute
select * from abc
or
select * from ABC.abc
then the results are
Error code -1, SQL state 42X05: Table/View 'ABC' does not exist.
Line 1, column 1
Comparing to MSSQL Server, case doesn't matter.
I have a table named product
select * from DBO.product
or
select * from DBO.PRODUCT
both return all rows from product
Also, if I create a table ABCD in Derby then
select * from ABCD
returns the rows from ABCD.
If I enclose the lowercase table name in quotes then this works.
select * from "abc"
However, I don't want to enclose the tablename in quotes.
So, this appears to be a bug in Derby in SQL statements fail for a
table created with
a lowercase name.
- John
