Clone Tools
  • last updated 21 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[NO ISSUE][TEST] Translated old aql tests to sqlpp

-user model changes: no

-storage format changes: no

-interface changes: no

Details:

-Translated old aql tests to sqlpp and added them to queries_sqlpp

-Added new translated tests to testsuite_sqlpp.xml

Change-Id: Id73f4603898f95ccb05352ab5bc2fb193e421126

Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/3946

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

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

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

Reviewed-by: Ian Maxon <imaxon@uci.edu>

    • -0
    • +21
    ./query-ASTERIXDB-1131-2/query-ASTERIXDB-1131.1.query.sqlpp
    • -0
    • +21
    ./query-ASTERIXDB-1131/query-ASTERIXDB-1131.1.query.sqlpp
    • -0
    • +24
    ./query-ASTERIXDB-1212-2-open/query-ASTERIXDB-1212-2-open.1.query.sqlpp
    • -0
    • +26
    ./query-ASTERIXDB-1212-2/query-ASTERIXDB-1212-2.1.query.sqlpp
    • -0
    • +23
    ./query-ASTERIXDB-1212-open/query-ASTERIXDB-1212-open.1.query.sqlpp
    • -0
    • +22
    ./query-ASTERIXDB-1212/query-ASTERIXDB-1212.1.query.sqlpp
    • -0
    • +37
    ./query-ASTERIXDB-673/query-ASTERIXDB-673.1.ddl.sqlpp
    • -0
    • +25
    ./query-ASTERIXDB-673/query-ASTERIXDB-673.2.update.sqlpp
    • -0
    • +28
    ./query-ASTERIXDB-673/query-ASTERIXDB-673.3.query.sqlpp
  1. … 253 more files in changeset.
[ASTERIXDB-2476][COMP] Array slicing parser syntax

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Added slice parser syntax. [list][start:end], the syntax accepts

end expression as an optional argument, the expression can be

written as [list][start:].

- Added slice parser test cases.

Change-Id: Ie83283bfd0a04257b59b573de3dab6b3e47de1bf

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

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>

    • -0
    • +34
    ./list-slice_01/list-slice_01.1.ddl.sqlpp
    • -0
    • +26
    ./list-slice_01/list-slice_01.2.update.sqlpp
    • -0
    • +34
    ./list-slice_01/list-slice_01.3.query.sqlpp
    • -0
    • +34
    ./list-slice_02/list-slice_02.1.ddl.sqlpp
    • -0
    • +26
    ./list-slice_02/list-slice_02.2.update.sqlpp
    • -0
    • +29
    ./list-slice_02/list-slice_02.3.query.sqlpp
    • -0
    • +34
    ./list-slice_03/list-slice_03.1.ddl.sqlpp
    • -0
    • +26
    ./list-slice_03/list-slice_03.2.update.sqlpp
    • -0
    • +31
    ./list-slice_03/list-slice_03.3.query.sqlpp
  1. … 29 more files in changeset.
[NO ISSUE] Fix subqueries for IndexAccessor syntax

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Fixed subqueries for IndexAccessor syntax.

- Added test cases for function and subquery calls as arguments.

Change-Id: Iba16c6c04a526aec117ca3adcb168cdd4ba916a8

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

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>

    • -0
    • +34
    ./get-item_03/get-item_03.1.ddl.sqlpp
    • -0
    • +26
    ./get-item_03/get-item_03.2.update.sqlpp
    • -0
    • +29
    ./get-item_03/get-item_03.3.query.sqlpp
  1. … 5 more files in changeset.
[NO ISSUE][COMP] allow optimization rule to inspect other functions + fixes

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

1. allow the optimization rule "InjectTypeCastForSwitchCaseRule"

(renamed to "InjectTypeCastForFunctionArgumentsRule" now) to consider other

functions specified by the user in addition to the ones already considered

by the rule.

2. fix an issue related to ConstantFoldingRule that affects some existing

functions where the rule would have the function compute the value but fail

to deserialize it (read it) back due to differences in compile-time type

and runtime type.

3. fix static casting of a list constructor function which fails to cast

open its items when the item is a function that returns a closed derived

type.

Change-Id: I65679e934a41e00b04bc3fd479ed404af293eb21

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

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>

    • -0
    • +28
    ./enforcing_item_type/enforcing_item_type.0.query.sqlpp
    • -0
    • +28
    ./enforcing_item_type/enforcing_item_type.1.query.sqlpp
  1. … 12 more files in changeset.
