On 10/19/2015 11:06 PM, Thomas Steinmaurer wrote:
> 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?
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
