Bug in DatabaseMetaData.getColumns(...)??
От | Thorsten Meinl |
---|---|
Тема | Bug in DatabaseMetaData.getColumns(...)?? |
Дата | |
Msg-id | 3DE7F1C9.8070806@meinl.bnv-bamberg.de обсуждение исходный текст |
Ответы |
Re: Bug in DatabaseMetaData.getColumns(...)??
Re: Bug in DatabaseMetaData.getColumns(...)?? Patch applied |
Список | 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
В списке pgsql-jdbc по дате отправления: