ID Number: Q75693
1.10
OS/2
buglist1.10
Summary:
Problem ID: PRSQL9108012
SYMPTOMS
The following information applies to SQL Server version 1.1a, dated
10-3-90.
Issuing the following query from SAF, ISQL, or a DB-LIBRARY (dblib)
application will either GP fault SQL Server, or create a hung
CPU-intensive thread:
SELECT DISTINCT * FROM TITLES
WHERE TITLE_ID IN
(SELECT DISTINCT TITLE_ID FROM SALES WHERE QTY=10) FOR BROWSE
CAUSE
SQL Server does not correctly handle a FOR BROWSE query when it
contains a SUBQUERY.
STATUS
Microsoft has confirmed this to be a problem in the SQL Server
version 1.1. This problem does not occur in SQL Server version 4.2.
Additional reference words: 1.10 GP-fault db-lib