Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#109 DbMetaData column names in mixed case

open
nobody
None
5
2002-07-16
2002-07-16
Anonymous
No

DatabaseMetaData stores tables in lowercase, but
columns in mixed case. Not sure what the rule is.

storesLowerCaseIdentifiers=false
storesLowerCaseQuotedIdentifiers=false
storesMixedCaseIdentifiers=true
storesMixedCaseQuotedIdentifiers=false
storesUpperCaseIdentifiers=false
storesUpperCaseQuotedIdentifiers=false

Example:
create table MiXeD2(UPPER INT,lower int,MiXed1 int,
mIxEd2 int)
getTables: mixed
getColumns: mixed ; UPPER ; lower ; MiXed1 ; mIxEd2

should probably be something like (at least most other
databases do this):

storesLowerCaseIdentifiers=false
storesLowerCaseQuotedIdentifiers=false
storesMixedCaseIdentifiers=false
storesMixedCaseQuotedIdentifiers=TRUE
storesUpperCaseIdentifiers=TRUE
storesUpperCaseQuotedIdentifiers=false

And then the metadata calls should convert all the non-
quoted names to uppercase. The parameters have to be
case sensitive (no matter what is returned for stores...
methods).

This bug was found in the project LDBC
(http://ldbc.sourceforge.net)

Thomas

Discussion