db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From V Narayanan <V.Naraya...@Sun.COM>
Subject Re: Bug with lowercase table name ?
Date Thu, 12 Jul 2007 06:17:19 GMT
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
>>   


Mime
View raw message