PRSQL9012009: "WHERE 1=2" GP-Faults Group Queries

ID Number: Q65779

1.10

OS/2

buglist1.10

Summary:

PROBLEM ID: PRSQL9012009

SYMPTOMS

When trying to execute the following query, the "Processing

query..." message appears, and the server GP-faults:

SELECT COUNT (DISTINCT state)

FROM Authors

WHERE 1=2

CAUSE

The server GP-faults when attempting to use some of the grouping

functions with the "WHERE 1=2" clause. Other queries affected by

this problem are listed below:

1. SELECT SUM (DISTINCT .....)

FROM ...

WHERE 1=2

2. SELECT AVG (DISTINCT .....)

FROM ...

WHERE 1=2

3. SELECT ...

FROM ....

WHERE 1=2

GROUP BY ....

RESOLUTION

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

1.10. This problem was corrected in SQL Server version 1.10a. For

more information, contact your authorized network specialists [or

Microsoft Inside Sales, System Software, at (800) 227-4679].