Microsoft KB Archive/104101

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.