FIX: Five-way Table Join w/OR May Cause Handled Exception (152264)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
This article was previously published under Q152264 SYMPTOMS
A five-way (or more) table join with a search clause introduced by an OR
clause may cause handled exception which terminates the client thread.
WORKAROUND
Rewrite the query such that the rows not in the join qualify for the query
because of the OR clause.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
versions 6.0 and 6.5. This problem has been corrected in U.S. Service
Pack 3 for Microsoft SQL Server version 6.0, and in U.S. Service Pack 1
for Microsoft SQL Server version 6.5. For more information, contact your
primary support provider.
Modification Type: | Major | Last Reviewed: | 10/16/2003 |
---|
Keywords: | kbBug kbfix kbprb kbProgramming KB152264 |
---|
|