PRSQL9103009: Cannot Assign a Local Variable a Computed Value

ID Number: Q70829

1.10

OS/2

buglist1.10

Summary:

PROBLEM ID: PRSQL9103009

SYMPTOMS

Using the following syntax to assign a computed value to a local

variable causes SQL Server to GP-fault:

select @veryhigh=price from titles

where price > 10 compute max(price)

CAUSE

This syntax is incorrect.

RESOLUTION

Use the following syntax to assign a computed value to a local

variable:

select @veryhigh = max(price) from titles where price >10