ENG-4676:
1. remove LIMIT push down change from previous commit, this will be implemented in a separate ticket;
2. put sortDirection in AbstractJoinPlanNode in order to ignore ORDER BY node for both NLIJ and NLJ
3. add more junit tests and more comments.