PRSQL9202018: UPDATE Statement Causes GP-Fault

ID Number: Q81866

1.10 1.11

OS/2

buglist1.10 buglist1.11

Summary:

Problem ID: PRSQL9202018

SYMPTOMS

The following SQL statement causes a GP-fault:

update titles set royalty =

(select (select royalty from titles where title_id = 'BU2075')/

(select royalty from titles where title_id = 'TC3218'))

where title_id = 'PC1035'

WORKAROUND

This query works correctly if the first SELECT statement is removed.

STATUS

Microsoft has confirmed this to be a problem in SQL Server versions

1.1 and 1.11. This problem does not occur in version 4.2.