[Firebird-devel] [FB-Tracker] Created: (CORE-6488) Event delivery could be missed when local (XNET) protocol is used

2021-02-15 Thread Vlad Khorsun (JIRA)
Event delivery could be missed when local (XNET) protocol is used - Key: CORE-6488 URL: http://tracker.firebirdsql.org/browse/CORE-6488 Project: Firebird Core Issue Type: Bug

Re: [Firebird-devel] Effect of positioning the cursor beyond the result set with ABSOLUTE

2021-02-15 Thread Alex Peshkoff via Firebird-devel
On 2/15/21 7:39 PM, Mark Rotteveel wrote: On 15-02-2021 16:21, Alex Peshkoff via Firebird-devel wrote: On 2/14/21 4:01 PM, Mark Rotteveel wrote: For documentation purposes, I was wondering if this was intended behaviour, both the ability to position beyond the bounds of the result set using

Re: [Firebird-devel] Effect of positioning the cursor beyond the result set with ABSOLUTE

2021-02-15 Thread Mark Rotteveel
On 15-02-2021 16:21, Alex Peshkoff via Firebird-devel wrote: On 2/14/21 4:01 PM, Mark Rotteveel wrote: For documentation purposes, I was wondering if this was intended behaviour, both the ability to position beyond the bounds of the result set using ABSOLUTE, and the remembering of the actual

[Firebird-devel] [FB-Tracker] Created: (CORE-6487) FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last

2021-02-15 Thread Mark Rotteveel (JIRA)
FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last - Key: CORE-6487 URL:

Re: [Firebird-devel] Effect of positioning the cursor beyond the result set with ABSOLUTE

2021-02-15 Thread Mark Rotteveel
On 15-02-2021 16:45, Dimitry Sibiryakov wrote: 15.02.2021 16:21, Alex Peshkoff via Firebird-devel wrote: Trying to position in non-existent place should better raise error.   According to ODBC (which is the most-established DB API) specs of SQLFetchScroll() function fetching beyond record

Re: [Firebird-devel] Effect of positioning the cursor beyond the result set with ABSOLUTE

2021-02-15 Thread Mark Rotteveel
On 15-02-2021 16:21, Alex Peshkoff via Firebird-devel wrote: On 2/14/21 4:01 PM, Mark Rotteveel wrote: For documentation purposes, I was wondering if this was intended behaviour, both the ability to position beyond the bounds of the result set using ABSOLUTE, and the remembering of the actual

Re: [Firebird-devel] Effect of positioning the cursor beyond the result set with ABSOLUTE

2021-02-15 Thread Dimitry Sibiryakov
15.02.2021 16:21, Alex Peshkoff via Firebird-devel wrote: Trying to position in non-existent place should better raise error. According to ODBC (which is the most-established DB API) specs of SQLFetchScroll() function fetching beyond record set must end up to fixed "before start"/"after

Re: [Firebird-devel] Effect of positioning the cursor beyond the result set with ABSOLUTE

2021-02-15 Thread Alex Peshkoff via Firebird-devel
On 2/14/21 4:01 PM, Mark Rotteveel wrote: For documentation purposes, I was wondering if this was intended behaviour, both the ability to position beyond the bounds of the result set using ABSOLUTE, and the remembering of the actual position for subsequent fetches. Or if this is just an

Re: [Firebird-devel] CONTAINING and indexes

2021-02-15 Thread Vlad Khorsun
15.02.2021 12:47, Mark Rotteveel wrote: The Firebird 2.5 Language Reference has the following remark in its description of CONTAINING[1]: """ When CONTAINING is used in the search conditions of DML queries, the Firebird optimizer can use an index on the searched column, if a suitable one

Re: [Firebird-devel] CONTAINING and indexes

2021-02-15 Thread Adriano dos Santos Fernandes
On 15/02/2021 07:47, Mark Rotteveel wrote: > The Firebird 2.5 Language Reference has the following remark in its > description of CONTAINING[1]: > > """ > When CONTAINING is used in the search conditions of DML queries, the > Firebird optimizer can use an index on the searched column, if a >

[Firebird-devel] CONTAINING and indexes

2021-02-15 Thread Mark Rotteveel
The Firebird 2.5 Language Reference has the following remark in its description of CONTAINING[1]: """ When CONTAINING is used in the search conditions of DML queries, the Firebird optimizer can use an index on the searched column, if a suitable one exists. """ Is that remark correct? How I