Consultor Eletrônico



Kbase P20869: GPF on use of the UPDATE SET SQL-89 statement.
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/03/2003
Status: Unverified

FACT(s) (Environment):

Sun Solaris SPARC

FACT(s) (Environment):

Progress 9.1C

SYMPTOM(s):

GPF on use of the UPDATE SET SQL-89 statement.

Executing code similar to:

UPDATE Customer
SET Customer.Name = 'SOMETHING'
WHERE Customer.Name = 'Thundering Surf Inc.'.

On a table with a WRITE trigger that modifies the same record on the WRITE event.

CAUSE:

This is bug# 20011214-002 which was fixed in the following patches and later:

PATCH LINUX Intel 9.1C 9.1C08
PATCH SUN SOLARIS INTEL 9.1C 9.1C08
PATCH HP/UX 11 9.1C 9.1C09
PATCH HP-UX 64-bit 9.1C 9.1C09
PATCH UNIX V.4 9.1C 9.1C10
PATCH IBM AIX 9.1C 9.1C10
PATCH SUN SOLARIS 9.1C 9.1C11
PATCH Compaq Tru64 UNIX 9.1C 9.1C11
PATCH WIN NT 32 Intel 9.1C 9.1C15

FIX:

Apply the latest patch platform for the platform or upgrade to a 9.1D or later version.