PRSQL9106006: Subquery in Double Parentheses GP-Faults Server

ID Number: Q72942

1.10

OS/2

Summary:

Problem ID: PRSQL9106006

SYMPTOMS

Under certain circumstances, when performing a Transact-SQL query

that contains a subquery, SQL Server GP-faults and SAF hangs with

the message "processing query..." displayed at the bottom of the

screen.

CAUSE

The subquery is surrounded in double parentheses [...in ((select

...))...]. The following query is an example of this problem:

select * from authors

where state in ((select state

from publishers

where state = 'CA'))

STATUS

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

1.1. We are researching this problem and will post new information

here as it becomes available.