behavior of getTables() wrt capitalization of type

From: "brian zimmer" <bzimmer(at)ziclix(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: behavior of getTables() wrt capitalization of type
Date: 2002-01-09 06:54:15
Message-ID: 001a01c198da$79dec6a0$6401a8c0@mountain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

There seems to be a bug in DatabaseMetaData.getTables() with respect to
the capitalization of the values in the 'types' array. I apologize for
not having the latest source, but I looked at some slightly older source
and found that there is an static final array of types (VIEW, TABLE,
...) and the corresponding sql clause to query it. When the type values
are capitalized all works fine, but if they are not then the exception
below occurs. It seems as though each value in the types array should
be capitalized when doing the comparison with the values in the static
final array.

I tried figuring it out dynamically through the various supports*() and
stores*() methods on DMD but only supportsMixedCaseIdentifiers()
returned true and from my testing this does not seem to be the case. I
did download and test with the latest developer snapshot but the same
bug occurs.

Results from running the enclosed test case:

Attempting type [TABLE]
table: zxtesting
SUCCESS with type [TABLE]

Attempting type [table]
ERROR: parser: parse error at or near ")"
FAILURE with type [table]

thanks,

brian

Attachment Content-Type Size
PGTest.java application/octet-stream 1.2 KB

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-01-09 14:14:15 Re: behavior of getTables() wrt capitalization of type
Previous Message Nick Fankhauser 2002-01-08 23:54:35 Re: The backend has broken the connection...