Clone Tools
  • last updated a few minutes 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
    ./tinysocial-suite-open/query-ASTERIXDB-1331.25.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.14.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.22.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.14.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.22.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.25.query.sqlpp
  1. … 274 more files in changeset.
[ASTERIXDB-2272][FUN] Count character positions from 0

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Count character positions in strings, binary from 0 instead of 1

- Affects following built-in functions:

position(), regexp_position(), substr()/subtring(),

sub_binary(), find-binary()

- Introduce new configuration property “compiler.stringoffset”

for backward compatibility

compiler.stringoffset = 0 - count from 0 (new default)

compiler.stringoffset = 1 - count from 1 (backwards-compatible setting)

Change-Id: Icdb2c241983d5f592b2695ef16eae9951518d7fd

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

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

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

    • -1
    • +1
    ./tinysocial-suite-open/query-ASTERIXDB-1329.24.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.24.query.sqlpp
  1. … 107 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>

    • -4
    • +4
    ./tinysocial-suite-open/tinysocial-suite.1.ddl.sqlpp
    • -5
    • +5
    ./tinysocial-suite/tinysocial-suite.1.ddl.sqlpp
  1. … 2076 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>

    • -5
    • +6
    ./tinysocial-suite-open/query-ASTERIXDB-1063.23.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.15.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.16.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.17.query.sqlpp
    • -5
    • +7
    ./tinysocial-suite/query-ASTERIXDB-1063.23.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.15.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.16.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.17.query.sqlpp
  1. … 254 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
    ./tinysocial-suite-open/group-by.26.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
    ./tinysocial-suite-open/query-ASTERIXDB-1331.25.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.14.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.22.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.14.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.22.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.25.query.sqlpp
  1. … 379 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
    ./tinysocial-suite-open/query-ASTERIXDB-1331.25.query.sqlpp
    • -2
    • +2
    ./tinysocial-suite-open/tinysocial-suite.1.ddl.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.14.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.2.ddl.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.22.query.sqlpp
    • -8
    • +8
    ./tinysocial-suite/tinysocial-suite.1.ddl.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.14.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.22.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.25.query.sqlpp
  1. … 3553 more files in changeset.
Fix open field CREATE INDEX syntax (AQL and SQLPP).

Our CREATE INDEX syntax for open fields didn't match our semantics.

Our semantics allow to-be-indexed open field(s) to be MISSING.

We don't support (or offer :-)) tighter semantics than that.

Our syntax didn't require creators to say this, but now it does:

Old: CREATE INDEX myIdx on MyDSet(myTime: datetime) ENFORCED;

New: CREATE INDEX myIdx on MyDSet(myTime: datetime?) ENFORCED;

Have now addressed all of Till's comments (I think).

Change-Id: I32bf8bc5ac1c0e6aa6744ca8f91a197311219814

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

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>

    • -2
    • +2
    ./tinysocial-suite-open/tinysocial-suite.2.ddl.sqlpp
  1. … 787 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
    ./tinysocial-suite-open/tinysocial-suite.1.ddl.sqlpp
    • -4
    • +4
    ./tinysocial-suite-open/tinysocial-suite.2.ddl.sqlpp
    • -4
    • +4
    ./tinysocial-suite-open/tinysocial-suite.3.update.sqlpp
    • -2
    • +2
    ./tinysocial-suite/tinysocial-suite.1.ddl.sqlpp
    • -4
    • +4
    ./tinysocial-suite/tinysocial-suite.2.ddl.sqlpp
    • -4
    • +4
    ./tinysocial-suite/tinysocial-suite.3.update.sqlpp
  1. … 2769 more files in changeset.
Support SQL-compilant delete syntax.

Change-Id: Ifdd4acf3772cac1a21bb56a7eba4be51abbb5068

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

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
    ./tinysocial-suite-open/tinysocial-suite.21.update.sqlpp
    • -2
    • +2
    ./tinysocial-suite/tinysocial-suite.21.update.sqlpp
  1. … 49 more files in changeset.
Add IS (NOT) NULL/MISSING/UNKOWN.

Change-Id: I7e4008d97f0d3a92816b90492dd8c887b05bac27

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

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

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

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

    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.12.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.13.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.12.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.13.query.sqlpp
  1. … 40 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>

    • -5
    • +5
    ./tinysocial-suite-open/aggregate.27.query.sqlpp
    • -6
    • +6
    ./tinysocial-suite-open/group-by.26.query.sqlpp
    • -6
    • +6
    ./tinysocial-suite-open/query-ASTERIXDB-1063.23.query.sqlpp
    • -3
    • +3
    ./tinysocial-suite-open/query-ASTERIXDB-1329.24.query.sqlpp
    • -2
    • +2
    ./tinysocial-suite-open/query-ASTERIXDB-1331.25.query.sqlpp
    • -2
    • +2
    ./tinysocial-suite-open/tinysocial-suite.1.ddl.sqlpp
    • -5
    • +5
    ./tinysocial-suite-open/tinysocial-suite.10.query.sqlpp
    • -3
    • +3
    ./tinysocial-suite-open/tinysocial-suite.11.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.12.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.13.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.15.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.16.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.17.query.sqlpp
    • -4
    • +4
    ./tinysocial-suite-open/tinysocial-suite.18.query.sqlpp
    • -5
    • +5
    ./tinysocial-suite-open/tinysocial-suite.2.ddl.sqlpp
  1. … 2118 more files in changeset.
Supports Left Outer Join and Left Outer Unnest in SQL++.

- change record format to allow MISSING value for an optional field;

- support roundtrips of MISSING valued closed fields for load and insert;

- suppress fields with MISSING values in result printer;

- fix ByNameToByIndexFieldAccessRule and LoadRecordFieldsRule;

- update test queries and results.

Change-Id: Ie0caea9c1842d93541b067a1193d117af30d8dfc

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

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

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

    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.12.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.13.query.sqlpp
  1. … 584 more files in changeset.
Let SQL-92 aggregate functions behave the same as SQL-92.

Change-Id: Ia2929d1ca6344508bbf772884ea8ef1f39a0e19f

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

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

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

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

    • -0
    • +29
    ./tinysocial-suite-open/aggregate.27.query.sqlpp
    • -0
    • +31
    ./tinysocial-suite-open/group-by.26.query.sqlpp
  1. … 92 more files in changeset.
ASTERIXDB-1228: Add MISSING into the data model.

1. MISSING repsents the value of a non-existing field in a record

or an out-of-bound index access of a collection;

2. NULL represents that the value of an optional field in a record

is unknown or the value of existing collection entry is unknown.

3. Unit tests for all missing/null-in-missing/null-out scalar functions.

Change-Id: Ia49ed8474bfc5d6604231819065117468c5b0897

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

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

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

    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.12.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.13.query.sqlpp
  1. … 550 more files in changeset.
Merge branch 'master' into hyracks-merge2

    • -2
    • +2
    ./tinysocial-suite-open/query-ASTERIXDB-1331.25.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.14.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite-open/tinysocial-suite.22.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.14.query.sqlpp
    • -1
    • +1
    ./tinysocial-suite/tinysocial-suite.22.query.sqlpp
    • -2
    • +2
    ./tinysocial-suite/tinysocial-suite.25.query.sqlpp
  1. … 479 more files in changeset.