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

From: son102yh(at)yahoo(dot)ca
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14375: ODBC driver SQLDescibeCol always returns the column size 28
Date: 2016-10-17 18:39:57
Message-ID: 20161017183957.1413.77656@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14375
Logged by: Son Nguyen
Email address: son102yh(at)yahoo(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message thomastrovon 2016-10-17 19:24:36 BUG #14376: How stop/cancel/break/quit the "process watcher - restoring backup on the server"
Previous Message Tom Lane 2016-10-17 18:03:03 Re: BUG #14374: psql.exe command options \dtvs produces a database list, not table/view/sequences.