Yes, it is related to the quotes. I had the same with a table called "user" and a column named "security" which are reserved keywords on Derby but not on MySQL.
Am Donnerstag, 12. Juli 2007 schrieb V Narayanan: > 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 -- Mit freundlichen Grüßen Kurt Huwig (Vorstand) Telefon 0681/96751-50, Telefax 0681/96751-66 http://www.iku-ag.de/ iKu Systemhaus AG, Am Römerkastell 4, 66121 Saarbrücken Amtsgericht: Saarbrücken, HRB 13240 Vorstand: Kurt Huwig, Andreas Niederländer Aufsichtsratsvorsitzender: Jan Bankstahl GnuPG 1024D/99DD9468 64B1 0C5B 82BC E16E 8940 EB6D 4C32 F908 99DD 9468
pgpmFJGLxif3U.pgp
Description: PGP signature
