Microsoft KB Archive/70840: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (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/")
 
(No difference)

Latest revision as of 19:29, 12 August 2020

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)