Microsoft KB Archive/70840

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:58, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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)