BUG #14377: ODBC SQLDescribeCol always returns decimal digit 6

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: 14377
Logged by: Son Nguyen
Email address: son102yh@yahoo.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.

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