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: Descending order - Click to sort in ascending order
There are no comments yet on this issue.