Microsoft KB Archive/65779

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