Microsoft KB Archive/153624

= BUG: INSERT w/ SELECTs and UNION w/ Msg 512 Cause Handled AV =

Article ID: 153624

Article Last Modified on 11/14/2003

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



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.

Additional query words: SQL65 UNION INSERT SELECT AV

Keywords: kbbug KB153624

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.