Clone Tools
  • last updated 19 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
    • +57
    ./btree-secondary-self-equi-join_01/btree-secondary-self-equi-join_01.1.ddl.sqlpp
    • -0
    • +31
    ./btree-secondary-self-equi-join_01/btree-secondary-self-equi-join_01.2.update.sqlpp
    • -0
    • +33
    ./btree-secondary-self-equi-join_01/btree-secondary-self-equi-join_01.3.query.sqlpp
    • -0
    • +58
    ./rtree-spatial-self-intersect-point/rtree-spatial-self-intersect-point.1.ddl.sqlpp
    • -0
    • +31
    ./rtree-spatial-self-intersect-point/rtree-spatial-self-intersect-point.2.update.sqlpp
    • -0
    • +33
    ./rtree-spatial-self-intersect-point/rtree-spatial-self-intersect-point.3.query.sqlpp
  1. … 256 more files in changeset.
[NO ISSUE][COMP][RT] Rename index-only test case directory

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

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

not to cause issues on Windows environment.

Change-Id: I360bd650391586a0101cb2eb639c330534753112

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

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: Ian Maxon <imaxon@apache.org>

    • -0
    • +64
    ./btree-pidx-to-sidx-idxonly-equi-join_01/btree-pidx-to-sidx-idxonly-equi-join_01.1.ddl.sqlpp
    • -0
    • +36
    ./btree-pidx-to-sidx-idxonly-equi-join_01/btree-pidx-to-sidx-idxonly-equi-join_01.2.update.sqlpp
    • -0
    • +32
    ./btree-pidx-to-sidx-idxonly-equi-join_01/btree-pidx-to-sidx-idxonly-equi-join_01.3.query.sqlpp
    • -64
    • +0
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-pidx-to-sidx-idxonly-equi-join_01.1.ddl.sqlpp
    • -36
    • +0
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-pidx-to-sidx-idxonly-equi-join_01.2.update.sqlpp
    • -32
    • +0
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-pidx-to-sidx-idxonly-equi-join_01.3.query.sqlpp
    • -63
    • +0
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-sidx-idxonly-to-pidx-equi-join_01.1.ddl.sqlpp
    • -29
    • +0
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-sidx-idxonly-to-pidx-equi-join_01.2.update.sqlpp
    • -26
    • +0
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-sidx-idxonly-to-pidx-equi-join_01.3.query.sqlpp
    • -65
    • +0
    ./btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01/btree-sidx-idxonly-to-sidx-idxonly-equi-join_01.1.ddl.sqlpp
    • -29
    • +0
    ./btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01/btree-sidx-idxonly-to-sidx-idxonly-equi-join_01.2.update.sqlpp
    • -26
    • +0
    ./btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01/btree-sidx-idxonly-to-sidx-idxonly-equi-join_01.3.query.sqlpp
    • -66
    • +0
    ./btree-secondary-non-indexonly-plan-to-primary-equi-join_01/btree-sidx-non-idxonly-to-pidx-equi-join_01.1.ddl.sqlpp
    • -29
    • +0
    ./btree-secondary-non-indexonly-plan-to-primary-equi-join_01/btree-sidx-non-idxonly-to-pidx-equi-join_01.2.update.sqlpp
    • -26
    • +0
    ./btree-secondary-non-indexonly-plan-to-primary-equi-join_01/btree-sidx-non-idxonly-to-pidx-equi-join_01.3.query.sqlpp
  1. … 329 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>

    • -0
    • +64
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-pidx-to-sidx-idxonly-equi-join_01.1.ddl.sqlpp
    • -0
    • +36
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-pidx-to-sidx-idxonly-equi-join_01.2.update.sqlpp
    • -0
    • +32
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-pidx-to-sidx-idxonly-equi-join_01.3.query.sqlpp
    • -64
    • +0
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-primary-to-secondary-indexonly-plan-equi-join_01.1.ddl.sqlpp
    • -36
    • +0
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-primary-to-secondary-indexonly-plan-equi-join_01.2.update.sqlpp
    • -32
    • +0
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-primary-to-secondary-indexonly-plan-equi-join_01.3.query.sqlpp
    • -63
    • +0
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-secondary-indexonly-plan-to-primary-equi-join_01.1.ddl.sqlpp
    • -29
    • +0
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-secondary-indexonly-plan-to-primary-equi-join_01.2.update.sqlpp
    • -26
    • +0
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-secondary-indexonly-plan-to-primary-equi-join_01.3.query.sqlpp
    • -0
    • +63
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-sidx-idxonly-to-pidx-equi-join_01.1.ddl.sqlpp
    • -0
    • +29
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-sidx-idxonly-to-pidx-equi-join_01.2.update.sqlpp
    • -0
    • +26
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-sidx-idxonly-to-pidx-equi-join_01.3.query.sqlpp
    • -65
    • +0
    ./btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01/btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01.1.ddl.sqlpp
    • -29
    • +0
    ./btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01/btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01.2.update.sqlpp
    • -26
    • +0
    ./btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01/btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01.3.query.sqlpp
  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
    • +64
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-primary-to-secondary-indexonly-plan-equi-join_01.1.ddl.sqlpp
    • -0
    • +36
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-primary-to-secondary-indexonly-plan-equi-join_01.2.update.sqlpp
    • -0
    • +32
    ./btree-primary-to-secondary-indexonly-plan-equi-join_01/btree-primary-to-secondary-indexonly-plan-equi-join_01.3.query.sqlpp
    • -0
    • +52
    ./btree-secondary-equi-join_04/btree-secondary-equi-join_04.1.ddl.sqlpp
    • -0
    • +29
    ./btree-secondary-equi-join_04/btree-secondary-equi-join_04.2.update.sqlpp
    • -0
    • +24
    ./btree-secondary-equi-join_04/btree-secondary-equi-join_04.3.ddl.sqlpp
    • -0
    • +25
    ./btree-secondary-equi-join_04/btree-secondary-equi-join_04.4.query.sqlpp
    • -0
    • +63
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-secondary-indexonly-plan-to-primary-equi-join_01.1.ddl.sqlpp
    • -0
    • +29
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-secondary-indexonly-plan-to-primary-equi-join_01.2.update.sqlpp
    • -0
    • +26
    ./btree-secondary-indexonly-plan-to-primary-equi-join_01/btree-secondary-indexonly-plan-to-primary-equi-join_01.3.query.sqlpp
    • -0
    • +65
    ./btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01/btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01.1.ddl.sqlpp
    • -0
    • +29
    ./btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01/btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01.2.update.sqlpp
    • -0
    • +26
    ./btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01/btree-secondary-indexonly-plan-to-secondary-indexonly-plan-equi-join_01.3.query.sqlpp
    • -0
    • +66
    ./btree-secondary-non-indexonly-plan-to-primary-equi-join_01/btree-secondary-non-indexonly-plan-to-primary-equi-join_01.1.ddl.sqlpp
    • -0
    • +29
    ./btree-secondary-non-indexonly-plan-to-primary-equi-join_01/btree-secondary-non-indexonly-plan-to-primary-equi-join_01.2.update.sqlpp
  1. … 410 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>

    • -3
    • +3
    ./btree-index-nested-loop-join/btree-index-nested-loop-join.1.ddl.sqlpp
    • -3
    • +3
    ./btree-primary-equi-join/btree-primary-equi-join.1.ddl.sqlpp
    • -2
    • +2
    ./btree-secondary-equi-join_01/btree-secondary-equi-join_01.1.ddl.sqlpp
    • -2
    • +2
    ./btree-secondary-equi-join_02/btree-secondary-equi-join_02.1.ddl.sqlpp
    • -2
    • +2
    ./btree-secondary-equi-join_03/btree-secondary-equi-join_03.1.ddl.sqlpp
    • -1
    • +1
    ./rtree-spatial-intersect-point/rtree-spatial-intersect-point.1.ddl.sqlpp
  1. … 2072 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>

    • -7
    • +7
    ./btree-index-nested-loop-join/btree-index-nested-loop-join.1.ddl.sqlpp
    • -8
    • +8
    ./btree-primary-equi-join/btree-primary-equi-join.1.ddl.sqlpp
    • -2
    • +2
    ./btree-secondary-equi-join_01/btree-secondary-equi-join_01.1.ddl.sqlpp
    • -2
    • +2
    ./btree-secondary-equi-join_02/btree-secondary-equi-join_02.1.ddl.sqlpp
    • -2
    • +2
    ./btree-secondary-equi-join_03/btree-secondary-equi-join_03.1.ddl.sqlpp
    • -1
    • +1
    ./rtree-spatial-intersect-point/rtree-spatial-intersect-point.1.ddl.sqlpp
  1. … 3556 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>

    • -5
    • +5
    ./btree-index-nested-loop-join/btree-index-nested-loop-join.1.ddl.sqlpp
    • -3
    • +3
    ./btree-index-nested-loop-join/btree-index-nested-loop-join.2.update.sqlpp
    • -4
    • +4
    ./btree-primary-equi-join/btree-primary-equi-join.1.ddl.sqlpp
    • -2
    • +2
    ./btree-primary-equi-join/btree-primary-equi-join.2.update.sqlpp
    • -4
    • +4
    ./btree-secondary-equi-join_01/btree-secondary-equi-join_01.1.ddl.sqlpp
    • binary
    ./btree-secondary-equi-join_01/btree-secondary-equi-join_01.2.update.sqlpp
    • -4
    • +4
    ./btree-secondary-equi-join_02/btree-secondary-equi-join_02.1.ddl.sqlpp
    • binary
    ./btree-secondary-equi-join_02/btree-secondary-equi-join_02.2.update.sqlpp
    • -4
    • +4
    ./btree-secondary-equi-join_03/btree-secondary-equi-join_03.1.ddl.sqlpp
    • binary
    ./btree-secondary-equi-join_03/btree-secondary-equi-join_03.2.update.sqlpp
    • -4
    • +4
    ./rtree-spatial-intersect-point/rtree-spatial-intersect-point.1.ddl.sqlpp
    • -2
    • +2
    ./rtree-spatial-intersect-point/rtree-spatial-intersect-point.2.update.sqlpp
  1. … 2763 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>

    • -8
    • +8
    ./btree-index-nested-loop-join/btree-index-nested-loop-join.1.ddl.sqlpp
    • -3
    • +3
    ./btree-index-nested-loop-join/btree-index-nested-loop-join.2.update.sqlpp
    • -1
    • +1
    ./btree-index-nested-loop-join/btree-index-nested-loop-join.3.query.sqlpp
    • -2
    • +2
    ./btree-primary-equi-join/btree-primary-equi-join.2.update.sqlpp
    • binary
    ./btree-secondary-equi-join_01/btree-secondary-equi-join_01.2.update.sqlpp
    • binary
    ./btree-secondary-equi-join_02/btree-secondary-equi-join_02.2.update.sqlpp
    • binary
    ./btree-secondary-equi-join_03/btree-secondary-equi-join_03.2.update.sqlpp
    • -2
    • +2
    ./rtree-spatial-intersect-point/rtree-spatial-intersect-point.2.update.sqlpp
    • -1
    • +1
    ./rtree-spatial-intersect-point/rtree-spatial-intersect-point.4.query.sqlpp
  1. … 2124 more files in changeset.