Clone Tools
  • last updated 24 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[ASTERIXDB-2488][COMP] Support aggregate window functions

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Implement aggregate window functions:

agg_func() OVER (frame_var AS)? (PARTITION BY ... ORDER BY ... frame_spec)

- Where agg_func is a SQL/SQL++ aggregate function

- Fix percent_rank() to always return 0 for the first tuple

- Fix ntile() to handle NULL argument

- Log query after each rewrite rule in SqlppQueryRewriter

- Implement toString() for ADayTimeDuration, fix it for AYearMonthDuration

- Add seek() method to RunFileReader

Change-Id: If0f71118a04c2dbd3462070673d52e67f076b7e1

Reviewed-on: https://asterix-gerrit.ics.uci.edu/3049

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Ali Alsuliman <ali.al.solaiman@gmail.com>

    • -1
    • +1
    ./rtree-sidx-idxonly-01-disable-idxonly.plan
  1. … 854 more files in changeset.
[ASTERIXDB-2468] Extend CountVarToCountOneRule to support no group-by

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Extend CountVarToCountOneRule to support the no group-by case so

that count queries without group-by can be handled as well.

- Also extend this rule to support SQL_COUNT. In this case, count(v)

is replaced with count(1) only v is not nullable.

Change-Id: Ie0808912cf45d3a914ebf7f69ec42f73b33c071f

Reviewed-on: https://asterix-gerrit.ics.uci.edu/3024

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

    • -10
    • +8
    ./rtree-sidx-idxonly-01-disable-idxonly.plan
  1. … 26 more files in changeset.
[ASTERIXDB-2441][COMP] Improve column alias handling in ORDERBY/LIMIT

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Introduce LET clauses for column alias expressions

instead of inlining them into ORDER BY/LIMIT clauses

- Fix incorrect visitor used in SubstituteGroupbyExpressionWithVariableVisitor

for rewriting LET clauses after GROUP BY

Change-Id: If925cbb803f2ad5fe955ba343ddc62585589b894

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2905

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

Contrib: Till Westmann <tillw@apache.org>

    • -1
    • +1
    ./rtree-sidx-idxonly-01-disable-idxonly.plan
  1. … 43 more files in changeset.
[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.

Change-Id: I8ea1ee7de140d6556af03f07a5ec7bc278b011ba

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2673

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

    • -1
    • +1
    ./rtree-sidx-idxonly-01-disable-idxonly.plan
  1. … 30 more files in changeset.
[NO ISSUE][COMP][RT] Rename index-only test case files

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Rename index-only test case files to a shorter version

not to cause issues on Windows environment.

Change-Id: I4a4bb7b045a430bd446aed756f58af7b4c2a6eaa

Reviewed-on: https://asterix-gerrit.ics.uci.edu/2468

Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Till Westmann <tillw@apache.org>

    • -22
    • +0
    ./rtree-secondary-index-indexonly-plan-01-disable-indexonly-plan.plan
    • -39
    • +0
    ./rtree-secondary-index-indexonly-plan-01.plan
    • -33
    • +0
    ./rtree-secondary-index-indexonly-plan-02.plan
    • -37
    • +0
    ./rtree-secondary-index-indexonly-plan-03.plan
    • -38
    • +0
    ./rtree-secondary-index-indexonly-plan-04.plan
    • -35
    • +0
    ./rtree-secondary-index-indexonly-plan-05.plan
    • -39
    • +0
    ./rtree-secondary-index-indexonly-plan-06.plan
    • -35
    • +0
    ./rtree-secondary-index-indexonly-plan-07.plan
    • -33
    • +0
    ./rtree-secondary-index-indexonly-plan-08.plan
    • -35
    • +0
    ./rtree-secondary-index-indexonly-plan-09.plan
    • -0
    • +22
    ./rtree-sidx-idxonly-01-disable-idxonly.plan
    • -0
    • +39
    ./rtree-sidx-idxonly-01.plan
    • -0
    • +33
    ./rtree-sidx-idxonly-02.plan
    • -0
    • +37
    ./rtree-sidx-idxonly-03.plan
    • -0
    • +38
    ./rtree-sidx-idxonly-04.plan
  1. … 427 more files in changeset.
[ASTERIXDB-1972][COMP][RT][TX] index-only plan

- user model changes: no

- storage format changes: no

- interface changes: IAccessMethod, ILSMIndexOperationContext,

IIndexAccessor

Details:

- Implement an index-only plan

- Add a SET option that disables the index-only plan

Change-Id: Ifd5c9ab1cf2e4bedb7d8db582441919875e74d51

Reviewed-on: https://asterix-gerrit.ics.uci.edu/1866

Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

Reviewed-by: Taewoo Kim <wangsaeu@gmail.com>

    • -0
    • +22
    ./rtree-secondary-index-indexonly-plan-01-disable-indexonly-plan.plan
    • -0
    • +39
    ./rtree-secondary-index-indexonly-plan-01.plan
    • -0
    • +33
    ./rtree-secondary-index-indexonly-plan-02.plan
    • -0
    • +37
    ./rtree-secondary-index-indexonly-plan-03.plan
    • -0
    • +38
    ./rtree-secondary-index-indexonly-plan-04.plan
    • -0
    • +35
    ./rtree-secondary-index-indexonly-plan-05.plan
    • -0
    • +39
    ./rtree-secondary-index-indexonly-plan-06.plan
    • -0
    • +35
    ./rtree-secondary-index-indexonly-plan-07.plan
    • -0
    • +33
    ./rtree-secondary-index-indexonly-plan-08.plan
    • -0
    • +35
    ./rtree-secondary-index-indexonly-plan-09.plan
  1. … 415 more files in changeset.