JDBC driver converts search string patterns to lowercase - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject JDBC driver converts search string patterns to lowercase
Date
Msg-id 200108142247.f7EMlGH74145@hub.org
Whole thread Raw
List pgsql-bugs
Bjorn Peterson (petbjo@bethel.edu) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
JDBC driver converts search string patterns to lowercase

Long Description
The metadata class of the Postgresql 7.1 JDBC driver converts search string patterns to all lowercase.  This means that
ifI want to use metadata.getColumns(null,null,tableName,"%") for example, the tableName will be converted to all
lowercase,and will not match if my table names have any capital letters.  I tried quoting the table names, but that
didn'twork either.  I see no reason for the names to be converted to lower case, and it is extremely inconvenient to
codea work-around for this. 

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: -ltermcap needed for psql client build on OpenBSD 2.9
Next
From: Peter Eisentraut
Date:
Subject: Re: -ltermcap needed for psql client build on OpenBSD 2.9