Clone Tools
  • last updated 24 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[NO ISSUE] Support multipart dataverse names

- user model changes: yes

- storage format changes: no

- interface changes: yes

Details:

- Support dataverse names that consist of multiple parts

- Introduce DataverseName class and adopt it throughout the system

- Add testcases for multipart dataverse names

Change-Id: I1313b2dc0e8df6a9b0ded48dea122afc3ba5dbe7

Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/4004

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

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

Reviewed-by: Murtadha Hubail <mhubail@apache.org>

    • -2
    • +2
    ./btree-index-join/primary-equi-join-neg_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-equi-join-neg_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-equi-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-equi-join_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-ge-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-ge-join_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-gt-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-gt-join_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-le-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-le-join_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-lt-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-lt-join_02.sqlpp
  1. … 270 more files in changeset.
[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>

    • -2
    • +2
    ./inlined_q18_large_volume_customer.sqlpp
  1. … 267 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. … 108 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>

    • -16
    • +16
    ./q01_pricing_summary_report_nt.sqlpp
    • -2
    • +2
    ./split-materialization-above-join.sqlpp
  1. … 309 more files in changeset.
[ASTERIXDB-2015][IDX] Introduce Primary Index Optimization Rule

- user model changes: no

- storage format changes: no

- interface changes: no

details:

This is the optimization rule that will optimize aggregation queries

when only PKs are involved. The rule will use the primary index and

replace the dataset scan or unnest-map operator.

Change-Id: I3bbb2b5e1f25e61928d73b866e91c592ce0bf954

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

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

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: Dmitry Lychagin <dmitry.lychagin@couchbase.com>

    • -0
    • +45
    ./btree-index/btree-secondary-64.sqlpp
    • -0
    • +45
    ./btree-index/btree-secondary-65.sqlpp
    • -0
    • +45
    ./btree-index/btree-secondary-66.sqlpp
    • -0
    • +45
    ./btree-index/btree-secondary-67.sqlpp
  1. … 30 more files in changeset.
[ASTERIXDB-1984][COMP] probe-subtree init not required

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Let the IntroduceJoinAccessMethod accept arbitrary

forms of sub-tree for the probe-tree.

Change-Id: Ib353c85bf627d8dd65dba0ea307dee428edb4a26

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

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>

    • -0
    • +44
    ./btree-index-join/secondary-equi-join_04.sqlpp
    • -0
    • +42
    ./btree-index-join/secondary-equi-join_05.sqlpp
    • -0
    • +43
    ./btree-index-join/secondary-equi-join_06.sqlpp
  1. … 7 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-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp
    • -3
    • +3
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-composite-key-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-composite-key-join_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-composite-key-join_03.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-composite-key-prefix-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-composite-key-prefix-join_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-composite-key-prefix-join_03.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-composite-key-prefix-join_04.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-composite-key-prefix-join_05.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-composite-key-prefix-join_06.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-equi-join-multipred.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-equi-join-neg_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-equi-join-neg_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-equi-join_01.sqlpp
  1. … 2063 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>

    • -2
    • +2
    ./inlined_q18_large_volume_customer.sqlpp
  1. … 372 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-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp
    • -7
    • +7
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp
    • -6
    • +6
    ./btree-index-join/primary-equi-join-multipred.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-equi-join-neg_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-equi-join-neg_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-equi-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-equi-join_02.sqlpp
    • -6
    • +6
    ./btree-index-join/primary-equi-join_03.sqlpp
    • -6
    • +6
    ./btree-index-join/primary-equi-join_04.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-equi-join_05.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-ge-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-ge-join_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-gt-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-gt-join_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-le-join_01.sqlpp
  1. … 3547 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>

    • -1
    • +1
    ./nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp
    • -2
    • +2
    ./nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp
    • -1
    • +1
    ./nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp
    • -2
    • +2
    ./nested-open-index/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp
    • -1
    • +1
    ./nested-open-index/btree-index-join/secondary-composite-key-prefix-join_01.sqlpp
    • -1
    • +1
    ./nested-open-index/btree-index-join/secondary-composite-key-prefix-join_02.sqlpp
    • -1
    • +1
    ./nested-open-index/btree-index-join/secondary-composite-key-prefix-join_03.sqlpp
    • -1
    • +1
    ./nested-open-index/btree-index-join/secondary-composite-key-prefix-join_04.sqlpp
  1. … 773 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>

    • -3
    • +3
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp
    • -3
    • +3
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp
    • -3
    • +3
    ./btree-index-join/primary-composite-key-join_01.sqlpp
    • -3
    • +3
    ./btree-index-join/primary-composite-key-join_02.sqlpp
    • -3
    • +3
    ./btree-index-join/primary-composite-key-join_03.sqlpp
    • -3
    • +3
    ./btree-index-join/primary-composite-key-prefix-join_01.sqlpp
    • -3
    • +3
    ./btree-index-join/primary-composite-key-prefix-join_02.sqlpp
    • -3
    • +3
    ./btree-index-join/primary-composite-key-prefix-join_03.sqlpp
    • -3
    • +3
    ./btree-index-join/primary-composite-key-prefix-join_04.sqlpp
    • -3
    • +3
    ./btree-index-join/primary-composite-key-prefix-join_05.sqlpp
    • -3
    • +3
    ./btree-index-join/primary-composite-key-prefix-join_06.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-equi-join-multipred.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-equi-join-neg_01.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-equi-join-neg_02.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-equi-join_01.sqlpp
  1. … 2760 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
    ./scan-delete-rtree-secondary-index.sqlpp
    • -2
    • +2
    ./skip-index/dont-skip-primary-index-search-in-delete.sqlpp
    • -2
    • +2
    ./skip-index/skip-ngram-index-search-in-delete.sqlpp
    • -2
    • +2
    ./skip-index/skip-rtree-index-search-in-delete.sqlpp
    • -2
    • +2
    ./skip-index/skip-secondary-btree-index-search-in-delete.sqlpp
    • -2
    • +2
    ./skip-index/skip-word-index-search-in-delete.sqlpp
  1. … 40 more files in changeset.
Hard Tabs++

Eliminate more hard tabs, widen scope of checkstyle rules to prevent regressions.

Relax whitespace expectations in polygon ctor

Change-Id: Ia3f78fc6705bc79a21cfa97fdfcad30998ab1058

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

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
    ./inverted-index-join/word-jaccard-check-after-btree-access.sqlpp
  1. … 447 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. … 43 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>

    • -11
    • +11
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.sqlpp
    • -11
    • +11
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.sqlpp
    • -1
    • +1
    ./btree-index-join/primary-equi-join-multipred.sqlpp
    • -3
    • +3
    ./btree-index-join/primary-equi-join-neg_01.sqlpp
    • -3
    • +3
    ./btree-index-join/primary-equi-join-neg_02.sqlpp
    • -2
    • +2
    ./btree-index-join/primary-equi-join_01.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-equi-join_02.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-ge-join_01.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-ge-join_02.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-gt-join_01.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-gt-join_02.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-le-join_01.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-le-join_02.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-lt-join_01.sqlpp
    • -4
    • +4
    ./btree-index-join/primary-lt-join_02.sqlpp
  1. … 2118 more files in changeset.
Merge branch 'master' into hyracks-merge2

    • -2
    • +2
    ./inlined_q18_large_volume_customer.sqlpp
  1. … 470 more files in changeset.