FIX: GP Fault on INSERT with SELECT UNION on Same Table
  
PSS ID Number: Q104101
Article last modified on 10-31-1994
 
4.20
 
OS/2
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server version 4.2 for OS/2
----------------------------------------------------------------------
 
BUG# OS/2: 1755 (4.2)
 
SYMPTOMS
========
 
An INSERT with a SELECT UNION on the same table will general protection
fault (GP fault) the SQL Server.
 
The following will cause a GP fault in SQL Server:
 
   create table testtrap (cola int)
   go
   insert testtrap select * from testtrap union select * from
   testtrap
 
STATUS
======
 
Microsoft has confirmed this to be a problem in SQL Server version
4.2 for OS/2. This problem was corrected in SQL Server version
4.2aK11. For more information, contact your primary support provider.
 
Additional reference words: 4.20 Transact-SQL
KBCategory: kbprg kberrmsg
KBSubCategory: SSrvServer SSrvGPF
 
=============================================================================
 
Copyright Microsoft Corporation 1994.
