Semi-Joins with IN and Anti-Joins with NOT IN are not supported

[ABenassi87]

• Feature
• Bug Request

Description

I took this examples from: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_comparisonoperators.htm

Query 1:

SELECT Id, Name 
FROM Account 
WHERE Id IN 
  ( SELECT AccountId
    FROM Opportunity
    WHERE StageName = 'Closed Lost' 
  )

Parsed Output:

Cannot read property 'data' of null

Query 2:

SELECT Id 
FROM Account 
WHERE Id NOT IN
  (
    SELECT AccountId
    FROM Opportunity
    WHERE IsClosed = false
  )

Parsed Output:

Cannot read property 'data' of null

Query 3:

SELECT Id, Name 
FROM Account
WHERE Id IN
  (
    SELECT AccountId
    FROM Contact
    WHERE LastName LIKE 'apple%'
  )
  AND Id IN
  (
    SELECT AccountId
    FROM Opportunity
    WHERE isClosed = false
  )

Parsed Output:

Cannot read property 'currConditionOperation' of null

The parser page displays the message: 'the query is invalid' for each of them but they are valid.