Microsoft KB Archive/104101

From BetaArchive Wiki

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.