Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

2021-12-20 Thread Dmitry Yemanov
Mark et al, > Looked at it again, and being able to get the total row count will work > for me. Is this information already available, or does this still need > to be implemented? What would you expect from the "row count" requested for a non-scrollable cursor? It cannot return the true count, a

Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

2021-12-20 Thread Dimitry Sibiryakov
Dmitry Yemanov wrote 20.12.2021 11:51: What would you expect from the "row count" requested for a non-scrollable cursor? Even non-scrollable cursors can know total number of records if plan SORT is used or they are fetched to the end but I think that isc_infona is the right answer in all o

Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

2021-12-20 Thread Dmitry Yemanov
20.12.2021 13:58, Dimitry Sibiryakov wrote: Even non-scrollable cursors can know total number of records if plan SORT is used Sort may be hidden inside other execution nodes, so it's not always as easy to know. I'd rather avoid returning (or not) info depending on the query plan. or they

[Firebird-devel] This piece of code crashes 4.0.0.2496 server

2021-12-20 Thread Jiří Činčura
I have this piece of code (based on structure from 11.batch.cpp) and doing `batch->execute` crashes the remote server, version 4.0.0.2496. I know it will end up in error, because I didn't fix the `project1` for my structure, but client should not crash server no matter what, I think.

Re: [Firebird-devel] This piece of code crashes 4.0.0.2496 server

2021-12-20 Thread Jiří Činčura
4.0.1.2692 crashes too. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] This piece of code crashes 4.0.0.2496 server

2021-12-20 Thread Alex Peshkoff via Firebird-devel
On 12/20/21 14:27, Jiří Činčura wrote: 4.0.1.2692 crashes too. Thank you, reproduced. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] varbinary

2021-12-20 Thread Norbert Saint Georges
Hello, a varbinary has a subtype of 1 and not 0 (binary) normal? -- Norbert Saint Georges http://tetrasys.fi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] varbinary

2021-12-20 Thread Dimitry Sibiryakov
Norbert Saint Georges wrote 20.12.2021 12:40: a varbinary has a subtype of 1 and not 0 (binary) normal? Yes. According to README.data_types.txt subtype 1 is what distinguishes VARBINARY from VARCHAR. Though at API level subtype is returned as 0 because of limitations of engine internals.

Re: [Firebird-devel] varbinary

2021-12-20 Thread Mark Rotteveel
On 2021-12-20 12:40, Norbert Saint Georges wrote: Hello, a varbinary has a subtype of 1 and not 0 (binary) normal? You're thinking of BLOB SUB_TYPE, and this is unrelated to BLOB SUB_TYPE, as it isn't a BLOB type. In Firebird 4, VARBINARY is introduced as *an alias* for VARCHAR CHARACTER

Re: [Firebird-devel] Firebird and DSQL Scrollable Cursors

2021-12-20 Thread Mark Rotteveel
On 2021-12-20 11:51, Dmitry Yemanov wrote: Mark et al, Looked at it again, and being able to get the total row count will work for me. Is this information already available, or does this still need to be implemented? What would you expect from the "row count" requested for a non-scrollable cu

Re: [Firebird-devel] varbinary

2021-12-20 Thread Norbert Saint Georges
Thank you for your two responses. unfortunately I have a problem with an old project, following the update of the netprovider 8.5 client. Several varchar (x) character set bytes are declared there which crashes on an expected byte [] even though I have been sending it strings for several months

Re: [Firebird-devel] varbinary

2021-12-20 Thread Jiří Činčura
> update of the netprovider 8.5 client. > Several varchar (x) character set bytes are declared there which > crashes on an expected byte [] even though I have been sending it > strings for several months :-) Do you have an example? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebi

Re: [Firebird-devel] varbinary

2021-12-20 Thread Norbert Saint Georges
Jirí Cincura a écrit : update of the netprovider 8.5 client. Several varchar (x) character set bytes are declared there which crashes on an expected byte [] even though I have been sending it strings for several months :-) Do you have an example? yes, copy/paste from my source class metho

Re: [Firebird-devel] varbinary

2021-12-20 Thread Mark Rotteveel
On 2021-12-20 14:04, Norbert Saint Georges wrote: Thank you for your two responses. unfortunately I have a problem with an old project, following the update of the netprovider 8.5 client. Several varchar (x) character set bytes are declared there which crashes on an expected byte [] even though I

Re: [Firebird-devel] This piece of code crashes 4.0.0.2496 server

2021-12-20 Thread Jiří Činčura
Do you want me to create GH issue? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Mon, Dec 20, 2021, at 12:38, Alex Peshkoff via Firebird-devel wrote: > On 12/20/21 14:27, Jiří Činčura wrote: >> 4.0.1.2692 crashes too. >> > > Thank you, reproduced. > > > > > Firebird-Devel mailing list,

Re: [Firebird-devel] This piece of code crashes 4.0.0.2496 server

2021-12-20 Thread Alex Peshkoff via Firebird-devel
On 12/20/21 20:01, Jiří Činčura wrote: Do you want me to create GH issue? Please do. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] This piece of code crashes 4.0.0.2496 server

2021-12-20 Thread Jiří Činčura
> Please do. https://github.com/FirebirdSQL/firebird/issues/7080 -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel