BUG: Updating a View Created Using Outer Join Causes GP FaultLast reviewed: April 28, 1997 |
The information in this article applies to:
BUG# OS/2: 1773 (4.2) SYMPTOMSIf 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 WORKAROUNDYou may update the base table directly instead of updating the view. STATUSMicrosoft 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. |
Additional query words: trap nulls |
Last reviewed: April 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.