BUG: IF UPDATED Returns TRUE in a Trigger

ID: Q70851


The information in this article applies to:


BUG# OS/2: 1429 (4.2)
       NT:  890 (4.2) 

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 4.2 for OS/2 and Microsoft SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


Keywords          : kbprg SSrvGen kbbug4.20 SSrvWinNT 
Version           : 4.2 | 4.2
Platform          : OS/2 WINDOWS 
Issue type        : 

Last Reviewed: March 17, 1999