Re: [Firebird-devel] New statement: EXECUTE SQL

2022-08-13 Thread Adriano dos Santos Fernandes
On 13/08/2022 20:28, Adriano dos Santos Fernandes wrote: > and it's to use with SELECT, UPDATE, DELETE and MERGE And also INSERT and UPDATE OR INSERT... Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] New statement: EXECUTE SQL

2022-08-13 Thread Adriano dos Santos Fernandes
Hi! When one starts with a DSQL command and need to adapt it to EXECUTE BLOCK (for example to use sub routines or use a single parameter in many places), work is difficult when there are many parameters and output fields. Everything must be explicitly declared. I propose new DSQL statement that

[Firebird-devel] Do repeated op_batch_create leak the batch?

2022-08-13 Thread Mark Rotteveel
I'm implementing batch execution in Jaybird. Looking at the code of rem_port::batch_create(P_BATCH_CREATE* batch, PACKET* sendL) in server.cpp, it looks like sending multiple op_batch_create requests for the same statement handle could leak a previously created batch, as it doesn't call