Issue Details (XML | Word | Printable)

Key: CORE-3305
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dzirt
Votes: 0
Watchers: 3
Operations

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

"BLOB not found" error after creation/altering of the invalid trigger

Created: 09/Jan/11 06:02 PM   Updated: 25/Sep/15 01:03 PM
Component/s: Engine
Affects Version/s: 2.5.1, 2.1.5, 2.5.2, 2.1.5 Update 1, 2.5.2 Update 1, 3.0 Alpha 1, 3.0 Alpha 2
Fix Version/s: 2.5.3, 3.0 Beta 1

Environment: Firebird 2.5.1.26163
Issue Links:
Relate

QA Status: Done successfully


 Description  « Hide
Database in dialect 3, ODS 11.2. In isql execute next command:

C:\>isql localhost:test3 -user SYSDBA -pass masterkey
Database: localhost:test3, User: SYSDBA
SQL> recreate table H( VAL Integer );
SQL> commit;
SQL>
SQL> set TERM ^ ;
SQL>
SQL> create or alter trigger H_AI for H
CON> active after insert position 0
CON> as
CON> begin
CON> NEW.VAL = 1;
CON> end^
Statement failed, SQLSTATE = 42000
attempted update of read-only column
SQL>
SQL> set TERM ; ^
SQL>
SQL> rollback;
SQL>
SQL> insert into H( VAL ) values( 123 );
Statement failed, SQLSTATE = HY000
BLOB not found
SQL>

In this and any other connection established before the execution of the statement 'create or alter trigger ...', can not insert data into a table H.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov made changes - 02/Feb/11 11:40 AM
Field Original Value New Value
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 03/Jun/14 10:58 AM
Link This issue relate to CORE-4390 [ CORE-4390 ]
Dmitry Yemanov made changes - 12/Jun/14 07:12 AM
Summary 'BLOB not found' error in insert statement "BLOB not found" error after creation/altering of the invalid trigger
Dmitry Yemanov made changes - 12/Jun/14 07:16 AM
Affects Version/s 3.0 Alpha 2 [ 10560 ]
Affects Version/s 3.0 Alpha 1 [ 10331 ]
Affects Version/s 2.5.2 Update 1 [ 10521 ]
Affects Version/s 2.1.5 Update 1 [ 10522 ]
Affects Version/s 2.5.2 [ 10450 ]
Affects Version/s 2.1.5 [ 10420 ]
Dmitry Yemanov made changes - 12/Jun/14 07:19 AM
Fix Version/s 2.5.3 [ 10461 ]
Dmitry Yemanov made changes - 13/Jun/14 11:28 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Dmitry Yemanov made changes - 12/May/15 12:08 PM
Link This issue relate to CORE-4678 [ CORE-4678 ]
Pavel Zotov made changes - 29/May/15 07:33 PM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status Done successfully
Pavel Cisar made changes - 25/Sep/15 01:03 PM
Link This issue is related to QA-602 [ QA-602 ]