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

    • -1
    • +1
    ./btree-index-join/disjunction-to-join.sqlpp
    • -3
    • +3
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp
    • -3
    • +3
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp
    • -3
    • +3
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp
    • -3
    • +3
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp
    • -2
    • +2
    ./btree-index-join/secondary-composite-key-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/secondary-composite-key-join_02.sqlpp
    • -2
    • +2
    ./btree-index-join/secondary-composite-key-join_03.sqlpp
    • -2
    • +2
    ./btree-index-join/secondary-composite-key-prefix-join_01.sqlpp
    • -2
    • +2
    ./btree-index-join/secondary-composite-key-prefix-join_02.sqlpp
    • -2
    • +2
    ./btree-index-join/secondary-composite-key-prefix-join_03.sqlpp
    • -2
    • +2
    ./btree-index-join/secondary-composite-key-prefix-join_04.sqlpp
    • -2
    • +2
    ./btree-index-join/secondary-composite-key-prefix-join_05.sqlpp
    • -2
    • +2
    ./btree-index-join/secondary-composite-key-prefix-join_06.sqlpp
    • -4
    • +4
    ./btree-index-join/secondary-equi-join-multiindex.sqlpp
  1. … 2063 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_1.sqlpp
    • -7
    • +7
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp
    • -7
    • +7
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp
    • -7
    • +7
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-join_01.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-join_02.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-join_03.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_01.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_02.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_03.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_04.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_05.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_06.sqlpp
    • -8
    • +8
    ./btree-index-join/secondary-equi-join-multiindex.sqlpp
    • -2
    • +2
    ./btree-index-join/secondary-equi-join-multipred.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
    ./btree-index-join/disjunction-to-join.sqlpp
    • -1
    • +1
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp
    • -2
    • +2
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp
    • -1
    • +1
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp
    • -2
    • +2
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-join_01.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-join_02.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-join_03.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_01.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_02.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_03.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_04.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_05.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-composite-key-prefix-join_06.sqlpp
    • -1
    • +1
    ./btree-index-join/secondary-equi-join-multiindex.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/disjunction-to-join.sqlpp
    • -3
    • +3
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp
    • -3
    • +3
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp
    • -3
    • +3
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp
    • -3
    • +3
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp
    • -3
    • +3
    ./btree-index-join/secondary-composite-key-join_01.sqlpp
    • -3
    • +3
    ./btree-index-join/secondary-composite-key-join_02.sqlpp
    • -3
    • +3
    ./btree-index-join/secondary-composite-key-join_03.sqlpp
    • -3
    • +3
    ./btree-index-join/secondary-composite-key-prefix-join_01.sqlpp
    • -3
    • +3
    ./btree-index-join/secondary-composite-key-prefix-join_02.sqlpp
    • -3
    • +3
    ./btree-index-join/secondary-composite-key-prefix-join_03.sqlpp
    • -3
    • +3
    ./btree-index-join/secondary-composite-key-prefix-join_04.sqlpp
    • -3
    • +3
    ./btree-index-join/secondary-composite-key-prefix-join_05.sqlpp
    • -3
    • +3
    ./btree-index-join/secondary-composite-key-prefix-join_06.sqlpp
    • -4
    • +4
    ./btree-index-join/secondary-equi-join-multiindex.sqlpp
  1. … 2760 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. … 455 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
    • +1
    ./btree-index-join/disjunction-to-join.sqlpp
    • -8
    • +8
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_1.sqlpp
    • -8
    • +8
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01_2.sqlpp
    • -8
    • +8
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_1.sqlpp
    • -8
    • +8
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02_2.sqlpp
    • -16
    • +16
    ./btree-index-join/secondary-equi-join-multiindex.sqlpp
    • -1
    • +1
    ./btree-index/btree-secondary-62.sqlpp
    • -1
    • +1
    ./btree-index/btree-secondary-63.sqlpp
    • -1
    • +1
    ./inverted-index-basic/ngram-edit-distance-check-panic.sqlpp
    • -1
    • +1
    ./inverted-index-basic/ngram-edit-distance-check.sqlpp
    • -1
    • +1
    ./inverted-index-basic/ngram-edit-distance-panic.sqlpp
    • -1
    • +1
    ./inverted-index-basic/ngram-edit-distance.sqlpp
    • -2
    • +2
    ./inverted-index-basic/ngram-fuzzyeq-edit-distance.sqlpp
    • -4
    • +4
    ./inverted-index-basic/ngram-fuzzyeq-jaccard.sqlpp
    • -2
    • +2
    ./inverted-index-basic/ngram-jaccard-check.sqlpp
  1. … 2118 more files in changeset.