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
There are no subversion log entries for this issue yet.