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

ID: Q153624

The information in this article applies to:

Microsoft SQL Server versions 4.2x, 6.0, 6.5

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 : kbbug6.50
Version : 6.5
Platform : WINDOWS
Issue type :