BUG: INSERT w/ SELECTs and UNION w/ Msg 512 Cause Handled AV (153624)


The information in this article applies to:

  • Microsoft SQL Server 4.2x
  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
This article was previously published under Q153624
BUG# 15615 (6.50) (sqlserver)

SYMPTOMS

INSERTing to a table from a UNION of two or more SELECTs may result in a handled access violation if one of the SELECTs statements generates error 512.

On the client side, the application will receive the following error:
Msg 512, Level 16, State 1
Subquery returned more than 1 value. The is illegal when the subquery
follows =, !=, <. <=, >, >=, or when the subquery is used as an
expression.

DB-Library Process Dead - Connection Broken.

WORKAROUND

Correct the subquery so that it will only return only one value.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
Modification Type:MajorLast Reviewed:11/14/2003
Keywords:kbBug KB153624
©2003 Microsoft Corporation. All rights reserved.