| Subject | Re: [firebird-support] Re: SELECT for get the number of contexts |
|---|---|
| Author | Walter R. Ojeda Valiente |
| Post date | 2015-09-27T17:37:48Z |
Thank you very much Dmitry for your answer, it is more clear now, however I still have some doubts.
According to Vlad Khorsun, each INSERT, UPDATE or DELETE has 2 contexts, cause of the variables NEW and OLD of the triggers. Is that not true?
The only way to know how many contexts a stored procedure has is looking at the source code and counting handly them?
Greetings.
Walter.
On Sun, Sep 27, 2015 at 12:16 PM, Dmitry Yemanov dimitr@... [firebird-support] <firebird-support@yahoogroups.com> wrote:26.09.2015 05:59, 'Walter R. Ojeda Valiente' wrote:
>
> Is there some SELECT that can give me the number of context a stored
> procedure has?
No, it's impossible.
> Other question:
>
> Which are the comands that count as context?
>
> I know: INSERT, UPDATE, DELETE, SELECT, UNION. Is there some more, JOIN
> or FETCH maybe?
It's not about commands, context is a table reference. A trivial INSERT
statement has one context, join of three tables has three contexts, etc.
Additionally, every UNION and GROUP BY produce one more context.
> And the last question:
>
> That number of 255, will be incremented in Firebird 3?
No.
Dmitry