asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Xikui Wang <>
Subject Optimizer Tests for SQLPP
Date Sat, 14 Apr 2018 16:47:50 GMT
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...


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message