FIX: AV With Outer Join and Convert to Char Column (158584)



The information in this article applies to:

  • Microsoft SQL Server 6.5

This article was previously published under Q158584
BUG #: 15789 (6.50, NT)

SYMPTOMS

A query performing an outer join (using either old or new ANSI-compatible join syntax) and including a CHAR column in the select list (which comes from doing a CONVERT) may generate a handled access violation (AV).

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.


Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbfix kbusage KB158584