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
but its descriptor is not marked as NULL'able, thus client shows FALSE
instead of NULL.
I reported http://tracker.firebirdsql.org/browse/CORE-6322
The SQLDA_DISPLAY ON shows the columns as nullable.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
