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
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. |