Microsoft KB Archive/70826: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q70826 to Microsoft KB Archive/70826 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
(No difference)
|
Latest revision as of 19:29, 12 August 2020
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.