Kbase P42762: Wrong dates returned with a select statement that uses
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Wrong dates returned with a select statement that uses "IS NULL" to check a date field values
Sample query against sports database
select "Cust-Num", NumberField, "order-date", "ship-date" from pub.order where ("Cust-Num" = 30 OR "Cust-Num"=10) and NumberField = 0 and "Ship-date" IS NULL
ship-date is part of multi-component index
CAUSE:
Bug# 20020628-010
CAUSE:
Internally, when checking IS NULL for a date field that is part of multi-compment index, the SVCESCENDING bit of the indicator did not get set correctly for all of the components of a multi-component index.
FIX:
Upgrade to 9.1D Service Pack 1 or later.