PRSQL9103006: Incorrect Results from an OR Select Statement ID Number: Q70826
1.10 OS/2 buglist1.10
Summary:
PROBLEM ID: PRSQL9103006
SYMPTOMS Incorrect results are returned from a select statement with an OR condition on a subquery, when the table in the subquery is empty.
CAUSE: This problem occurs when the second OR condition of the select statement evaluates to NULL.
RESOLUTION Select each side of the OR separately into a temporary table.