[ASTERIXDB-2401][SQLPP] Support parameterized queries

- user model changes: yes

- storage format changes: no

- interface changes: yes

Details:

- Support statement parameters: named ($name) and positional ($1 or ?)

- Enhance query service API to accept these parameters in the request

- Remove [?] index accessor from SQL++ grammar because it conflicts

with positional parameters ([0] can be used instead)

- Add testcases for parameterized queries

Change-Id: Ia612f731cd2370fccd54c4796bd9787fbea16766

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

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>

    • -1
    • +1
    ./any-collection-member_01/any-collection-member_01.3.query.sqlpp
  1. … 104 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-2/query-ASTERIXDB-159-2.3.query.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-159-3/query-ASTERIXDB-159-3.3.query.sqlpp
  1. … 277 more files in changeset.
[NO ISSUE][FUN] Add array_length()

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Add array_length() which is an alias for len()

- Add testcases

- Add comment explaining logical plan generation for

EVERY quantified expression

Change-Id: I5bd03717d3cc41567d6b060b25ca3051d9f43b3a

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

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

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: Till Westmann <tillw@apache.org>

    • -0
    • +27
    ./array_length/array_length.1.query.sqlpp
  1. … 4 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-2/query-ASTERIXDB-159-2.1.ddl.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-159-2/query-ASTERIXDB-159-2.4.ddl.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-159-3/query-ASTERIXDB-159-3.1.ddl.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-159-3/query-ASTERIXDB-159-3.4.ddl.sqlpp
  1. … 2074 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-2/query-ASTERIXDB-159-2.3.query.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-159-3/query-ASTERIXDB-159-3.3.query.sqlpp
  1. … 382 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-2/query-ASTERIXDB-159-2.1.ddl.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-159-2/query-ASTERIXDB-159-2.3.query.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-159-3/query-ASTERIXDB-159-3.1.ddl.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-159-3/query-ASTERIXDB-159-3.3.query.sqlpp
  1. … 3557 more files 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
    • +20
    ./list-range/list-range.1.query.sqlpp
    • -0
    • +31
    ./query-ASTERIXDB-159-2/query-ASTERIXDB-159-2.1.ddl.sqlpp
    • -0
    • +23
    ./query-ASTERIXDB-159-2/query-ASTERIXDB-159-2.2.update.sqlpp
    • -0
    • +27
    ./query-ASTERIXDB-159-2/query-ASTERIXDB-159-2.3.query.sqlpp
    • -0
    • +20
    ./query-ASTERIXDB-159-2/query-ASTERIXDB-159-2.4.ddl.sqlpp
    • -0
    • +31
    ./query-ASTERIXDB-159-3/query-ASTERIXDB-159-3.1.ddl.sqlpp
    • -0
    • +23
    ./query-ASTERIXDB-159-3/query-ASTERIXDB-159-3.2.update.sqlpp
    • -0
    • +27
    ./query-ASTERIXDB-159-3/query-ASTERIXDB-159-3.3.query.sqlpp
    • -0
    • +20
    ./query-ASTERIXDB-159-3/query-ASTERIXDB-159-3.4.ddl.sqlpp
  1. … 27 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>

    • -2
    • +2
    ./any-collection-member_01/any-collection-member_01.1.ddl.sqlpp
    • -2
    • +2
    ./ordered-list-constructor_01/ordered-list-constructor_01.1.ddl.sqlpp
    • -2
    • +2
    ./ordered-list-constructor_02/ordered-list-constructor_02.1.ddl.sqlpp
    • -2
    • +2
    ./ordered-list-constructor_03/ordered-list-constructor_03.1.ddl.sqlpp
    • -2
    • +2
    ./ordered-list-constructor_04/ordered-list-constructor_04.1.ddl.sqlpp
    • -2
    • +2
    ./scan-collection_01/scan-collection_01.1.ddl.sqlpp
  1. … 2760 more files in changeset.
Add EXISTS/NOT EXISTS.

- Fixed the precedence order of NOT.

Change-Id: I7ec20753659e2de2fd65e5f858e0f73796b907d0

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

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

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

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

    • -0
    • +20
    ./exists/exists.3.query.sqlpp
  1. … 68 more files in changeset.
Merge branch 'master' into hyracks-merge2

  1. … 484 more files in changeset.