Clone Tools
  • last updated 17 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
    • +33
    ./query-ASTERIXDB-1047/query-ASTERIXDB-1047.1.ddl.sqlpp
    • -0
    • +24
    ./query-ASTERIXDB-1047/query-ASTERIXDB-1047.2.update.sqlpp
    • -0
    • +31
    ./query-ASTERIXDB-1047/query-ASTERIXDB-1047.3.query.sqlpp
    • -0
    • +19
    ./query-ASTERIXDB-1205-2/query-ASTERIXDB-1205.1.ddl.sqlpp
    • -0
    • +18
    ./query-ASTERIXDB-1205-2/query-ASTERIXDB-1205.2.update.sqlpp
    • -0
    • +30
    ./query-ASTERIXDB-1205-2/query-ASTERIXDB-1205.3.query.sqlpp
    • -0
    • +19
    ./query-ASTERIXDB-1205-3/query-ASTERIXDB-1205.1.ddl.aqlpp
    • -0
    • +18
    ./query-ASTERIXDB-1205-3/query-ASTERIXDB-1205.2.update.sqlpp
    • -0
    • +35
    ./query-ASTERIXDB-1205-3/query-ASTERIXDB-1205.3.query.sqlpp
    • -0
    • +19
    ./query-ASTERIXDB-1205/query-ASTERIXDB-1205.1.ddl.sqlpp
    • -0
    • +18
    ./query-ASTERIXDB-1205/query-ASTERIXDB-1205.2.update.sqlpp
    • -0
    • +32
    ./query-ASTERIXDB-1205/query-ASTERIXDB-1205.3.query.sqlpp
    • -0
    • +57
    ./query-ASTERIXDB-1354/query-ASTERIXDB-1354.1.ddl.sqlpp
    • -0
    • +28
    ./query-ASTERIXDB-1354/query-ASTERIXDB-1354.2.update.sqlpp
    • -0
    • +27
    ./query-ASTERIXDB-1354/query-ASTERIXDB-1354.3.query.sqlpp
  1. … 247 more files in changeset.
[ASTERIXDB-2287][SQL] Support SELECT variable.* in SQL++

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Support SELECT variable.* in SQL++

- Include variables defined by LET clauses in the

output record created by SELECT *

- Add object_concat() function

- Add tests for these new features

- Fail testcase if its source directory is missing

- Fix testcases that did not run previously because

their source directories were incorrectly specified

Change-Id: I058dc0f45072a1398f6431e0c73ce680c4d8cdc7

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

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>

    • -39
    • +0
    ./union_order_by_5/union_orderby_5.1.ddl.sqlpp
    • -26
    • +0
    ./union_order_by_5/union_orderby_5.2.update.sqlpp
    • -30
    • +0
    ./union_order_by_5/union_orderby_5.3.query.sqlpp
    • -0
    • +39
    ./union_orderby_5/union_orderby_5.1.ddl.sqlpp
    • -0
    • +26
    ./union_orderby_5/union_orderby_5.2.update.sqlpp
    • -0
    • +30
    ./union_orderby_5/union_orderby_5.3.query.sqlpp
  1. … 135 more files in changeset.
[ASTERIXDB-2170][SQL] Fix resolution order of implicit field access

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Improved name resolution rules

- Resolve field access to the nearest variable in scope

instead of raising compile-time error

- Do not rely on type information when resolving names

- Cleanup group variable handling in GroupBy clause,

no longer use ‘with’ map for it

- Fix ByNameToByIndexFieldAccessRule to use type environment

of its input operator when analyzing its expression

- Fix ExternalGroupByPOperator to use input schema of its

aggregate function when generating runtime for that function

- Fix invalid free variable computation for GroupBy clause

Change-Id: I50bc823ff53da06507a5454b30f4f500b862d4bf

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

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

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

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

    • -39
    • +0
    ./union_negative_2/union_negative_2.1.ddl.sqlpp
    • -26
    • +0
    ./union_negative_2/union_negative_2.2.update.sqlpp
    • -30
    • +0
    ./union_negative_2/union_negative_2.3.query.sqlpp
    • -0
    • +39
    ./union_order_by_5/union_orderby_5.1.ddl.sqlpp
    • -0
    • +26
    ./union_order_by_5/union_orderby_5.2.update.sqlpp
    • -0
    • +30
    ./union_order_by_5/union_orderby_5.3.query.sqlpp
  1. … 309 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>

    • -2
    • +2
    ./query-ASTERIXDB-1354-2/query-ASTERIXDB-1354-2.1.ddl.sqlpp
    • -1
    • +1
    ./query-ASTERIXDB-1629/query-ASTERIXDB-1629.1.ddl.sqlpp
    • -2
    • +2
    ./union_heterogeneous_scalar/union_heterogeneous_scalar.1.ddl.sqlpp
    • -1
    • +1
    ./union_negative/union_negative.1.ddl.sqlpp
    • -2
    • +2
    ./union_negative_2/union_negative_2.1.ddl.sqlpp
    • -2
    • +2
    ./union_orderby/union_orderby.1.ddl.sqlpp
    • -2
    • +2
    ./union_orderby_2/union_orderby_2.1.ddl.sqlpp
    • -2
    • +2
    ./union_orderby_3/union_orderby_3.1.ddl.sqlpp
    • -2
    • +2
    ./union_orderby_4/union_orderby_4.1.ddl.sqlpp
  1. … 2068 more files in changeset.
