Clone Tools
  • last updated 13 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.