BUG: Repeated Execution of Stored Proc May GP Fault Server

• Microsoft SQL Server versions 4.2 and 4.2a for OS/2

SYMPTOMS

A stored procedure doing a select in conjunction with the count and distinct functions may cause a general protection fault (GP fault) on SQL Server. Furthermore, the stored procedure may have executed multiple times on the server without its actually bringing the server down every time.

The stored procedure definition must be like the following:

   create procedure test_proc as
   select count(distinct  column1+column2) from table1 where ...

WORKAROUND

To avoid potential GP faults with the above stored procedure, it may be recoded by selecting into a temporary table and then performing the "distinct" on the temporary table (the 'distinct column1+column2' is the source of the problem):

   create procedure test_proc as
   begin

   create table #temp_sum (sum1 char(4))

   insert into #temp_sum
   select column1+column2
   from table1

   select count(distinct sum1)
   from #temp_sum
   end

STATUS

Microsoft has confirmed this to be a problem in SQL Server versions 4.2 and 4.2a for OS/2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.