Re: DatabaseMetaData - schemaPattern

On Sat, Nov 23, 2013 at 3:47 PM, Kevin Wooten <kdubb@me.com> wrote:

In pgjdbc,  I believe the DatabaseMetaData code is incorrectly handling the schemaPattern.

According to the interface docs, an empty schemaPattern should retrieve “those without a schema”. While null means "the schemaPattern should not be used to narrow the search”.  This same info appears for any schemaPattern in any method of the interface (http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html).

All through AbstractJdbc2DatabaseMetaData.java, anywhere schemaPattern appears, you’ll see code like this:

if (schemaPattern != null && !"".equals(schemaPattern))
{
    sql += ...
}

It seems these should simply be null checks only.  Does that seem like the correct interpretation?

-kw

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc