BUG: Updating a View Created Using Outer Join Causes GP Fault

• Microsoft SQL Server version 4.2 for OS/2

SYMPTOMS

If a view is created by joining two or more tables using outer join, then issuing an UPDATE on the view may cause a general protection fault (GP fault).

For example, the following UPDATE command script will cause the problem:

   create table testM (m1 varchar(8) null, datam varchar(8) null)
   create table testC (datac varchar(8) null)
   go
   create view testview
   as
   select * from testM, testC where testM.datam =* testC.datac
   go
   insert testC values ("test")
   insert testM values ("hi","testo")
   go
   update testview set m1="help"
   go

WORKAROUND

You may update the base table directly instead of updating the view.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.