Kbase P14556: The use of a date field in an 'OR' filter against a view causes all of the data to be returned as de
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Query has a where clause like 'field1 >= to_date('01/01/01') or field2 >= to_date('01/01/01')'
Query against a table owned by PUB works
Query against a view not owned by PUB causes all numeric fields to be returned with a value of 0.0
CAUSE:
Bug# 20021202-032
CAUSE:
The server was incorrectly building the list of pointers for the fields being returned
FIX:
Upgrade to 9.1D09 or 10.0A