Fixed various issues and implemented some new features around the new ScanningQueryEngine

This PR contains different commits related to different query-related issues, as follows:
* MODE-2178 - fixed the code for various types of JOINS and also shareable nodes. Enabled back all the previously disabled Tck tests
* MODE-2247 - implemented the `INTERSECT` and `EXCEPT` operations together with several new test cases
* MODE-2209 - implemented the ability to check `READ` permissions for nodes returned from a query, via a new `NodeSequence` implementation
If we do that, then this test will fail: `org.apache.jackrabbit.test.api.ShareableNodeTest#testSearch`
The TCK test validates this behavior from the spec: `If a query matches a descendant node of a shared set, it appears in query results
only once.`