Kbase P129788: SQL: ODBC API "Describe Col All" function returns incorrect column scale information
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/20/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
OpenEdge 10.1C
SYMPTOM(s):
SQL: ODBC API "SQLDescribeCol" function returns incorrect column scale information
The number of decimal digits of the column as specified by the "SQLDescribeCol" function does not match the actual value of that column.
Executing "SQLDescribeCol" function against the statement:
SELECT 1/3 FROM PUB.Customer WHERE CustNumber = 1
incorrectly returns the column scale as 8 while the actual value returned by executing "SQLExecDirect" and "SQLGetData" functions against the same SQL statement is: .33333333333333333333333333333333333333333333333333 which has more than 8 decimal digits.
CAUSE:
Bug# OE00166033
FIX:
Upgrade to OpenEdge 10.1C01 or later