Subject | Re: SELECT for get the number of contexts |
---|---|
Author | Dmitry Yemanov |
Post date | 2015-09-27T16:16:30Z |
26.09.2015 05:59, 'Walter R. Ojeda Valiente' wrote:
statement has one context, join of three tables has three contexts, etc.
Additionally, every UNION and GROUP BY produce one more context.
Dmitry
>No, it's impossible.
> Is there some SELECT that can give me the number of context a stored
> procedure has?
> Other question:It's not about commands, context is a table reference. A trivial INSERT
>
> Which are the comands that count as context?
>
> I know: INSERT, UPDATE, DELETE, SELECT, UNION. Is there some more, JOIN
> or FETCH maybe?
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:No.
>
> That number of 255, will be incremented in Firebird 3?
Dmitry