Kbase P99773: Query using decimal fields for join returns incorrect data
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/01/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
OpenEdge 10.0A
OpenEdge 10.0B
SYMPTOM(s):
SELECT statement is joining two tables using a decimal field as the join field
The decimal fields are defined as having nine digits to the left of the decimal place and nine digits to the right of the decimal place
Incorrect data is being returned due to the join fields not matching up
The decimal fields are being displayed with rounded off values
CAUSE:
Bug# 20050107-009
CAUSE:
The SQL query engine is only using seven digits on the left side of the decimal place and seven digits on the right side of the decimal place when performing the join which in turn is causing records which do not match to be joined together.
FIX:
Upgrade to OpenEdge 10.0B02 or later.