BUG: Incorrect Return of SubSelect in SELECT-SQL Statement

    SELECT * FROM orders WHERE order_id NOT IN ;
       (SELECT order_id FROM orditems WHERE MyFunction(order_id))

    FUNCTION MyFunction
       LPARAM lx
       RETURN .F.
    ENDFUNC
				

MORE INFORMATION

In the following cases, the main query could return an incorrect number of records:

   SELECT * FROM orders WHERE order_id NOT IN ;
      (SELECT order_id FROM orditems WHERE 1=2)

   SELECT * FROM orders WHERE order_id NOT IN ;
      (SELECT order_id FROM orditems WHERE .F.)
				

The above queries return 0 records rather than all records in the table.

Steps to Reproduce Behavior

1. Open the TestData Sample Database.
2. Run one of the SQL Select statements listed in the MORE INFORMATION section of this article.
3. Notice that the Select returns no rows.