Re: [Firebird-devel] Firebird 3, stored procs and plans

2017-08-25 Thread Adriano dos Santos Fernandes
On 25/08/2017 11:06, Paul Reeves wrote: > On Fri, 25 Aug 2017 14:00:03 +0300 Dmitry Yemanov wrote > >>> But whatever happened to the SP debugger? >> AFAIK, it was never started (although was discussed a bit). >> > And while on the subject of a debugger for SPs... > > There are commercial Stored

Re: [Firebird-devel] Firebird 3, stored procs and plans

2017-08-25 Thread Paul Reeves
On Fri, 25 Aug 2017 14:00:03 +0300 Dmitry Yemanov wrote > > > But whatever happened to the SP debugger? > > AFAIK, it was never started (although was discussed a bit). > And while on the subject of a debugger for SPs... There are commercial Stored Procedure debuggers available. And I've

Re: [Firebird-devel] Firebird 3, stored procs and plans

2017-08-25 Thread Dmitry Yemanov
25.08.2017 13:06, Paul Reeves wrote: Is there a simple hack I could do to build FB3.0 with the plan enabled for SPs? Not so simple, as the code was completely refactored. I will try to provide you with a patch during the next days. But whatever happened to the SP debugger? AFAIK, it was

Re: [Firebird-devel] Firebird 3, stored procs and plans

2017-08-25 Thread Paul Reeves
On Fri, 25 Aug 2017 12:28:17 +0300 Dmitry Yemanov wrote > > I agree it was handy in simple cases, but it had too many conceptual > problems. I accept that for all but the most simple cases the 'plan' was more or less useless. But just seeing PLAN (NATURAL) is extremely frustrating. Is

Re: [Firebird-devel] Firebird 3, stored procs and plans

2017-08-25 Thread Dmitry Yemanov
25.08.2017 11:38, Paul Reeves wrote: In FB 3.0 the plan output for stored procs is always PLAN (NATURAL) whereas with FB 2.5 the plan for each sql statement to be executed within the SP are returned. Not having the plan available in FB 3.0 makes it quite difficult to see what is actually

[Firebird-devel] Firebird 3, stored procs and plans

2017-08-25 Thread Paul Reeves
In FB 3.0 the plan output for stored procs is always PLAN (NATURAL) whereas with FB 2.5 the plan for each sql statement to be executed within the SP are returned. Not having the plan available in FB 3.0 makes it quite difficult to see what is actually happening in the SP. However, if we take any