Issue Details (XML | Word | Printable)

Key: CORE-1006
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it

Created: 20/Nov/06 12:21 AM   Updated: 17/Jun/07 12:18 PM
Component/s: Engine
Affects Version/s: 2.0.0
Fix Version/s: 2.0.1, 2.1 Alpha 1

Time Tracking:
Original Estimate: Not Specified
Remaining Estimate: 0 minutes
Time Spent - 30 minutes
Time Spent: 30 minutes
Time Spent - 30 minutes

File Attachments: 1. Zip Archive Test.zip (31 kB)

Issue Links:
Relate
 


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 20/Nov/06 12:23 AM
Unzip attached file, restore database backup and run

EXECUTE BLOCK
AS
  DECLARE F1 INT;
  DECLARE F2 INT;
BEGIN
  FOR SELECT T1.ID, T2.ID
    FROM TABLE1 T1, TABLE2 T2
    WHERE T1.ID = T2.ID
    INTO :F1, :F2
    AS CURSOR CUR
  DO
    UPDATE TABLE1 SET NAME = :F1 + :F2 WHERE CURRENT OF CUR;
END

Pavel Cisar added a comment - 24/Apr/07 10:13 AM
Fix verified for 2.1 Alpha 1. Test added.

Pavel Cisar added a comment - 26/Apr/07 11:41 AM
Reopened to update ticket information.