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.