Clone Tools
  • last updated 22 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[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-issue258/query-issue258.2.update.sqlpp
    • -1
    • +1
    ./query-issue456/query-issue456.3.query.sqlpp
  1. … 278 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
    ./c2c-w-optional/c2c-w-option.1.ddl.sqlpp
    • -1
    • +1
    ./c2c-wo-optional/c2c-wo-optional.1.ddl.sqlpp
    • -2
    • +2
    ./heterog-list-ordered01/heterog-list-ordered01.1.ddl.sqlpp
    • -2
    • +2
    ./heterog-list01/heterog-list01.1.ddl.sqlpp
    • -2
    • +2
    ./heterog-list02/heterog-list02.1.ddl.sqlpp
    • -2
    • +2
    ./heterog-list03/heterog-list03.1.ddl.sqlpp
    • -1
    • +1
    ./open-closed-01/open-closed-01.1.ddl.sqlpp
    • -2
    • +2
    ./open-closed-12/open-closed-12.1.ddl.sqlpp
    • -2
    • +2
    ./open-closed-14/open-closed-14.1.ddl.sqlpp
    • -1
    • +1
    ./open-closed-15/open-closed-15.1.ddl.sqlpp
    • -1
    • +1
    ./open-closed-16/open-closed-16.1.ddl.sqlpp
    • -1
    • +1
    ./open-closed-17/open-closed-17.1.ddl.sqlpp
    • -2
    • +2
    ./open-closed-20/open-closed-20.1.ddl.sqlpp
    • -2
    • +2
    ./open-closed-21/open-closed-21.1.ddl.sqlpp
  1. … 2063 more files in changeset.
[ASTERIXDB-1753][SQL] Disable auto-plural for group-by.

- user model changes: do not perform auto-scalar-to-plural

transition for variables that are defined prior to a group-by

group clause after the group-by clause.

- storage format changes: no

- interface changes: no

details:

- migrated existing test queries that use auto-plural;

- added a negative test query.

Change-Id: I5d6383fc7453fe7537fc291c3483708b59df3871

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

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

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

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

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

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

    • -2
    • +3
    ./query-issue456/query-issue456.3.query.sqlpp
  1. … 261 more files in changeset.
Supports flexible degree of parallelism.

Detailed list of changes include:

- Add the IClusterInfoCollector interface and feed that to the compiler;

- Add the number of cores into the heartbeat;

- Add partition calculation in APIFramework;

- Fix partitioning property requirements in binary operators such as Join and UnionAll;

- Fix PushSubplanIntoGroupByRule for type propagation;

- Fix InlineLeftNtsInSubplanJoinFlatteningVisitor for the returned top join operator;

- Add unit test for partition calculation in APIFrameworkTest

- Add integration test SqlppExecutionFullParallelismIT, SqlppExecutionLessParallelismIT,

AqlExecutionFullParallelismIT, and AqlExecutionLessParallelismIT for different

parallelism settings;

- Refactor AQLExecutionTest and SqlppExecutionTest;

- Separate one cluster state test out from AqlExecutionTest.

Change-Id: If70faf52bed995c7098cc343f2fabd1b6c8d96e7

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

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

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

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

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

    • -2
    • +3
    ./query-issue456/query-issue456.3.query.sqlpp
  1. … 115 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-issue258/query-issue258.2.update.sqlpp
  1. … 384 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
    ./c2c-w-optional/c2c-w-option.1.ddl.sqlpp
    • -1
    • +1
    ./c2c-wo-optional/c2c-wo-optional.1.ddl.sqlpp
    • -2
    • +2
    ./heterog-list-ordered01/heterog-list-ordered01.1.ddl.sqlpp
    • -2
    • +2
    ./heterog-list01/heterog-list01.1.ddl.sqlpp
    • -2
    • +2
    ./heterog-list02/heterog-list02.1.ddl.sqlpp
    • -2
    • +2
    ./heterog-list03/heterog-list03.1.ddl.sqlpp
    • -1
    • +1
    ./open-closed-01/open-closed-01.1.ddl.sqlpp
    • -4
    • +4
    ./open-closed-15/open-closed-15.1.ddl.sqlpp
    • -4
    • +4
    ./open-closed-16/open-closed-16.1.ddl.sqlpp
    • -4
    • +4
    ./open-closed-17/open-closed-17.1.ddl.sqlpp
    • -3
    • +3
    ./open-closed-20/open-closed-20.1.ddl.sqlpp
    • -3
    • +3
    ./open-closed-21/open-closed-21.1.ddl.sqlpp
    • -2
    • +2
    ./open-closed-22/open-closed-22.1.ddl.sqlpp
    • -1
    • +1
    ./open-closed-24/open-closed-24.1.ddl.sqlpp
  1. … 3547 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>

    • -4
    • +4
    ./c2c-w-optional/c2c-w-option.1.ddl.sqlpp
    • -4
    • +4
    ./c2c-wo-optional/c2c-wo-optional.1.ddl.sqlpp
    • -3
    • +3
    ./heterog-list-ordered01/heterog-list-ordered01.1.ddl.sqlpp
    • -3
    • +3
    ./heterog-list01/heterog-list01.1.ddl.sqlpp
    • -3
    • +3
    ./heterog-list02/heterog-list02.1.ddl.sqlpp
    • -3
    • +3
    ./heterog-list03/heterog-list03.1.ddl.sqlpp
    • -3
    • +3
    ./open-closed-01/open-closed-01.1.ddl.sqlpp
    • -4
    • +4
    ./open-closed-12/open-closed-12.1.ddl.sqlpp
    • -4
    • +4
    ./open-closed-14/open-closed-14.1.ddl.sqlpp
    • -3
    • +3
    ./open-closed-15/open-closed-15.1.ddl.sqlpp
    • -3
    • +3
    ./open-closed-16/open-closed-16.1.ddl.sqlpp
    • -3
    • +3
    ./open-closed-17/open-closed-17.1.ddl.sqlpp
    • -4
    • +4
    ./open-closed-20/open-closed-20.1.ddl.sqlpp
    • -4
    • +4
    ./open-closed-21/open-closed-21.1.ddl.sqlpp
  1. … 2760 more files in changeset.
Support CASE expression in SQL++.

- support both simple CASE expression and searched CASE expression;

- support heterogenous return types of a CASE expression;

- remove IfElseExpression in SQL++;

- remove IfElseToSwitchCaseFunctionRule.java since the plan pattern it tries to identify is no longer right;

- unify CastRecordDescriptor and CastListDescriptor into CastTypeDescriptor;

- fix IS NULL for the case that the input is MISSING;

- let CastTypeDescriptor have a generated runtime so as to handle NULL/MISSING correctly.

Change-Id: Id9de7c3df70be43456e38a61ce767cc14f09e661

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

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

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

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

    • -6
    • +8
    ./query-issue258/query-issue258.2.update.sqlpp
  1. … 115 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>

    • -3
    • +3
    ./query-issue208/query-issue208.1.ddl.sqlpp
    • -1
    • +1
    ./query-issue208/query-issue208.2.update.sqlpp
    • -2
    • +2
    ./query-issue208/query-issue208.3.query.sqlpp
    • -7
    • +7
    ./query-issue236/query-issue236.1.ddl.sqlpp
    • -1
    • +1
    ./query-issue343-2/query-issue343-2.1.ddl.sqlpp
    • -1
    • +1
    ./query-issue343-2/query-issue343-2.2.update.sqlpp
    • -1
    • +1
    ./query-issue343-2/query-issue343-2.3.query.sqlpp
    • -1
    • +1
    ./query-issue343/query-issue343.1.ddl.sqlpp
    • -1
    • +1
    ./query-issue343/query-issue343.2.update.sqlpp
    • -1
    • +1
    ./query-issue343/query-issue343.3.query.sqlpp
    • -1
    • +1
    ./query-issue350-2/query-issue350-2.2.update.sqlpp
    • -1
    • +1
    ./query-issue350/query-issue350.2.update.sqlpp
    • -5
    • +5
    ./query-issue377/query-issue377.1.ddl.sqlpp
    • -2
    • +2
    ./query-issue377/query-issue377.2.update.sqlpp
    • -3
    • +3
    ./query-issue377/query-issue377.3.query.sqlpp
  1. … 2118 more files in changeset.
Merge branch 'master' into hyracks-merge2

    • -1
    • +1
    ./query-issue258/query-issue258.2.update.sqlpp
  1. … 484 more files in changeset.