Issue Details (XML | Word | Printable)

Key: CORE-1693
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 0
Operations

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

Error in EXECUTE STATEMENT inside CONNECT / TRANSACTION START triggers

Created: 14/Jan/08 08:45 PM   Updated: 09/Nov/08 06:39 AM
Return to search
Component/s: Engine
Affects Version/s: 2.1 Alpha 1, 2.1 Beta 1, 2.1 Beta 2, 2.1 RC1
Fix Version/s: 2.5 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Duplicate
 


 Description  « Hide
By the same reasons already discussed for external languages implementation, EXECUTE STATEMENT doesn't work in CONNECT / TRANSACTION START triggers.

isql -term !
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 't.fdb'!
SQL> create trigger t_connect on connect as
CON> declare v integer;
CON> begin
CON> execute statement 'select 1 from rdb$database' into v;
CON> end!

isql t.fdb
Statement failed, SQLCODE = -904
invalid database handle (no active connection)
-At trigger 'T_CONNECT' line: 4, col: 3
Use CONNECT or CREATE DATABASE to specify a database


 All   Comments   Work Log   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar made changes - 28/Jan/08 01:17 PM
Field Original Value New Value
Workflow jira [ 13821 ] Firebird [ 14125 ]
Adriano dos Santos Fernandes made changes - 28/Feb/08 10:30 AM
Fix Version/s 2.5 Alpha 1 [ 10224 ]
Resolution Fixed [ 1 ]
Status Open [ 1 ] Resolved [ 5 ]
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 09/Nov/08 06:39 AM
Link This issue is duplicated by CORE-2178 [ CORE-2178 ]