On 10/20/2015 05:51 PM, Thomas Steinmaurer wrote:
> Alexander,
>
>>> Hello,
>>>
>>> I'm using Firebird 2.5.4 x86 on Windows 7.
>>>
>>> A simple table:
>>>
>>> CREATE TABLE T1
>>> (
>>> ID INTEGER NOT NULL,
>>> CONSTRAINT PK_T1 PRIMARY KEY (ID)
>>> );
>>>
>>>
>>> The following trace configuration:
>>>
>>> <database tourism.fdb>
>>> enabled true
>>> log_connections true
>>> log_transactions true
>>> log_statement_finish true
>>> print_plan true
>>> print_perf true
>>> exclude_filter %RDB$%
>>> time_threshold 0
>>> max_sql_length 2048
>>> </database>
>>> <services>
>>> </services>
>>>
>>> Starting a trace session with the above configuration via
>>> fbtracemgr.exe, e.g.:
>>>
>>> fbtracemgr.exe -se localhost/3050:service_mgr -start -name tourism_cmd
>>> -config tourism_trace.conf -user tourism -password tourism
>>>
>>> When I run the following CREATE TRIGGER DDL statement:
>>>
>>> CREATE TRIGGER TRI_T1 FOR T1 BEFORE DELETE position 32767 AS
>>> BEGIN
>>> -- EXECUTE PROCEDURE P_1 (RDB$GET_CONTEXT('SYSTEM', 'ISOLATION_LEVEL'));
>>> END;
>>>
>>>
>>> The statement isn't captured from the trace session.
>>>
>>> If I remove the RDB$GET_CONTEXT part, e.g.:
>>>
>>> CREATE TRIGGER TRI_T1 FOR T1 BEFORE DELETE position 32767 AS
>>> BEGIN
>>> -- EXECUTE PROCEDURE P_1 ();
>>> END;
>>>
>>> or remove the commented line entirely:
>>>
>>> CREATE TRIGGER TRI_T1 FOR T1 BEFORE DELETE position 32767 AS
>>> BEGIN
>>> END;
>>>
>>>
>>> Then both cases are captured from the trace session.
>>>
>>> Doesn't look right to me. Is this a known issue?
>> Just to make sure - does removing line
>> exclude_filter %RDB$%
>> from trace configuration also make statement be captured?
> Excellent catch Alexander!
>
> Now it gets captured. The intention of the exclude filter was to reduce
> the noise due to system table queries by third-party components,
> development tools etc ...
Thomas, please add an item to the tracker with this sample.
IMHO filter should not be applied to the whole body of a trigger, only
to it's name.
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
