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