BUG #14377: ODBC SQLDescribeCol always returns decimal digit 6

From: son102yh(at)yahoo(dot)ca
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14377: ODBC SQLDescribeCol always returns decimal digit 6
Date: 2016-10-17 19:39:24
Message-ID: 20161017193924.1413.88883@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: 14377
Logged by: Son Nguyen
Email address: son102yh(at)yahoo(dot)ca
PostgreSQL version: 9.5.4
Operating system: Windows
Description:

Hi,

I have the query below, the output data type is SQL_NUMBER with scale of 6,
but the actual decimal value beyond 6

Thanks

Son Nguyen
From ODBC Test tool
select ( ( 1 * 1.0e0 ) /256 )from "T1"
The output value is 0.00781250000000000000,
but SQLDescribeCol returns column size 28, and decimal digit only 6

1) SQLPrepare with the query above
2) SQLDescribeCol
Out: *ColumnName = "?column?", *NameLengthPtr = 8, *DataTypePtr =
SQL_NUMERIC=2, *ColumnSizePtr = 28, *DecimalDigits = 6,

Expected decimalDigits should be 7.

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2016-10-18 00:01:43 Re: BUG #14376: How stop/cancel/break/quit the "process watcher - restoring backup on the server"
Previous Message thomastrovon 2016-10-17 19:24:36 BUG #14376: How stop/cancel/break/quit the "process watcher - restoring backup on the server"