Hi Devs, As I mentioned in the weekly meeting, I found that our OptimizerTest actually doesn't run the SQLPP tests. Although there is a separate directory 'queries_sqlpp' which contains all the legacy optimizer tests translated into SQLPP, they are not picked up by the OptimizerTest, and the new SQLPP tests are still being added to the old directory and mixed up with AQL tests.
I tried to run those SQLPP tests. More than half of them are failed. There are syntax error (query-issue838.sqlpp), variable name changes, join algorithm changes (word-jaccard.sqlpp) and other changes (issue730.sqlpp). I submitted one patch that fixed the test cases with variable name changes. For the rests, I think we need to decide, between the two versions of the results, which ones are the expected plans and fix the errors. There are some obvious patterns in the plan changes, so I think we only need to fix a few things to cover the rest 450 test cases... Best, Xikui
