Kbase P130237: SQL: CAST function returns incorrect precision/scale results
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/06/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
SYMPTOM(s):
SQL: CAST function returns incorrect precision/scale results
Executing the query:
SELECT
PRODUCT.MARGIN,
CAST( PRODUCT.MARGIN AS NUMERIC( 8, 2 ) ),
CAST( CAST( PRODUCT.MARGIN AS NUMERIC( 8, 2 ) ) AS VARCHAR( 30 ) ) AS C2
FROM
PUB.PRODUCT PRODUCT
Returns incorrect scale and precision for columns 2 and 3 of the result set.
CAUSE:
Bug# OE00166609
FIX:
Upgrade to OpenEdge 10.1C01 or later