Knowledge Base

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

Article ID: 153624

Article Last Modified on 11/14/2003

APPLIES TO

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


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.