Watch, Follow, &
Connect with Us

Please visit our new home

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 #:
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: :
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: 10
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).
UPDATE the column explicitly in the UPDATE query.

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 Please download from

Server Response from: ETNACODE01