Kbase P42763: No records returned with a select statement that uses multiple conditions on date fields in where c
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/12/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
No records returned with a select statement that uses multiple conditions on date fields in where clause
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 AND "Order-Date" = TO_DATE('03/01/1993')
returns no records
ship-date and order-date are part of multi-component index
CAUSE:
Bug# 20020628-010
CAUSE:
Internally, while function TO_DATE is called and when IS NULL is checked for a date field that is part of multi-compoment index, it does not handle well.
FIX:
Upgrade to 9.1D Service Pack 1 or later.