PRSQL9108014: SQL Server GP-Faults on Outer Join on View

ID Number: Q75716

1.10 1.11

OS/2

buglist1.10 buglist1.11 fixlist4.20

Summary:

Problem ID: PRSQL9108014

SYMPTOMS

Issuing a query that does an outer join on a view may cause SQL

Server to GP-Fault.

CAUSE

SQL Server may incorrectly fault when performing the outer join

when the join is between a table and a view. The following shows

the structure of a query that may cuase SQL Server to GP-fault:

SELECT DATE

FROM STORES, SALESVIEW

WHERE STORES.STOR_ID *= SALESVIEW.STOR_ID

STATUS

Microsoft has confirmed this to be a problem in SQL Server versions

1.1 and 1.11. This problem was corrected in SQL Server version 4.2.

Additional reference words: 1.10 dblib db-lib