[ASTERIXDB-2394][COMP] Align VarCounter in query rewritting - user model changes: no - storage format changes: no - interface changes: no
Details: Currently, before we do certain language rewritings, we take a snapshot of the var counter in the context and pass it to the rewriter. This works fine in most of the cases, but it can fail when the rewriter introduces new variables. This will cause different variables map to the same variable id. Although this error may be fixed by another ScopingVisitor, the compiler could fail if there is no more visitor down in the rewriting workflow.
[ASTERIXDB-2366][TEST] Optimizer tests cleanup for SQL++ - user model changes: no - storage format changes: no - interface changes: no
Details: The current optimizerTest actually doesn't use the SQL++ test cases. The existed test cases for SQLPP also have various issues. This patch cleans part of the test cases which failed at variable names changes in the result query plan.