BUG #14375: ODBC driver SQLDescibeCol always returns the column size 28

Started by Nonameover 9 years ago1 messagesbugs

son102yh@yahoo.ca

over 9 years ago

The following bug has been logged on the website:

Bug reference: 14375
Logged by: Son Nguyen
Email address: son102yh@yahoo.ca
PostgreSQL version: 9.5.4
Operating system: Windows
Description:

I have the following queries, SQLDescribeCol always returns columnSize of 28
for any literal greater than 30 digits.

select
123456789012345678901234567890,
1234567890123456789012345678901234567890
from T1

From ODBC Test tool,

1) SQLPrepare on the above query

2) SQLDescribe on 1, the output is
*ColumnName = "?column?", *NameLengthPtr = 8, *DataTypePtr = SQL_NUMERIC=2,
*ColumnSizePtr = 28, *DecimalDigits = 6,

SQLDescribe on 2, the output is
*ColumnName = "?column?", *NameLengthPtr = 8, *DataTypePtr = SQL_NUMERIC=2,
*ColumnSizePtr = 28, *DecimalDigits = 6, *NullablePtr = SQL_NULLABLE=1

While PostgreSQL 9.3 returns correct columnsize depending the number of
digits in the literal

Thanks

Son Nguyen

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs