Clone Tools
  • last updated 22 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[ASTERIXDB-2525][COMP] Re-infer types after introducing aggregate combiners

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Re-infer all types after introducing aggregate combiners

- AbstractIntroduceGroupByCombinerRule should keep original

operators in nested plans if it did not apply

Change-Id: I404b795452660792166d7e41edcd7dbf9d85f9f8

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

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: Ali Alsuliman <ali.al.solaiman@gmail.com>

    • -0
    • +26
    ./query-ASTERIXDB-2525/query-ASTERIXDB-2525.1.query.sqlpp
  1. … 5 more files in changeset.
[ASTERIXDB-2399][SQL][FUN] Rename COLL_ aggregate functions

Rename to COLL_ functions to use the prefix STRICT_ to reduce the

confusion about which functions implement a strict NULL handling.

Change-Id: I5c103dbe7fa42bf5c4e2bfa53592b2041084aa8f

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

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>

    • -1
    • +1
    ./query-ASTERIXDB-159/query-ASTERIXDB-159.3.query.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-1626-2/query-ASTERIXDB-1626-2.3.query.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-1626/query-ASTERIXDB-1626.3.query.sqlpp
  1. … 275 more files in changeset.
[ASTERIXDB-2117][SQL] Eliminating '#' for line comment in SQLPP

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

1. Removed '#' for line comment in SQLPP.

2. Fixed comment stripping for '--' in test executor.

Change-Id: I8fc25ad9cd4923edf0359cf90b466c8fa09a6485

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

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: Michael Blow <mblow@apache.org>

  1. … 18 more files in changeset.
[ASTERIXDB-2050][SQL] Enforce a Semicolon After Each SQL++ Statement

- user model changes: a semicolon must be added after

every SQL++ statement.

- storage format changes: no

- interface changes: no

Details:

- Enforce a semicolon after each SQL++ statement.

- Adapt existing SQL++ test cases to new model.

Change-Id: I27e9e8fde5ff867ab569c8d443ba1522738046e3

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

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

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

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

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

    • -1
    • +1
    ./query-ASTERIXDB-159/query-ASTERIXDB-159.1.ddl.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-159/query-ASTERIXDB-159.4.ddl.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-1626-2/query-ASTERIXDB-1626-2.1.ddl.sqlpp
  1. … 2063 more files in changeset.
Renaming SQL++ core aggregation functions:

- array_xxx -> coll_xxx, which considers nulls and missings,

- array_sql_xxx -> array_xxx, which ignores nulls and missings.

Change-Id: Ie58c31af69094b93ba21df54f90f5fad28998a34

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

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

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

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

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

    • -1
    • +1
    ./query-ASTERIXDB-159/query-ASTERIXDB-159.3.query.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-1626-2/query-ASTERIXDB-1626-2.3.query.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-1626/query-ASTERIXDB-1626.3.query.sqlpp
  1. … 380 more files in changeset.
ASTERIXDB-1539: add aliases for several builtin types and builtin functions.

- tinyint for int8;

- smallint for int16;

- integer(or, int) for int32;

- bigint for int64;

- year_month_duration for year-month-duration;

- day_time_duration for day-time-duration;

- timestamp for datetime;

- double precision for double;

int8, int16, int32, int64, year-month-duration and day-time-duration

is going to be deprecated.

In addition, it

- converts underscores to hypens for SQL++ functions;

- uses "array_" prefix for builtin aggregation functions.

Change-Id: I5c4a933f9775e89c2d503d9ea1cb98c5934d1475

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

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

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

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

Reviewed-by: Yingyi Bu <buyingyi@gmail.com>

    • -1
    • +1
    ./query-ASTERIXDB-159/query-ASTERIXDB-159.1.ddl.sqlpp
  1. … 3547 more files in changeset.
ASTERIXDB-1626: performance improvement for multiple global aggregates.

- add a groupAll option for preclustered group-by.

- the listify function is removed in multiple global aggregate plans.

Change-Id: I85bb47748950cc909ddbd9720f613e0b8956d320

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

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

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

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

    • -0
    • +31
    ./query-ASTERIXDB-1626-2/query-ASTERIXDB-1626-2.1.ddl.sqlpp
    • -0
    • +23
    ./query-ASTERIXDB-1626-2/query-ASTERIXDB-1626-2.2.update.sqlpp
    • -0
    • +24
    ./query-ASTERIXDB-1626-2/query-ASTERIXDB-1626-2.3.query.sqlpp
    • -0
    • +20
    ./query-ASTERIXDB-1626-2/query-ASTERIXDB-1626-2.4.ddl.sqlpp
    • -0
    • +31
    ./query-ASTERIXDB-1626/query-ASTERIXDB-1626.1.ddl.sqlpp
    • -0
    • +23
    ./query-ASTERIXDB-1626/query-ASTERIXDB-1626.2.update.sqlpp
    • -0
    • +23
    ./query-ASTERIXDB-1626/query-ASTERIXDB-1626.3.query.sqlpp
    • -0
    • +20
    ./query-ASTERIXDB-1626/query-ASTERIXDB-1626.4.ddl.sqlpp
  1. … 32 more files in changeset.
Add "--" and "#" for SQL++ comments.

Change-Id: I389eb3f1e9653ee976152c894f04939e5eb162e2

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

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

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

Reviewed-by: Michael Blow <mblow@apache.org>

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

  1. … 1 more file in changeset.
