BUG #1523: precision column value returned from getTypeInfo() always has value 9

Поиск
Список
Период
Сортировка
От Sergio Lob
Тема BUG #1523: precision column value returned from getTypeInfo() always has value 9
Дата
Msg-id 20050303212419.7046AF0D94@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #1523: precision column value returned from getTypeInfo()  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      1523
Logged by:          Sergio Lob
Email address:      sergio_lob@iwaysoftware.com
PostgreSQL version: 8.0.1
Operating system:   linux
Description:        precision column value returned from getTypeInfo()
always has value 9
Details:

After calling Connection.DatabaseMetaData.getTypeInfo() method, the
PRECISION column of the ResultSet seems hardcoded to value 9, which of
course in incorrect

To repro:
1. connect to a PostgresSQL JDBC data source
2. Invoke Connection.getMetaData() on that connection to get
DatabaseMetaData object
3. Invoke DataBaseMetaData.getTypeInfo() to get ResultSet  of all supported
data types
4. Invoke ResultSet.next() to get to first row
5. Invoke ResultSet.getString(3) to get PRECISION column value for current
row. Notice that no matter what row is checked in the answer set, precision
of data type is ALWAYS 9.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: relation "pg_user" does not exist
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: BUG #1523: precision column value returned from getTypeInfo()