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 your examples as I said is mixing <boolean expression> with IS operator. This cannot works in runtime with the current generated BLR. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel