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].