Push Filter Down BiInnerJoin and Traverse PlanNode

[yixinglu]

query in sf100 dataset:

MATCH (person)-[:KNOWS*1..2]-(friend)-[:IS_LOCATED_IN]->(city:Place)-[:IS_PART_OF]->(country:Place)
WHERE id(person) == "p-8796093163356" AND id(friend) != "p-8796093163356" AND country.Place.name != "Papua_New_Guinea" AND country.Place.name != "Namibia"
WITH DISTINCT friend
MATCH (friend)<-[:POST_HAS_CREATOR|COMMENT_HAS_CREATOR]-(message)-[:IS_LOCATED_IN]->(country)
WHERE country.Place.name IN ["Papua_New_Guinea", "Namibia"] AND
    CASE
    WHEN message.`Comment`.creationDate < datetime(1306886400)+Duration({days:52}) AND message.`Comment`.creationDate >= datetime(1306886400) THEN true
    WHEN message.Post.creationDate < datetime(1306886400)+Duration({days:52}) AND message.Post.creationDate >= datetime(1306886400) THEN true
    ELSE false
    END
WITH friend,
     CASE WHEN country.Place.name == "Papua_New_Guinea" THEN 1 ELSE 0 END AS messageX,
     CASE WHEN country.Place.name == "Namibia" THEN 1 ELSE 0 END AS messageY
WITH friend, sum(messageX) AS xCount, sum(messageY) AS yCount
WHERE xCount>0 AND yCount>0
RETURN tointeger(substr(id(friend), 2)) AS friendId,
  friend.Person.firstName AS friendFirstName,
  friend.Person.lastName AS friendLastName,
  xCount,
  yCount,
  xCount + yCount AS xyCount
ORDER BY xyCount DESC, friendId ASC
LIMIT 20

execution plan:

The following Filter Conditions should be pushed below the above plan nodes:

WHERE country.Place.name IN ["Papua_New_Guinea", "Namibia"] AND
    CASE
    WHEN message.`Comment`.creationDate < datetime(1306886400)+Duration({days:52}) AND message.`Comment`.creationDate >= datetime(1306886400) THEN true
    WHEN message.Post.creationDate < datetime(1306886400)+Duration({days:52}) AND message.Post.creationDate >= datetime(1306886400) THEN true
    ELSE false
    END

[jievince]

#4987 and #4956 have done it. So close it.