Knowledge Base

FIX: AV With Outer Join and Convert to Char Column

Article ID: 158584

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition

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.

Additional query words: sql65 join gpf general protection fault

Keywords: kbbug kbfix kbusage KB158584