Issue Details (XML | Word | Printable)

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

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

No records in the table rdb$dependencies for ddl trigger

Created: 21/Nov/12 12:29 PM   Updated: 03/May/13 01:03 PM
Component/s: Engine
Affects Version/s: 3.0 Initial
Fix Version/s: 3.0 Alpha 1

Time Tracking:
Not Specified

Planning Status: Unspecified


 Description  « Hide
CREATE TABLE DDL_LOG (
    ID INTEGER,
    DDL_EVENT VARCHAR(25),
    SQL BLOB SUB_TYPE TEXT
);

create or alter trigger DDL_LOG_TRIGGER after any ddl statement
as
begin
  insert into ddl_log(SQL, DDL_EVENT)
    values (rdb$get_context('DDL_TRIGGER', 'SQL_TEXT'),
            rdb$get_context('DDL_TRIGGER', 'DDL_EVENT') );
end

select count(*) from rdb$dependencies d
  where d.rdb$dependent_name = 'DDL_LOG_TRIGGER'
     or d.rdb$depended_on_name = 'DDL_LOG_TRIGGER'
----------------------
COUNT
0

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.