Issue Details (XML | Word | Printable)

Key: CORE-4555
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 1
Operations

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

DDL trigger remains active after dropped

Created: 18/Sep/14 03:53 PM   Updated: 28/Sep/15 12:59 PM
Component/s: Engine
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

QA Status: Done successfully


 Description  « Hide
Test case:

create exception e1 'e1'!

CREATE OR ALTER TRIGGER t_ddl
ACTIVE BEFORE create exception
AS
BEGIN
  if (current_user <> 'DUDE') then
    exception e1;
END!

create exception ARGH 'sss'!

drop trigger t_ddl!

create exception ARGH 'sss'!

Statement failed, SQLSTATE = HY000
unsuccessful metadata update
-CREATE EXCEPTION ARGH failed
-exception 1
-E1
-e1

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes made changes - 18/Sep/14 03:55 PM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Assignee Adriano dos Santos Fernandes [ asfernandes ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 28/May/15 03:12 PM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status Done successfully
Pavel Cisar made changes - 28/Sep/15 12:59 PM
Status Resolved [ 5 ] Closed [ 6 ]