Microsoft KB Archive/70840

PRSQL9103020: Aliasing Column in Compute Clause GP-Faults SQL ID Number: Q70840

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL91030020

SYMPTOMS Using the following syntax within a stored procedure will GP-fault SQL Server.

SELECT col1 FROM table COMPUTE aggregate=max(col1) RESOLUTION Use the following syntax within a stored procedure:

SELECT col1 FROM table COMPUTE max(col1)