Bug in DatabaseMetaData.getColumns(...)??

From: Thorsten Meinl <Thorsten(at)meinl(dot)bnv-bamberg(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Bug in DatabaseMetaData.getColumns(...)??
Date: 2002-11-29 23:01:29
Message-ID: 3DE7F1C9.8070806@meinl.bnv-bamberg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

I just downloaded the new 7.3 release of PostgreSQL and also tried the
new JDBC-drivers shipped with the release. And I have problems with the
new driver.
The Java-API says for the function DatabaseMetaData.getColumns(...):

<snip>
Retrieves a description of table columns available in the specified
catalog.

Only column descriptions matching the catalog, schema, table and column
name criteria are returned. They are ordered by |TABLE_SCHEM|,
|TABLE_NAME|, and |ORDINAL_POSITION|.
</snip>

Looking in org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java I
find in line 2312 in getColumns(...)

<snip>
sql += " ORDER BY nspname,relname,attname ";
</snip>

So the order is wrong, the columns or sorted by their name and not by
their position in the table-defintion. This broke my code.
Is this a bug or an intended feature?

Greetings

Thorsten

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Fernando Nasser 2002-11-29 23:59:13 Re: Redhat 8 default database warning: JDBC problems (CLARIFICATION)
Previous Message Michael Ansley 2002-11-29 19:35:22 Re: JDBC for DataSource and Connection Pooling