PRSQL9103031: "If Update" Returns TRUE in a Trigger

ID Number: Q70851

1.10

OS/2

buglist1.10

Summary:

PROBLEM ID: PRSQL9103031

SYMPTOMS

After a trigger using the "if updated(colName)" clause was created,

an attempt to update the column colName, even if the update

statement does not actually affect any rows, will cause the

statements in the "if updated" block to be executed.

CAUSE

"If updated" returns TRUE for columns, regardless of whether the

value has been changed.

STATUS

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

1.10. We are researching this problem and will post new information

here as it becomes available.