Zoho CRM v4 COQL query: subquery always returns all results

Zoho CRM v4 COQL query: subquery always returns all results

There is a bug with subqueries that they always return all the results. They are essentially ignored. You can test with the following COQL query:
  1. {
    "select_query": "select id from Purchase_Orders where id in (select PO.id from Purchase_Orders AS PO where PO.id < 0)"
    }
This query should return no results, but it will always return all the Purchase Orders available in the CRM