Clone Tools
  • last updated 10 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
    • +35
    ./big_object_bulkload/big_object_bulkload.1.ddl.sqlpp
    • -0
    • +119
    ./big_object_bulkload/big_object_bulkload.2.update.sqlpp
    • -0
    • +22
    ./big_object_bulkload/big_object_bulkload.3.query.sqlpp
    • -0
    • +45
    ./big_object_feed_20M/big_object_feed_20M.1.ddl.sqlpp
    • -0
    • +34
    ./big_object_feed_20M/big_object_feed_20M.2.update.sqlpp
    • -0
    • +23
    ./big_object_feed_20M/big_object_feed_20M.3.query.sqlpp
    • -0
    • +35
    ./big_object_insert/big_object_insert.1.ddl.sqlpp
    • -0
    • +119
    ./big_object_insert/big_object_insert.2.update.sqlpp
    • -0
    • +24
    ./big_object_insert/big_object_insert.3.query.sqlpp
    • -0
    • +36
    ./big_object_load_only_20M/big_object_load_only_20M.1.ddl.sqlpp
    • -0
    • +33
    ./big_object_load_only_20M/big_object_load_only_20M.2.update.sqlpp
    • -0
    • +22
    ./big_object_load_only_20M/big_object_load_only_20M.3.query.sqlpp
  1. … 250 more files in changeset.
[NO ISSUE][TEST] Add semicolon to recent added SQLPP tests

Quick fix for syntax error of recent added test cases.

Change-Id: I5ab4d6c87f297daa39feeabedd0067cc3f86889c

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

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

Reviewed-by: abdullah alamoudi <bamousaa@gmail.com>

Tested-by: Xikui Wang <xkkwww@gmail.com>

    • -1
    • +1
    ./big_object_groupby/big_object_groupby.3.query.sqlpp
  1. … 4 more files in changeset.
[ASTERIXDB-1812][RT] Budget the memory usage for pre-clustered group-by.

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- let pre-clustered group-by consider memory budget.

Change-Id: I670269b0b8f446d06d8dd73202194574aa524e85

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

Sonar-Qube: 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>

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

    • -0
    • +1
    ./big_object_groupby/big_object_groupby.3.query.sqlpp
  1. … 27 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
    ./big_object_groupby-2/big_object_groupby.1.ddl.sqlpp
    • -3
    • +3
    ./big_object_groupby/big_object_groupby.1.ddl.sqlpp
    • -3
    • +3
    ./big_object_join/big_object_join.1.ddl.sqlpp
    • -3
    • +3
    ./big_object_load/big_object_load.1.ddl.sqlpp
    • -1
    • +1
    ./big_object_load_20M/big_object_load_20M.1.ddl.sqlpp
    • -1
    • +1
    ./big_object_load_20M/big_object_load_20M.2.update.sqlpp
    • -3
    • +3
    ./big_object_sort/big_object_sort.1.ddl.sqlpp
  1. … 2071 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>

    • -1
    • +2
    ./big_object_groupby/big_object_groupby.3.query.sqlpp
  1. … 261 more files in changeset.
ASTERIXDB-1760: support per-query customizations for compilation parameters.

Change-Id: I6e18f3f7706e574553a02e15a39daddda3c413b2

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

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

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>

    • -0
    • +36
    ./big_object_load_20M/big_object_load_20M.1.ddl.sqlpp
    • -0
    • +32
    ./big_object_load_20M/big_object_load_20M.2.update.sqlpp
    • -0
    • +24
    ./big_object_load_20M/big_object_load_20M.3.query.sqlpp
  1. … 7 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>

    • -9
    • +9
    ./big_object_groupby-2/big_object_groupby.1.ddl.sqlpp
    • -9
    • +9
    ./big_object_groupby/big_object_groupby.1.ddl.sqlpp
    • -9
    • +9
    ./big_object_join/big_object_join.1.ddl.sqlpp
    • -9
    • +9
    ./big_object_load/big_object_load.1.ddl.sqlpp
    • -9
    • +9
    ./big_object_sort/big_object_sort.1.ddl.sqlpp
  1. … 3557 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
    ./big_object_groupby-2/big_object_groupby.1.ddl.sqlpp
    • -5
    • +5
    ./big_object_groupby/big_object_groupby.1.ddl.sqlpp
    • -5
    • +5
    ./big_object_join/big_object_join.1.ddl.sqlpp
    • -5
    • +5
    ./big_object_load/big_object_load.1.ddl.sqlpp
    • -5
    • +5
    ./big_object_sort/big_object_sort.1.ddl.sqlpp
  1. … 2770 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
    ./big_object_groupby-2/big_object_groupby.1.ddl.sqlpp
    • -2
    • +2
    ./big_object_groupby-2/big_object_groupby.3.query.sqlpp
    • -3
    • +3
    ./big_object_groupby/big_object_groupby.1.ddl.sqlpp
    • -3
    • +3
    ./big_object_join/big_object_join.1.ddl.sqlpp
    • -2
    • +2
    ./big_object_join/big_object_join.3.query.sqlpp
    • -3
    • +3
    ./big_object_load/big_object_load.1.ddl.sqlpp
    • -2
    • +2
    ./big_object_load/big_object_load.3.query.sqlpp
    • -3
    • +3
    ./big_object_sort/big_object_sort.1.ddl.sqlpp
    • -2
    • +2
    ./big_object_sort/big_object_sort.3.query.sqlpp
  1. … 2124 more files in changeset.