Microsoft KB Archive/70823

{|
 * width="100%"|

The information in this article applies to:
 * Microsoft SQL Server version 4.2 for OS/2

BUG# OS/2: 1013 (4.2)

SYMPTOMS
The ANY keyword does not return results as expected when using a subquery that references another table.

CAUSE
The optimizer is not removing duplicates correctly.

WORKAROUND
Substitute SELECT (min) in the subquery. For example, change the following query

SELECT loc, sum(cost) FROM test WHERE cost > ANY (SELECT b FROM t1) GROUP BY loc to: SELECT loc, sum(cost) FROM test WHERE cost > (SELECT min(b) FROM t1) GROUP BY loc

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.
 * }

-

Last reviewed: April 25, 1997

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.