Microsoft KB Archive/70822

PRSQL9103002: Outer Join on a Bit Column GP-Faults SQL Server ID Number: Q70822

1.10 OS/2 buglist1.10 fixlist1.11

Summary:

PROBLEM ID: PRSQL9103002

SYMPTOMS A query with an outer join on a bit column GP-faults SQL Server.

CAUSE Selecting a bit column with any other column when performing an outer join with an ORDER BY clause will result in the GP-fault.

WORKAROUND Without the ORDER BY clause, the GP-fault will not occur. Selecting into a temporary table, and then selecting from the temporary table with the ORDER BY, will eliminate the problem.

STATUS Microsoft has confirmed this to be a problem in SQL Server version 1.1. This problem has been correct in SQL Server version 1.11, which is available from Microsoft Product Support Services. For more information, please contact your primary support provider.