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)