> One question though ...
>
> When I execute a stored procedure (with or without package, doesn't
> matter), e.g.:
>
> select * from pkg_schema.s_user_tables;
>
> I also see appropriate PREPARE_STATEMENT etc. events for the SELECT
> statement. Whereas when I execute a stored function with e.g.:
>
> select foo(2) from rdb$database;
>
> I only see the EXECUTE_FUNCTION_* events, but none related to the SELECT
> statement.
>
> Is this as designed?
Of course, not. I see all statement related events:
2014-02-22T17:46:27.4320 (2292:02DB3EE0) PREPARE_STATEMENT
A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>)
(TRA_70, READ_COMMITTED | NO_REC_VERSION | WAIT | READ_WRITE)
Statement 41:
-------------------------------------------------------------------------------
select f1(1) from rdb$database
0 ms
2014-02-22T17:46:27.4320 (2292:02DB3EE0) EXECUTE_STATEMENT_START
A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>)
(TRA_69, CONCURRENCY | WAIT | READ_WRITE)
Statement 41:
-------------------------------------------------------------------------------
select f1(1) from rdb$database
2014-02-22T17:46:27.4320 (2292:02DB3EE0) EXECUTE_FUNCTION_START
A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>)
(TRA_69, CONCURRENCY | WAIT | READ_WRITE)
Function F1:
param0 = integer, "1"
2014-02-22T17:46:27.4320 (2292:02DB3EE0) EXECUTE_FUNCTION_FINISH
A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>)
(TRA_69, CONCURRENCY | WAIT | READ_WRITE)
Function F1:
param0 = integer, "1"
returns:
param0 = integer, "2"
0 ms
2014-02-22T17:46:27.4320 (2292:02DB3EE0) EXECUTE_STATEMENT_FINISH
A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>)
(TRA_69, CONCURRENCY | WAIT | READ_WRITE)
Statement 41:
-------------------------------------------------------------------------------
select f1(1) from rdb$database
1 records fetched
0 ms, 5 fetch(es)
Table Natural Index Update Insert
Delete Backout Purge Expunge
***************************************************************************************************************
RDB$DATABASE 1
2014-02-22T17:46:27.4320 (2292:02DB3EE0) CLOSE_CURSOR
A.FDB (ATT_53, SYSDBA:NONE, NONE, <internal>)
Statement 41:
-------------------------------------------------------------------------------
select f1(1) from rdb$database
Could you show me how to reproduce the issue ?
Regards,
Vlad
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