ASTERIXDB-1577: fix error handling for field access over a dataset.

- add a rewrite rule to handle unnesting functions that do not appear

in an unnest operator or left outer unnest operator;

- ASTERIXDB-159 is fixed as well.

Change-Id: Id0dc4db91a6251d55dafd734d9ea5bfb6c11c315

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

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

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

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

Reviewed-by: Yingyi Bu <buyingyi@gmail.com>

    • -0
    • +31
    ./query-ASTERIXDB-159/query-ASTERIXDB-159.1.ddl.sqlpp
    • -0
    • +23
    ./query-ASTERIXDB-159/query-ASTERIXDB-159.2.update.sqlpp
    • -0
    • +22
    ./query-ASTERIXDB-159/query-ASTERIXDB-159.3.query.sqlpp
    • -0
    • +20
    ./query-ASTERIXDB-159/query-ASTERIXDB-159.4.ddl.sqlpp
  1. … 32 more files in changeset.
Support count(*).

Change-Id: Ie34537f08434fb0eb930725423ae12c0cd8e5983

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

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

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

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

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

    • -0
    • +30
    ./q11/q11.1.ddl.sqlpp
    • -0
    • +23
    ./q11/q11.2.update.sqlpp
    • -0
    • +23
    ./q11/q11.3.query.sqlpp
    • -0
    • +30
    ./q12_error/q12_error.1.ddl.sqlpp
    • -0
    • +22
    ./q12_error/q12_error.2.update.sqlpp
    • -0
    • +23
    ./q12_error/q12_error.3.query.sqlpp
  1. … 2 more files in changeset.
Fix open field CREATE INDEX syntax (AQL and SQLPP).

Our CREATE INDEX syntax for open fields didn't match our semantics.

Our semantics allow to-be-indexed open field(s) to be MISSING.

We don't support (or offer :-)) tighter semantics than that.

Our syntax didn't require creators to say this, but now it does:

Old: CREATE INDEX myIdx on MyDSet(myTime: datetime) ENFORCED;

New: CREATE INDEX myIdx on MyDSet(myTime: datetime?) ENFORCED;

Have now addressed all of Till's comments (I think).

Change-Id: I32bf8bc5ac1c0e6aa6744ca8f91a197311219814

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

Reviewed-by: Yingyi Bu <buyingyi@gmail.com>

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

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

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

  1. … 778 more files in changeset.
Clean up GROUP BY and WITH clause.

- fix ASTERIXDB-971, i.e., the expression to plan translator for FLWOGR without a "for";

- fix the scoping for nested WITH clause;

- fix the scoping for nested GROUP BY clause;

- fix default fields in group variables;

- fix/unify the expression substition AST visitor;

- enhance RemoveUnusedAssignAndAggregateRule to be able to remove unused GROUP BY

decoration varaibles;

- clearly sperate SQL++ aggregate functions and SQL-92 aggregate functions, i.e.,

SQL-92 aggregate sugars cannot apply to SQL++ aggregate functions;

- fix PushAggregateIntoGroupbyRule for nested plan deletions;

- enhance RemoveCartesianProductWithEmptyBranchRule;

- add ExtractGroupByDecorVariablesRule;

- add an aggregate function first-element;

- fix ASTERIXDB-1560, an error message issue.

Change-Id: I62fca7f937aa007d97ed87c75cef19f6aa3e5ade

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

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

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

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

    • -0
    • +51
    ./q09/q09.1.ddl.sqlpp
    • -0
    • +30
    ./q09/q09.2.update.sqlpp
    • -0
    • +26
    ./q09/q09.3.query.sqlpp
    • -0
    • +51
    ./q10/q10.1.ddl.sqlpp
    • -0
    • +30
    ./q10/q10.2.update.sqlpp
    • -0
    • +29
    ./q10/q10.3.query.sqlpp
  1. … 230 more files in changeset.
Renaming: "table"->"dataset", "database"->"dataverse".

Change-Id: Ia80193f08651fc99341d9a8cf156d0feb6d0575f

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

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

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

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

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

  1. … 2760 more files in changeset.
Use backticks instead of double quotes for delimited identifiers in SQL++.

Change-Id: I2db58d68e8e28befa4105504c261b101fa0285af

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

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

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

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

  1. … 2118 more files in changeset.
Move merged files

    • -0
    • +51
    ./q01/q01.1.ddl.sqlpp
    • -0
    • +30
    ./q01/q01.2.update.sqlpp
    • -0
    • +23
    ./q01/q01.3.query.sqlpp
    • -0
    • +51
    ./q02/q02.1.ddl.sqlpp
    • -0
    • +30
    ./q02/q02.2.update.sqlpp
    • -0
    • +23
    ./q02/q02.3.query.sqlpp
    • -0
    • +51
    ./q03/q03.1.ddl.sqlpp
    • -0
    • +30
    ./q03/q03.2.update.sqlpp
    • -0
    • +23
    ./q03/q03.3.query.sqlpp
    • -0
    • +51
    ./q04/q04.1.ddl.sqlpp
    • -0
    • +30
    ./q04/q04.2.update.sqlpp
    • -0
    • +23
    ./q04/q04.3.query.sqlpp
    • -0
    • +51
    ./q05_error/q05_error.1.ddl.sqlpp
    • -0
    • +30
    ./q05_error/q05_error.2.update.sqlpp
    • -0
    • +23
    ./q05_error/q05_error.3.query.sqlpp
  1. … 149 more files in changeset.