On 30-05-2020 21:32, Adriano dos Santos Fernandes wrote:
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.
See my reply that
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 `nul
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 you
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
https://lists.
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 SQL:2016-2,
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
https://lists
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
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**
- */opt/fireb
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
