FIX: AV With Outer Join and Convert to Char Column

ID: Q158584


The information in this article applies to:
  • Microsoft SQL Server version 6.5

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 : kbusage SSrvGen SSrvGPF SSrvTran_SQL kbbug6.50 kbfix6.50.sp2
Version : 6.5
Platform : WINDOWS
Issue type :


Last Reviewed: April 4, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.