fix error message for union with set semantics

Change-Id: I2b69ab843795221ef5c9a533839ed6d359b7c8e3

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

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>

    • -0
    • +20
    ./union_negative_3/union_negative_3.1.query.sqlpp
  1. … 2 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>

    • -8
    • +8
    ./query-ASTERIXDB-1354-2/query-ASTERIXDB-1354-2.1.ddl.sqlpp
    • -5
    • +5
    ./query-ASTERIXDB-1629/query-ASTERIXDB-1629.1.ddl.sqlpp
    • -2
    • +2
    ./union_heterogeneous_scalar/union_heterogeneous_scalar.1.ddl.sqlpp
    • -1
    • +1
    ./union_negative/union_negative.1.ddl.sqlpp
    • -2
    • +2
    ./union_negative_2/union_negative_2.1.ddl.sqlpp
    • -2
    • +2
    ./union_orderby/union_orderby.1.ddl.sqlpp
    • -2
    • +2
    ./union_orderby_2/union_orderby_2.1.ddl.sqlpp
    • -2
    • +2
    ./union_orderby_3/union_orderby_3.1.ddl.sqlpp
    • -2
    • +2
    ./union_orderby_4/union_orderby_4.1.ddl.sqlpp
  1. … 3552 more files in changeset.
ASTERIXDB-1629: fix the open record constructor type computer.

Change-Id: I1a6ad39a889a774d6e448b2efe90134b5490f7c8

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

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>

    • -0
    • +43
    ./query-ASTERIXDB-1629/query-ASTERIXDB-1629.1.ddl.sqlpp
    • -0
    • +24
    ./query-ASTERIXDB-1629/query-ASTERIXDB-1629.2.update.sqlpp
    • -0
    • +24
    ./query-ASTERIXDB-1629/query-ASTERIXDB-1629.3.query.sqlpp
  1. … 3 more files in changeset.
Support UNION ALL.

- support heterogenous input types for UNION ALL and the output is resolved to a mimimally generalized type;

- fix the partitioning property inference for UnionAllPOperator;

- fix for ASTERIXDB-1354, a bug in IsomorphismVariableMappingVisitor.

Change-Id: Ifadf1707bb2b6bed22f8fc5792c635e87291a468

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

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

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

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

    • -0
    • +57
    ./query-ASTERIXDB-1354-2/query-ASTERIXDB-1354-2.1.ddl.sqlpp
    • -0
    • +28
    ./query-ASTERIXDB-1354-2/query-ASTERIXDB-1354-2.2.update.sqlpp
    • -0
    • +31
    ./query-ASTERIXDB-1354-2/query-ASTERIXDB-1354-2.3.query.sqlpp
    • -0
    • +39
    ./union_heterogeneous_scalar/union_heterogeneous_scalar.1.ddl.sqlpp
    • -0
    • +26
    ./union_heterogeneous_scalar/union_heterogeneous_scalar.2.update.sqlpp
    • -0
    • +35
    ./union_heterogeneous_scalar/union_heterogeneous_scalar.3.query.sqlpp
    • -0
    • +32
    ./union_negative/union_negative.1.ddl.sqlpp
    • -0
    • +24
    ./union_negative/union_negative.2.update.sqlpp
    • -0
    • +32
    ./union_negative/union_negative.3.query.sqlpp
    • -0
    • +39
    ./union_negative_2/union_negative_2.1.ddl.sqlpp
    • -0
    • +26
    ./union_negative_2/union_negative_2.2.update.sqlpp
    • -0
    • +30
    ./union_negative_2/union_negative_2.3.query.sqlpp
    • -0
    • +41
    ./union_orderby/union_orderby.1.ddl.sqlpp
    • -0
    • +26
    ./union_orderby/union_orderby.2.update.sqlpp
  1. … 58 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. … 2773 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. … 2130 more files in changeset.