Re: [Firebird-devel] Odd difference for IN (..) and = ANY (..) in SELECT vs WHERE

2020-05-30 Thread Adriano dos Santos Fernandes
On 30/05/2020 16:20, Adriano dos Santos Fernandes wrote: > On 29/05/2020 16:43, Mark Rotteveel wrote: >> I was just testing some claims in the Firebird Language Reference >> against Firebird 3 and 4, and ran into the following oddity: >> >> The result of `null in (non-empty list or query)` and

Re: [Firebird-devel] Odd difference for IN (..) and = ANY (..) in SELECT vs WHERE

2020-05-30 Thread Adriano dos Santos Fernandes
On 29/05/2020 17:10, Mark Rotteveel wrote: > On 29-05-2020 22:07, Mark Rotteveel wrote: >> Similar problems apply for `(null = any (..))`, this should produce >> TRUE when the subquery is empty, but NULL when non-empty. > > I meant to say this for `(null = all (..))`... > Ok. The problem in

Re: [Firebird-devel] Odd difference for IN (..) and = ANY (..) in SELECT vs WHERE

2020-05-30 Thread Adriano dos Santos Fernandes
On 29/05/2020 17:07, Mark Rotteveel wrote: > > Similar problems apply for `(null = any (..))`, this should produce TRUE > when the subquery is empty, but NULL when non-empty. > `(null = any (..))` should not produce TRUE. Adriano Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Odd difference for IN (..) and = ANY (..) in SELECT vs WHERE

2020-05-30 Thread Adriano dos Santos Fernandes
On 29/05/2020 16:43, Mark Rotteveel wrote: > I was just testing some claims in the Firebird Language Reference > against Firebird 3 and 4, and ran into the following oddity: > > The result of `null in (non-empty list or query)` and `null = any > (non-empty query)` should be `null` (see

Re: [Firebird-devel] Query caching by execute statement

2020-05-30 Thread Vlad Khorsun
30.05.2020 17:33, Dimitry Sibiryakov wrote:   Hello, All.   Does ES cache prepared statements to reuse the handle for the next query with the same text in the same (pooled) connection? Yes, up to 16 statements. Regards, Vlad Firebird-Devel mailing list, web interface at

[Firebird-devel] Query caching by execute statement

2020-05-30 Thread Dimitry Sibiryakov
Hello, All. Does ES cache prepared statements to reuse the handle for the next query with the same text in the same (pooled) connection? -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4.0 Beta 2 : 1) fbclient install on Linux 2) gsec

2020-05-30 Thread Pro Turm
Probably, the symbolic link to the fbclient is a trivial question. But if anyone know the answer, I would really appreciate it On my machine I have the following entries (probably due to the various (de-)installations) - */opt/firebird/lib/libfbclient.so -> libfbclient.so.2** -

Re: [Firebird-devel] Error message 'Install incomplete' in FB4

2020-05-30 Thread Jiří Činčura
On Fri, May 29, 2020, at 22:07, Leyne, Sean wrote: > 1- SRP is not a commonly used protocol You mean in general or in Firebird? -- 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] Odd difference for IN (..) and = ANY (..) in SELECT vs WHERE

2020-05-30 Thread Mark Rotteveel
On 29-05-2020 22:18, Vlad Khorsun wrote:   Try select not (null in (select 'a' from RDB$DATABASE)) from RDB$DATABASE select not (null = any (select 'a' from RDB$DATABASE)) from RDB$DATABASE and they also returns FALSE.   I didn't check details yet, but guess that expression result is NULL

[Firebird-devel] [FB-Tracker] Created: (CORE-6322) IN predicate and quantified comparison predicates behave incorrectly with NULL

2020-05-30 Thread Mark Rotteveel (JIRA)
IN predicate and quantified comparison predicates behave incorrectly with NULL -- Key: CORE-6322 URL: http://tracker.firebirdsql.org/browse/CORE-6322 Project: Firebird Core