Watch, Follow, &
Connect with Us
Public Report
Report From: InterBase/Server/Internal/DSQL    [ Add a report in this area ]  
Report #:  116299   Status: Closed
Index is not updated if column is modified by trigger
Project:  InterBase Build #:  11.0.2.540
Version:    11.0 Submitted By:   Stephane DORIGO
Report Type:  Basic functionality failure Date Reported:  6/4/2013 7:00:43 AM
Severity:    Critical / Show Stopper Last Updated: 7/17/2013 6:26:56 PM
Platform:    Not OS or platform specific Internal Tracking #:  
Resolution: Fixed (Resolution Comments) Resolved in Build: : 11.0.2.541
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: 10
Description
Index on a column which is modified by trigger (before update) is not updated.
Steps to Reproduce:
1. Create a before update trigger which modify a column with an index defined.
2. Lunch an UPDATE query without this column (the column will be mofied by the "before update" trigger).
3. Make some SELECT query which use the index to this column => bad result set (the new value modifed by the tyrigger has not updated the index).
Workarounds
UPDATE the column explicitly in the UPDATE query.
Attachment
None
Comments

Karol Bieniaszewski at 6/11/2013 11:05:11 PM -
Thanks for the report.
This is critical issue - great, that i found it before upgrade to EX3

We wait with upgrade ticket until this fix will be available.

Sriram Balasubramanian at 7/17/2013 4:24:57 PM -
Fixed in build 11.0.2.541. Please download from http://cc.embarcadero.com/reg/interbase

Server Response from: ETNACODE01