Microsoft KB Archive/70840

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 19:29, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q70840 to Microsoft KB Archive/70840 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft 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)