>

>* Thread #851100
>
>CLEAR
>CREATE CURSOR _TABLE (F1 INT NULL)
>
>INSERT INTO _TABLE VALUES (NULL)
>
>* BUG: this return 1 record, correct is 0 record
>SELECT 2 FROM _TABLE T1 WHERE T1.F1 NOT IN (SELECT F1 FROM _TABLE T2) INTO ARRAY zz
>? _TALLY, "Aspected 0"
>
>* BUG: this return 1 record, correct is 0 record
>SELECT 3 FROM _TABLE T1 WHERE T1.F1 <> ALL (SELECT F1 FROM _TABLE T2) INTO ARRAY zz
>? _TALLY, "Aspected 0"
>

Hi Fabio,

This is a known issue and it is going to be documented if not already.

Thanks,
Aleksey.