Microsoft KB Archive/70826

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.