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
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
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
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
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
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**
-
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
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
IN predicate and quantified comparison predicates behave incorrectly with NULL
--
Key: CORE-6322
URL: http://tracker.firebirdsql.org/browse/CORE-6322
Project: Firebird Core
10 matches
Mail list logo