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

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

From
Thorsten Meinl
Date:
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




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

From
Kris Jurka
Date:

On Sat, 30 Nov 2002, Thorsten Meinl wrote:

> 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(...):
>
> [cut]
>
> 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?

This is a bug.  I have submitted a patch to repair this which will
hopefully be applied shortly.

Kris Jurka


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

From
Dave Cramer
Date:
Kris,

where did you submit the patch, patches? I guess I'm "it" while Barry is
away

Dave
On Mon, 2002-12-02 at 13:57, Kris Jurka wrote:
> On Sat, 30 Nov 2002, Thorsten Meinl wrote:
>
> > 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(...):
> >
> > [cut]
> >
> > 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?
>
> This is a bug.  I have submitted a patch to repair this which will
> hopefully be applied shortly.
>
> Kris Jurka
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Dave Cramer <Dave@micro-automation.net>


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

From
Kris Jurka
Date:
Yes,

http://fts.postgresql.org/db/mw/msg.html?mid=1359758


On 2 Dec 2002, Dave Cramer wrote:

> Kris,
>
> where did you submit the patch, patches? I guess I'm "it" while Barry is
> away
>
> Dave
> On Mon, 2002-12-02 at 13:57, Kris Jurka wrote:
> > On Sat, 30 Nov 2002, Thorsten Meinl wrote:
> >
> > > 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(...):
> > >
> > > [cut]
> > >
> > > 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?
> >
> > This is a bug.  I have submitted a patch to repair this which will
> > hopefully be applied shortly.
> >
> > Kris Jurka
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> --
> Dave Cramer <Dave@micro-automation.net>
>


Re: Bug in DatabaseMetaData.getColumns(...)?? Patch applied

From
Dave Cramer
Date:
This has been patched in the current sources

Dave
On Fri, 2002-11-29 at 18:01, Thorsten Meinl wrote:
> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Dave Cramer <Dave@micro-automation.net>