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.