DDL_TRIGGER not fire on DDL operator COMMENT ON
-----------------------------------------------
Key: CORE-4358
URL: http://tracker.firebirdsql.org/browse/CORE-4358
Project: Firebird Core
Issue Type: Improvement
Affects Versions: 3.0 Alpha 2
Reporter: Simonov Denis
DDL_TRIGGER not fire on DDL operator COMMENT ON
CREATE TABLE DDL_LOG (
ID INTEGER NOT NULL,
MOMENT DATE NOT NULL,
USER_NAME VARCHAR(31) NOT NULL,
EVENT_TYPE VARCHAR(25) NOT NULL,
OBJECT_TYPE VARCHAR(25) NOT NULL,
DDL_EVENT VARCHAR(25) NOT NULL,
OBJECT_NAME VARCHAR(31) NOT NULL,
SQL_TEXT BLOB SUB_TYPE 1 SEGMENT SIZE 80 NOT NULL
);
ALTER TABLE DDL_LOG ADD PRIMARY KEY (ID);
SET TERM ^ ;
CREATE OR ALTER TRIGGER TRIG_DDL_LOG_AFTER
ACTIVE AFTER ANY DDL STATEMENT POSITION 0
AS
BEGIN
INSERT INTO DDL_LOG (ID,
MOMENT,
USER_NAME,
EVENT_TYPE,
OBJECT_TYPE,
DDL_EVENT,
OBJECT_NAME,
SQL_TEXT)
VALUES (NEXT VALUE FOR DDL_SEQ,
CURRENT_TIMESTAMP,
CURRENT_USER,
RDB$GET_CONTEXT('DDL_TRIGGER', 'EVENT_TYPE'),
RDB$GET_CONTEXT('DDL_TRIGGER', 'OBJECT_TYPE'),
RDB$GET_CONTEXT('DDL_TRIGGER', 'DDL_EVENT'),
RDB$GET_CONTEXT('DDL_TRIGGER', 'OBJECT_NAME'),
RDB$GET_CONTEXT('DDL_TRIGGER', 'SQL_TEXT'));
END^
SET TERM ; ^
---------------------------------
set term ^;
create procedure p1
as
begin
end^
set term ;^
comment on procedure p1 is 'my proc';
drop procedure p1;
ID MOMENT USER_NAME EVENT_TYPE OBJECT_TYPE DDL_EVENT
OBJECT_NAME SQL_TEXT
1 04.03.2014 22:00:42 SYSDBA CREATE PROCEDURE CREATE
PROCEDURE P1
2 04.03.2014 22:00:42 SYSDBA DROP PROCEDURE DROP PROCEDURE
P1
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries. Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
