Re: [Firebird-devel] The IBatch Interface and inline blobs

2021-07-16 Thread Alex Peshkoff via Firebird-devel
On 7/16/21 4:54 PM, Tony Whyman wrote: So I guess that as long as the string is < 32K and you are not using a segmented blob then it is OK to use SQL_VARYING and not the inline blob facility. On the subject of limits, IBatch does seem to have a silent limit that I am still exploring. I was co

Re: [Firebird-devel] The IBatch Interface and inline blobs

2021-07-16 Thread Tony Whyman
So I guess that as long as the string is < 32K and you are not using a segmented blob then it is OK to use SQL_VARYING and not the inline blob facility. On the subject of limits, IBatch does seem to have a silent limit that I am still exploring. I was comparing the time taken to insert 10

Re: [Firebird-devel] The IBatch Interface and inline blobs

2021-07-16 Thread Alex Peshkoff via Firebird-devel
On 7/16/21 12:39 PM, Tony Whyman wrote: I have recently added support for the IBatch interface to IBX and the good news that it all appears to work fine. However, I am still puzzled by why inline blobs exist. For as long as I can remember, Firebird has allowed you to over-ride the input metad

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Vlad Khorsun
16.07.2021 15:22, Dimitry Sibiryakov wrote: 16.07.2021 14:19, Adriano dos Santos Fernandes wrote: Instead of isc_info_sql_blr_bytes/isc_info_sql_blr_text, we can add single top level info code with sub code for raw/blr / dsql/jrd parse trees.   Info request cannot have subcodes, it'll break i

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Dimitry Sibiryakov
16.07.2021 14:19, Adriano dos Santos Fernandes wrote: Instead of isc_info_sql_blr_bytes/isc_info_sql_blr_text, we can add single top level info code with sub code for raw/blr / dsql/jrd parse trees. Info request cannot have subcodes, it'll break its design. -- WBR, SD. Firebird-Devel mai

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Adriano dos Santos Fernandes
On 16/07/2021 06:25, Vlad Khorsun wrote: > 15.07.2021 22:34, Adriano dos Santos Fernandes wrote: >> Hi! >> >> Currently it's possible to set TraceDSQL config parameter in dev build >> to have formatted statement BLR in firebird.log, but that is not >> sufficient for automated tests. >> >> I want to

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Adriano dos Santos Fernandes
On 16/07/2021 05:50, Alex Peshkoff via Firebird-devel wrote: > On 7/15/21 10:56 PM, Dimitry Sibiryakov wrote: >> 15.07.2021 21:34, Adriano dos Santos Fernandes wrote: >>> Comments? >> >>   I see no point in the new interface. > > Not new iface, just extension of old one. > Just a new const as i

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Vlad Khorsun
16.07.2021 13:03, Dimitry Sibiryakov wrote: 16.07.2021 11:52, Vlad Khorsun wrote:    We need a way to know when application uses BLR API directly.   Direct BLR compilation won't have DSQL prepare event with the same statement ID. Isn't it enough for this topic's purpose?.. There are anot

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Dimitry Sibiryakov
16.07.2021 11:52, Vlad Khorsun wrote:   We need a way to know when application uses BLR API directly. Direct BLR compilation won't have DSQL prepare event with the same statement ID. Isn't it enough for this topic's purpose?.. I.e. trace_blr_compile is very different from trace_generated

[Firebird-devel] The IBatch Interface and inline blobs

2021-07-16 Thread Tony Whyman
I have recently added support for the IBatch interface to IBX and the good news that it all appears to work fine. However, I am still puzzled by why inline blobs exist. For as long as I can remember, Firebird has allowed you to over-ride the input metadata SQLType to any other type that can be

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Vlad Khorsun
16.07.2021 12:26, Dimitry Sibiryakov wrote: 16.07.2021 11:21, Vlad Khorsun wrote: Second, we need separate trace event to show generated BLR.   Isn't trace_blr_compile enough? We need a way to know when application uses BLR API directly. I.e. trace_blr_compile is very different from trace

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Dimitry Sibiryakov
16.07.2021 11:21, Vlad Khorsun wrote: Second, we need separate trace event to show generated BLR. Isn't trace_blr_compile enough? -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Vlad Khorsun
15.07.2021 22:34, Adriano dos Santos Fernandes wrote: Hi! Currently it's possible to set TraceDSQL config parameter in dev build to have formatted statement BLR in firebird.log, but that is not sufficient for automated tests. I want to add facility to make it possible to applications request in

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Dimitry Sibiryakov
16.07.2021 11:21, Vlad Khorsun wrote:   First, existing BLR-related trace events are not unused. Right, I mixed them up with DYN events. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Vlad Khorsun
15.07.2021 22:56, Dimitry Sibiryakov wrote: 15.07.2021 21:34, Adriano dos Santos Fernandes wrote: Comments? ...   It would be simpler to raise trace BLR event from SQL prepare and let anyone interested to watch generated BLR using existing (currently unused) trace parameter. First, exist

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Dimitry Sibiryakov
16.07.2021 10:50, Alex Peshkoff via Firebird-devel wrote: The only problem is that longterm we have plan to remove BLR support at all If I'm not mistaken, these were plans to remove BLR as an intermediate language from DSQL, not "at all". BLR was going still to be a part of Message API for G

Re: [Firebird-devel] Retrieving statement BLR for debug and test

2021-07-16 Thread Alex Peshkoff via Firebird-devel
On 7/15/21 10:56 PM, Dimitry Sibiryakov wrote: 15.07.2021 21:34, Adriano dos Santos Fernandes wrote: Comments?   I see no point in the new interface. Not new iface, just extension of old one. It would be simpler to raise trace BLR event from SQL prepare and let anyone interested to watch