This is an automated email from the ASF dual-hosted git repository.
dlych pushed a change to branch master
in repository https://gitbox.apache.org/repos/asf/asterixdb.git.
from 6fe3096 Merge branch 'gerrit/cheshire-cat'
new b7d6ddc [ASTERIXDB-2815][COMP] DISTINCT in subquery gives wrong result
new 14d4c9b [NO ISSUE][COMP] Push subplans into subplans
new 46e3ad2 [NO ISSUE][COMP] Improve variable substitution
new bb3c8b9 [NO ISSUE][*DB][STO] Minor performance improvements
new bc63ab5 [NO ISSUE][COMP] Fix assign's explicit ordering handling
new 0425295 Merge branch 'gerrit/cheshire-cat'
The 6 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
Summary of changes:
.../RemoveLeftOuterUnnestForLeftOuterJoinRule.java | 3 +-
.../subplan/InlineAllNtsInSubplanVisitor.java | 7 +-
...nlineLeftNtsInSubplanJoinFlatteningVisitor.java | 7 +-
...InlineSubplanInputForNestedTupleSourceRule.java | 4 +
.../SubplanSpecialFlatteningCheckVisitor.java | 2 +-
.../apache/asterix/api/common/APIFramework.java | 25 +-
.../queries/subquery/in_let_3.sqlpp} | 35 +-
.../queries/subquery/in_let_4.sqlpp} | 38 +-
.../queries/subquery/in_let_5.sqlpp} | 40 +-
.../queries/subquery/in_let_6.sqlpp} | 38 +-
.../queries/subquery/in_let_7.sqlpp} | 40 +-
.../queries/subquery/query-ASTERIXDB-2815.sqlpp} | 36 +-
...XDB-1581.sqlpp => query-ASTERIXDB-1581-2.sqlpp} | 3 +
...lpp => query-ASTERIXDB-1581-correlated-2.sqlpp} | 3 +
.../tpcds/query-ASTERIXDB-1581-correlated.sqlpp | 3 +
.../queries/tpcds/query-ASTERIXDB-1581.sqlpp | 3 +
.../optimizerts/results/subquery/exists.plan | 18 +-
.../optimizerts/results/subquery/exists_ps.plan | 36 +-
.../optimizerts/results/subquery/in_let_3.plan | 74 +++
.../optimizerts/results/subquery/in_let_4.plan | 74 +++
.../optimizerts/results/subquery/in_let_5.plan | 74 +++
.../optimizerts/results/subquery/in_let_6.plan | 70 +++
.../optimizerts/results/subquery/in_let_7.plan | 70 +++
.../optimizerts/results/subquery/not_exists.plan | 18 +-
.../results/subquery/not_exists_ps.plan | 36 +-
.../results/subquery/query-ASTERIXDB-2815.plan | 74 +++
.../results/tpcds/query-ASTERIXDB-1581-2.plan | 142 ++++++
.../tpcds/query-ASTERIXDB-1581-correlated-2.plan | 336 +++++++++++++
.../tpcds/query-ASTERIXDB-1581-correlated.plan | 403 +++++++++-------
.../in_let/in_let.1.ddl.sqlpp} | 35 +-
.../in_let/in_let.2.update.sqlpp} | 34 +-
.../in_let/in_let.3.query.sqlpp} | 25 +-
.../in_let/in_let.4.query.sqlpp} | 28 +-
.../in_let/in_let.5.query.sqlpp} | 29 +-
.../in_let/in_let.6.query.sqlpp} | 28 +-
.../in_let/in_let.7.query.sqlpp} | 29 +-
.../query-ASTERIXDB-2815.1.ddl.sqlpp} | 26 +-
.../query-ASTERIXDB-2815.2.update.sqlpp | 50 ++
.../query-ASTERIXDB-2815.3.query.sqlpp} | 23 +-
.../query-ASTERIXDB-1581-2.3.query.sqlpp | 3 +
....sqlpp => query-ASTERIXDB-1581-2.4.query.sqlpp} | 3 +
.../query-ASTERIXDB-1581-correlated.3.query.sqlpp | 3 +
... query-ASTERIXDB-1581-correlated.4.query.sqlpp} | 3 +
.../api/cluster_state_1/cluster_state_1.1.regexadm | 2 +
.../cluster_state_1_full.1.regexadm | 2 +
.../cluster_state_1_less.1.regexadm | 2 +
.../runtimets/results/subquery/in_let/in_let.3.adm | 2 +
.../runtimets/results/subquery/in_let/in_let.4.adm | 2 +
.../runtimets/results/subquery/in_let/in_let.5.adm | 2 +
.../runtimets/results/subquery/in_let/in_let.6.adm | 2 +
.../runtimets/results/subquery/in_let/in_let.7.adm | 2 +
.../query-ASTERIXDB-2815.3.adm | 2 +
...B-1581-2.1.adm => query-ASTERIXDB-1581-2.2.adm} | 0
...1.adm => query-ASTERIXDB-1581-correlated.2.adm} | 0
.../test/resources/runtimets/testsuite_sqlpp.xml | 10 +
.../asterix/common/config/CompilerProperties.java | 22 +-
.../common/config/OptimizationConfUtil.java | 6 +
.../common/storage/DatasetResourceReference.java | 50 +-
.../asterix/common/storage/ResourceReference.java | 61 ++-
.../logical/AbstractOperatorWithNestedPlans.java | 9 +-
.../logical/AbstractReplicateOperator.java | 4 -
.../algebra/operators/logical/AssignOperator.java | 11 -
.../operators/logical/DistinctOperator.java | 15 +-
.../algebra/operators/logical/GroupByOperator.java | 6 +-
.../logical/IndexInsertDeleteUpsertOperator.java | 8 +-
.../logical/InsertDeleteUpsertOperator.java | 22 +-
.../operators/logical/LeftOuterJoinOperator.java | 4 +-
.../logical/LeftOuterUnnestMapOperator.java | 6 +-
.../operators/logical/LeftOuterUnnestOperator.java | 14 +-
.../algebra/operators/logical/SelectOperator.java | 2 +-
.../algebra/operators/logical/SplitOperator.java | 7 -
.../visitors/CardinalityInferenceVisitor.java | 18 +-
...calOperatorDeepCopyWithNewVariablesVisitor.java | 16 +-
.../visitors/SubstituteVariableVisitor.java | 530 ++++++++++++---------
.../algebra/properties/TypePropagationPolicy.java | 24 +-
.../algebra/typing/PropagatingTypeEnvironment.java | 56 ++-
.../algebra/util/OperatorManipulationUtil.java | 8 +-
.../core/algebra/util/OperatorPropertiesUtil.java | 6 +-
.../algebricks/core/config/AlgebricksConfig.java | 2 +
.../rewriter/base/PhysicalOptimizationConfig.java | 18 +
...liminateSubplanWithInputCardinalityOneRule.java | 83 +---
.../rules/subplan/NestedSubplanToJoinRule.java | 15 +-
.../rules/subplan/PushSubplanIntoGroupByRule.java | 304 +++++++-----
83 files changed, 2341 insertions(+), 1045 deletions(-)
copy
asterixdb/asterix-app/src/test/resources/{runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> optimizerts/queries/subquery/in_let_3.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/{runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> optimizerts/queries/subquery/in_let_4.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/{runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated/query-ASTERIXDB-1581-correlated.3.query.sqlpp
=> optimizerts/queries/subquery/in_let_5.sqlpp} (59%)
copy
asterixdb/asterix-app/src/test/resources/{runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> optimizerts/queries/subquery/in_let_6.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/{runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated/query-ASTERIXDB-1581-correlated.3.query.sqlpp
=> optimizerts/queries/subquery/in_let_7.sqlpp} (58%)
copy
asterixdb/asterix-app/src/test/resources/{runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> optimizerts/queries/subquery/query-ASTERIXDB-2815.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/{query-ASTERIXDB-1581.sqlpp
=> query-ASTERIXDB-1581-2.sqlpp} (96%)
copy
asterixdb/asterix-app/src/test/resources/optimizerts/queries/tpcds/{query-ASTERIXDB-1581-correlated.sqlpp
=> query-ASTERIXDB-1581-correlated-2.sqlpp} (96%)
create mode 100644
asterixdb/asterix-app/src/test/resources/optimizerts/results/subquery/in_let_3.plan
create mode 100644
asterixdb/asterix-app/src/test/resources/optimizerts/results/subquery/in_let_4.plan
create mode 100644
asterixdb/asterix-app/src/test/resources/optimizerts/results/subquery/in_let_5.plan
create mode 100644
asterixdb/asterix-app/src/test/resources/optimizerts/results/subquery/in_let_6.plan
create mode 100644
asterixdb/asterix-app/src/test/resources/optimizerts/results/subquery/in_let_7.plan
create mode 100644
asterixdb/asterix-app/src/test/resources/optimizerts/results/subquery/query-ASTERIXDB-2815.plan
create mode 100644
asterixdb/asterix-app/src/test/resources/optimizerts/results/tpcds/query-ASTERIXDB-1581-2.plan
create mode 100644
asterixdb/asterix-app/src/test/resources/optimizerts/results/tpcds/query-ASTERIXDB-1581-correlated-2.plan
copy
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/{tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> subquery/in_let/in_let.1.ddl.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/{tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> subquery/in_let/in_let.2.update.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/{tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> subquery/in_let/in_let.3.query.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/{tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> subquery/in_let/in_let.4.query.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/{tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> subquery/in_let/in_let.5.query.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/{tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> subquery/in_let/in_let.6.query.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/{tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> subquery/in_let/in_let.7.query.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/{tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> subquery/query-ASTERIXDB-2815/query-ASTERIXDB-2815.1.ddl.sqlpp} (61%)
create mode 100644
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/subquery/query-ASTERIXDB-2815/query-ASTERIXDB-2815.2.update.sqlpp
copy
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/{tpcds/query-ASTERIXDB-1581-2/query-ASTERIXDB-1581-2.3.query.sqlpp
=> subquery/query-ASTERIXDB-2815/query-ASTERIXDB-2815.3.query.sqlpp} (61%)
copy
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-2/{query-ASTERIXDB-1581-2.3.query.sqlpp
=> query-ASTERIXDB-1581-2.4.query.sqlpp} (92%)
copy
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/tpcds/query-ASTERIXDB-1581-correlated/{query-ASTERIXDB-1581-correlated.3.query.sqlpp
=> query-ASTERIXDB-1581-correlated.4.query.sqlpp} (92%)
create mode 100644
asterixdb/asterix-app/src/test/resources/runtimets/results/subquery/in_let/in_let.3.adm
create mode 100644
asterixdb/asterix-app/src/test/resources/runtimets/results/subquery/in_let/in_let.4.adm
create mode 100644
asterixdb/asterix-app/src/test/resources/runtimets/results/subquery/in_let/in_let.5.adm
create mode 100644
asterixdb/asterix-app/src/test/resources/runtimets/results/subquery/in_let/in_let.6.adm
create mode 100644
asterixdb/asterix-app/src/test/resources/runtimets/results/subquery/in_let/in_let.7.adm
create mode 100644
asterixdb/asterix-app/src/test/resources/runtimets/results/subquery/query-ASTERIXDB-2815/query-ASTERIXDB-2815.3.adm
copy
asterixdb/asterix-app/src/test/resources/runtimets/results/tpcds/query-ASTERIXDB-1581-2/{query-ASTERIXDB-1581-2.1.adm
=> query-ASTERIXDB-1581-2.2.adm} (100%)
copy
asterixdb/asterix-app/src/test/resources/runtimets/results/tpcds/query-ASTERIXDB-1581-correlated/{query-ASTERIXDB-1581-correlated.1.adm
=> query-ASTERIXDB-1581-correlated.2.adm} (100%)
