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

[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 
https://lists.sourceforge.net/lists/listinfo/firebird-devel