(JDBC) KEY_SEQ in Foreign Key result set starts at 0, should be 1

Поиск
Список
Период
Сортировка
От David Goodenough
Тема (JDBC) KEY_SEQ in Foreign Key result set starts at 0, should be 1
Дата
Msg-id 200202151146.g1FBkBE37901@postgresql.org
обсуждение исходный текст
Список pgsql-bugs
Using the JDBC interface to inspect the metadata in a table, the
ResultSet returned from using DatabaseMetaData.getImportedKeys
includes values for KEY_SEQ.  This is an integer value and in the
case of Postgreql starts at zero.

I can find no formal definition of where this value should start
but the ODBC rules explicitly state that it should start at 1 and
both DB/2 and MySQL seem to agree.

To fix this line 2437 of jdbc2/DatabaseMetaData.java needs to be
changed from:-

short seq = 0;

to:-

short seq = 1;

The same change is required in jdbc1/DatabaseMetaData.java.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Srinivasa R Chava
Дата:
Сообщение: bugs
Следующее
От: "Detlef Plotzky"
Дата:
Сообщение: Bug with SQL-COPY in 7.2