Provide built-in context variable with name like 'CALL_STACK' which is
initialized on exception and contains info about point when this exc. occured
----------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-4392
URL: http://tracker.firebirdsql.org/browse/CORE-4392
Project: Firebird Core
Issue Type: Improvement
Reporter: Pavel Zotov
Priority: Minor
Currently we can look at the stack of problem point only on client side, it
looks like this:
Statement failed, SQLSTATE = 23000
Operation violates CHECK constraint INVNT_QC_ACN_CAN_ZERO_ONLY_BOTH on view or
table INVNT
-At trigger 'CHECK_1163'
At procedure 'SP_UPDATE_INVNT' line: 28, col: 5
At procedure 'SP_ADD_INVOICE_TO_STOCK' line: 114, col: 13
-At procedure 'SP_UPDATE_INVNT' line: 110, col: 9
At procedure 'SP_ADD_INVOICE_TO_STOCK' line: 114, col: 13
-At procedure 'SP_ADD_INVOICE_TO_STOCK' line: 214, col: 9
After line 1284 in file tmp_oltp_logist_CSPROG.tmp
We can NOT obtain the SAME call stack using MON$CALL_STACK table: it can be
applied only in WHEN-block which handles exception, but it will contain OTHER
number of line, namely - line in this WHEN-block.
Futhermore, extensive usage of MON$-tables can greatly reduce performance or
even lead to hang all attachments (I've sent several reports to Dmitry with
such cases).
It will be very useful if we can use new context variable in WHEN-block and log
in database exact call stack which points to problem line of code.
It will be very
--
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
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
