Clone Tools
  • last updated 20 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
    • +36
    ./delete-dataset-with-meta/delete-dataset-with-meta.1.ddl.sqlpp
    • -0
    • +28
    ./delete-dataset-with-meta/delete-dataset-with-meta.2.update.sqlpp
    • -0
    • +36
    ./insert-dataset-with-meta/insert-dataset-with-meta.1.ddl.sqlpp
    • -0
    • +29
    ./insert-dataset-with-meta/insert-dataset-with-meta.2.update.sqlpp
    • -0
    • +53
    ./insert-duplicated-keys-from-query/insert-duplicated-keys-from-query.1.ddl.sqlpp
    • -0
    • +43
    ./insert-duplicated-keys-from-query/insert-duplicated-keys-from-query.2.update.sqlpp
    • -0
    • +21
    ./insert-duplicated-keys-from-query/insert-duplicated-keys-from-query.3.ddl.sqlpp
    • -0
    • +34
    ./insert-returning-fieldname-qualified/insert-returning-fieldname-qualified.1.ddl.sqlpp
    • -0
    • +30
    ./insert-returning-fieldname-qualified/insert-returning-fieldname-qualified.3.query.sqlpp
    • -0
    • +34
    ./load-with-autogenerated-no-field/load-with-autogenerated-no-field.1.ddl.sqlpp
    • -0
    • +30
    ./load-with-index-open_02/load-with-index-open_02.1.ddl.sqlpp
    • -0
    • +23
    ./load-with-index-open_02/load-with-index-open_02.2.update.sqlpp
    • -0
    • +21
    ./load-with-index-open_02/load-with-index-open_02.3.query.sqlpp
    • -0
    • +20
    ./load-with-index-open_02/load-with-index-open_02.4.ddl.sqlpp
    • -0
    • +28
    ./query-ASTERIXDB-1406/query-ASTERIXDB-1406.1.ddl.sqlpp
  1. … 247 more files in changeset.
[NO ISSUE] Fix comment of concurrent merge policy test

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Fix the comment of the test case using-concurrent-merge-policy.

Change-Id: I363f5739ac4bb2a9dd14df7be97372eb1e838dd6

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

Reviewed-by: Luo Chen <cluo8@uci.edu>

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: Murtadha Hubail <mhubail@apache.org>

    • -2
    • +1
    ./using-concurrent-merge-policy/using-concurrent-merge-policy.1.ddl.sqlpp
[ASTERIXDB-2600][STO] Introduce ConcurrentMergePolicy

- user model changes: yes. Add a new merge policy and make it as default

- storage format changes: no.

- interface changes: no.

Details:

- Introduce ConcurrentMergePolicy that performs concurrent merges

without the maximum component size.

- Make this merge policy as the default merge policy in AsterixDB since

the PrefixMergePolicy has made some wrong design decisions.

Change-Id: I2ed79847584b9fe846d62ad56ee094863538a2a2

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

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

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

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

Reviewed-by: Luo Chen <cluo8@uci.edu>

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

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

    • -0
    • +60
    ./using-concurrent-merge-policy/using-concurrent-merge-policy.1.ddl.sqlpp
    • -0
    • +24
    ./using-concurrent-merge-policy/using-concurrent-merge-policy.2.update.sqlpp
    • -0
    • +27
    ./using-concurrent-merge-policy/using-concurrent-merge-policy.3.ddl.sqlpp
    • -0
    • +24
    ./using-concurrent-merge-policy/using-concurrent-merge-policy.4.update.sqlpp
    • -0
    • +27
    ./using-concurrent-merge-policy/using-concurrent-merge-policy.5.query.sqlpp
  1. … 28 more files in changeset.
[ASTERIXDB-2535][COMP] Fix uuid present in insert/upsert statement

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Added a new record merge function, extending the old one, to handle

the merge of duplicate fields.

- Updated the record merge type computer to handle the merge of

duplicate fields properly at compile time.

- Added a new record merge descriptor and evaluator, extending

the old one, to handle the merge of duplicate fields properly

at runtime.

- Updated IntroduceAutogenerateIDRule to use the new record merge

function.

- Added test cases to test the newly added function for insert

and upsert statements.

Change-Id: I22100d3ff29864b8bfd54b0decb183e5056fdb4a

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

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

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

Reviewed-by: Hussain Towaileb <hussainht@gmail.com>

    • -0
    • +33
    ./insert_nested_uuid_autogenerate/insert_nested_uuid_autogenerate.1.ddl.sqlpp
    • -0
    • +24
    ./insert_nested_uuid_autogenerate/insert_nested_uuid_autogenerate.2.update.sqlpp
    • -0
    • +23
    ./insert_nested_uuid_autogenerate/insert_nested_uuid_autogenerate.3.query.sqlpp
    • -0
    • +33
    ./insert_nested_uuid_manual/insert_nested_uuid_manual.1.ddl.sqlpp
    • -0
    • +24
    ./insert_nested_uuid_manual/insert_nested_uuid_manual.2.update.sqlpp
    • -0
    • +23
    ./insert_nested_uuid_manual/insert_nested_uuid_manual.3.query.sqlpp
    • -0
    • +33
    ./insert_nested_uuid_manual_exists/insert_nested_uuid_manual_exists.1.ddl.sqlpp
    • -0
    • +31
    ./insert_nested_uuid_manual_exists/insert_nested_uuid_manual_exists.2.update.sqlpp
    • -0
    • +33
    ./insert_nested_uuid_manual_exists_select/insert_nested_uuid_manual_exists_select.1.ddl.sqlpp
    • -0
    • +33
    ./insert_nested_uuid_manual_exists_select/insert_nested_uuid_manual_exists_select.2.update.sqlpp
    • -0
    • +29
    ./insert_uuid_autogenerate/insert_uuid_autogenerate.1.ddl.sqlpp
    • -0
    • +24
    ./insert_uuid_autogenerate/insert_uuid_autogenerate.2.update.sqlpp
    • -0
    • +23
    ./insert_uuid_autogenerate/insert_uuid_autogenerate.3.query.sqlpp
    • -0
    • +29
    ./insert_uuid_manual/insert_uuid_manual.1.ddl.sqlpp
    • -0
    • +24
    ./insert_uuid_manual/insert_uuid_manual.2.update.sqlpp
  1. … 53 more files in changeset.
[ASTERIXDB-2310][STO]Enforce Key Uniquness using PKIndex

- user model changes: no

- storage format changes: yes. Primary key index

now has bloom filters.

- interface changes: no

Details:

- Add bloom filters to primary key index.

- Introduce LSMPrimaryInsertOperator to separate uniqueness check from

the primary index. When the primary key index is available, it will be

used for uniqueness check. This implementation of this operation is

similar to LSMPrimaryUpsertOperator.

Change-Id: I7a52bb75ee5b14521972999df2f45ba62adc5af1

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

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: Murtadha Hubail <mhubail@apache.org>

    • -0
    • +40
    ./insert-duplicated-keys-with-pk-index/insert-duplicated-keys.1.ddl.sqlpp
    • -0
    • +30
    ./insert-duplicated-keys-with-pk-index/insert-duplicated-keys.2.update.sqlpp
    • -0
    • +21
    ./insert-duplicated-keys-with-pk-index/insert-duplicated-keys.3.ddl.sqlpp
    • -2
    • +0
    ./insert-duplicated-keys/insert-duplicated-keys.1.ddl.sqlpp
  1. … 49 more files in changeset.
[ASTERIXDB-2539][COMP] Exclude LET variables from "Single Variable Resolution" rule

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Variables introduced by LET clauses should not be

considered by "Single Variable Resolution" rule

- In INSERT/UPSERT statements with RETURNING expression

the automatically introduced variable should be named

as the target dataset

- Refactor VariableCheckAndRewriteVisitor and

other code related to name resolution

- Added testcases and updated documentation

Change-Id: I9b9f70a1671378f5216ec4e30416d4d67c3df089

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

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

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

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

    • -0
    • +37
    ./insert-returning-fieldname-implicit-2/insert-returning-fieldname-implicit-2.1.ddl.sqlpp
    • -0
    • +30
    ./insert-returning-fieldname-implicit-2/insert-returning-fieldname-implicit-2.3.query.sqlpp
    • -1
    • +1
    ./insert-returning-fieldname-implicit/insert-returning-fieldname-implicit.3.query.sqlpp
    • -34
    • +0
    ./insert-returning-fieldname-qualified/insert-returning-fieldname-qualified.1.ddl.sqlpp
    • -30
    • +0
    ./insert-returning-fieldname-qualified/insert-returning-fieldname-qualified.3.query.sqlpp
    • -0
    • +33
    ./upsert-returning-fieldname-implicit-2/upsert-returning-fieldname-implicit-2.1.ddl.sqlpp
    • -0
    • +29
    ./upsert-returning-fieldname-implicit-2/upsert-returning-fieldname-implicit-2.3.query.sqlpp
    • -0
    • +33
    ./upsert-returning-fieldname-implicit/upsert-returning-fieldname-implicit.1.ddl.sqlpp
    • -0
    • +29
    ./upsert-returning-fieldname-implicit/upsert-returning-fieldname-implicit.3.query.sqlpp
    • -0
    • +33
    ./upsert-returning-fieldname/upsert-returning-fieldname.1.ddl.sqlpp
    • -0
    • +29
    ./upsert-returning-fieldname/upsert-returning-fieldname.3.query.sqlpp
  1. … 46 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>

    • -1
    • +1
    ./query-issue382/query-issue382.3.query.sqlpp
  1. … 279 more files in changeset.
[ASTERIXDB-2391][SQL] Insure that var for return clause gets optimized

Places the variable created for the return clause below the insert

so future optimizations can work on this variable

Added test

Change-Id: Id285435c4dc8a603c60b177dacd9f09722faac21

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

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

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

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

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

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

    • -0
    • +34
    ./insert-returning-fieldname-qualified/insert-returning-fieldname-qualified.1.ddl.sqlpp
    • -0
    • +30
    ./insert-returning-fieldname-qualified/insert-returning-fieldname-qualified.3.query.sqlpp
  1. … 2 more files in changeset.
[ASTERIXDB-2182][ING] Use JSON-like syntax for feed configuration

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

To be consistent with the other JSON-like syntax in defining

configurations, CREATE FEED will change to use JSON object instead of

key-value pairs. Also, the <USING> adapter_name syntax is removed. The

adapter name becomes as part of the configuration. After this change,

the feed configuration are specified as:

<CREATE> <FEED> testFeed <WITH> {

"adapter-name" : "localfs",

"path" : "localhost://../../../../../tweets.json",

"format" : "adm",

"type-name" : "typeTweet"

};

This patch also fixes two minor mistakes when drop feed and adapter in

Metadata.

Change-Id: I2dfb0fdf74d28ae0c45dafcf6babb624bd8b2149

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

Reviewed-by: abdullah alamoudi <bamousaa@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>

Contrib: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

    • -8
    • +7
    ./scan-delete-btree-correlated-secondary-index-nullable/scan-delete-btree-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -7
    • +8
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-nullable/scan-delete-inverted-index-ngram-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -7
    • +8
    ./scan-delete-inverted-index-ngram-correlated-secondary-index/scan-delete-inverted-index-ngram-correlated-secondary-index.1.ddl.sqlpp
    • -6
    • +8
    ./scan-delete-inverted-index-word-correlated-secondary-index-nullable/scan-delete-inverted-index-word-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -8
    • +8
    ./scan-delete-inverted-index-word-correlated-secondary-index/scan-delete-inverted-index-word-correlated-secondary-index.1.ddl.sqlpp
    • -6
    • +7
    ./scan-delete-rtree-correlated-secondary-index-nullable/scan-delete-rtree-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -6
    • +7
    ./scan-delete-rtree-correlated-secondary-index/scan-delete-rtree-correlated-secondary-index.1.ddl.sqlpp
    • -7
    • +7
    ./scan-insert-rtree-correlated-secondary-index-nullable/scan-insert-rtree-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -6
    • +7
    ./scan-insert-rtree-correlated-secondary-index-open/scan-insert-rtree-correlated-secondary-index-open.1.ddl.sqlpp
    • -12
    • +15
    ./scan-insert-rtree-correlated-secondary-index/scan-insert-rtree-correlated-secondary-index.1.ddl.sqlpp
    • -7
    • +8
    ./using-correlated-prefix-merge-policy-with-feed/using-correlated-prefix-merge-policy-with-feed.1.ddl.sqlpp
  1. … 97 more files in changeset.
[ASTERIXDB-2193][SQLPP] Fix dataverse resolution in functions

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- When compiling user-defined function set default dataverse

to be the function's dataverse to correclty resolve dataset

accesses within that function

- Fix incorrect interpretation of quoted dataset names

FROM `a.b` now means FROM default_dataverse.`a.b`

(previously it meant FROM `a`.`b`)

Change-Id: I699b35fb46a739e9fdfcaf5cbfd6a4a00ce4da38

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

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: Till Westmann <tillw@apache.org>

    • -1
    • +1
    ./create-drop-cltype/create-drop-cltype.3.query.sqlpp
    • -1
    • +1
    ./create-drop-opntype/create-drop-opntype.3.query.sqlpp
    • -1
    • +1
    ./drop-empty-secondary-indexes/drop-empty-secondary-indexes.3.query.sqlpp
    • -1
    • +1
    ./insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.2.update.sqlpp
    • -1
    • +1
    ./insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.3.query.sqlpp
    • -1
    • +1
    ./load-with-index-open/load-with-index-open.2.update.sqlpp
    • -1
    • +1
    ./load-with-ngram-index-open/load-with-ngram-index-open.2.update.sqlpp
    • -1
    • +1
    ./load-with-rtree-index-open/load-with-rtree-index-open.2.update.sqlpp
    • -1
    • +1
    ./load-with-word-index-open/load-with-word-index-open.2.update.sqlpp
    • -1
    • +1
    ./recreate-index/recreate-index.2.update.sqlpp
    • -1
    • +1
    ./recreate-index/recreate-index.4.update.sqlpp
    • -1
    • +1
    ./recreate-index/recreate-index.5.query.sqlpp
    • -1
    • +1
    ./scan-delete-btree-correlated-secondary-index-open/scan-delete-btree-correlated-secondary-index-open.2.update.sqlpp
    • -1
    • +1
    ./scan-delete-btree-secondary-index-open/scan-delete-btree-secondary-index-open.2.update.sqlpp
    • -1
    • +1
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-open/scan-delete-inverted-index-ngram-correlated-secondary-index-open.2.update.sqlpp
  1. … 1502 more files in changeset.
[ASTERIXDB-2182][SQL] Change merge policy syntax

- user model changes: yes

- change the way a merge policy is specified

- storage format changes: no

- interface changes: no

details:

- previously, merge policies are specified as follows:

<USING> <COMPACTION> <POLICY>

prefix_merge (("number"="123"),("size"="456"));

- After this change, the policies are specified as:

<WITH> {

"merge-policy": {

"name": "prefix",

"parameters": { "number": 123, "size": 456 }

}

};

- compaction and policy are not key words anymore

Change-Id: I040f4c74cfa0170b8888128ad5f975e196658776

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

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>

    • -2
    • +6
    ./scan-delete-btree-correlated-secondary-index-nullable/scan-delete-btree-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -4
    • +12
    ./scan-delete-btree-correlated-secondary-index-open/scan-delete-btree-correlated-secondary-index-open.1.ddl.sqlpp
    • -2
    • +6
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-nullable/scan-delete-inverted-index-ngram-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -4
    • +12
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-open/scan-delete-inverted-index-ngram-correlated-secondary-index-open.1.ddl.sqlpp
    • -2
    • +6
    ./scan-delete-inverted-index-ngram-correlated-secondary-index/scan-delete-inverted-index-ngram-correlated-secondary-index.1.ddl.sqlpp
    • -2
    • +6
    ./scan-delete-inverted-index-word-correlated-secondary-index-nullable/scan-delete-inverted-index-word-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -4
    • +13
    ./scan-delete-inverted-index-word-correlated-secondary-index-open/scan-delete-inverted-index-word-correlated-secondary-index-open.1.ddl.sqlpp
    • -2
    • +7
    ./scan-delete-inverted-index-word-correlated-secondary-index/scan-delete-inverted-index-word-correlated-secondary-index.1.ddl.sqlpp
    • -2
    • +6
    ./scan-delete-rtree-correlated-secondary-index-nullable/scan-delete-rtree-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -4
    • +12
    ./scan-delete-rtree-correlated-secondary-index-open/scan-delete-rtree-correlated-secondary-index-open.1.ddl.sqlpp
    • -3
    • +6
    ./scan-delete-rtree-correlated-secondary-index/scan-delete-rtree-correlated-secondary-index.1.ddl.sqlpp
    • -4
    • +12
    ./scan-insert-btree-correlated-secondary-index-nullable/scan-insert-btree-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -4
    • +12
    ./scan-insert-btree-correlated-secondary-index-open/scan-insert-btree-correlated-secondary-index-open.1.ddl.sqlpp
    • -5
    • +12
    ./scan-insert-inverted-index-ngram-correlated-secondary-index-nullable/scan-insert-inverted-index-ngram-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -5
    • +12
    ./scan-insert-inverted-index-ngram-correlated-secondary-index-open/scan-insert-inverted-index-ngram-correlated-secondary-index-open.1.ddl.sqlpp
  1. … 66 more files in changeset.
[ASTERIXDB-2159][API] ValidateUtil throws NPE

- user model changes: no

- storage format changes: no

- interface change: no

Details:

Fix a case where ValidateUtil throws an NPE instead of using error codes.

Change-Id: If467e484e01e9085f2eb8a943a4178b44a384a02

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

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
    • +34
    ./load-with-autogenerated-no-field/load-with-autogenerated-pk_txt_01.1.ddl.sqlpp
  1. … 4 more files in changeset.
[ASTERIXDB-2015][IDX] Introduce Secondary Primary Index

- user model changes: yes. CREATE PRIMARY INDEX

- storage format changes: no

- interface changes: no

details:

- enable the creation of secondary primary indexes storing only PKs

- change the grammar to allow the creation of secondary primary index

- introduce a new rule to fix the outputs of the replicate operator

to match its parents in the final plan

- disallow creating an enforced index on a closed-type field

- disallow creating an index with repeating keys

Change-Id: I59725425ba7c5fe438507dc900f83eaab239d296

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

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
    • +1
    ./compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.3.ddl.sqlpp
    • -0
    • +1
    ./delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.3.ddl.sqlpp
    • -0
    • +3
    ./drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ddl.sqlpp
    • -0
    • +1
    ./empty-load-with-index/empty-load-with-index.1.ddl.sqlpp
    • -0
    • +1
    ./insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp
    • -0
    • +1
    ./insert-duplicated-keys/insert-duplicated-keys.1.ddl.sqlpp
    • -0
    • +1
    ./insert-into-empty-dataset-with-index/insert-into-empty-dataset-with-index.1.ddl.sqlpp
    • -0
    • +1
    ./insert-into-loaded-dataset-with-index_01/insert-into-loaded-dataset-with-index_01.3.ddl.sqlpp
    • -0
    • +1
    ./insert-into-loaded-dataset-with-index_02/insert-into-loaded-dataset-with-index_02.3.ddl.sqlpp
    • -0
    • +42
    ./insert-with-autogenerated-pk_adm-with-sec-primary-index/insert-with-autogenerated-pk_adm-with-sec-primary-index.1.ddl.sqlpp
    • -0
    • +29
    ./insert-with-autogenerated-pk_adm-with-sec-primary-index/insert-with-autogenerated-pk_adm-with-sec-primary-index.2.update.sqlpp
    • -0
    • +31
    ./insert-with-autogenerated-pk_adm-with-sec-primary-index/insert-with-autogenerated-pk_adm-with-sec-primary-index.3.query.sqlpp
    • -0
    • +1
    ./load-with-index/load-with-index.1.ddl.sqlpp
    • -0
    • +1
    ./recreate-index/recreate-index.1.ddl.sqlpp
  1. … 75 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>

    • -1
    • +1
    ./compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ddl.sqlpp
    • -2
    • +2
    ./create-drop-cltype/create-drop-cltype.1.ddl.sqlpp
    • -2
    • +2
    ./create-drop-opntype/create-drop-opntype.1.ddl.sqlpp
    • -1
    • +1
    ./delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ddl.sqlpp
    • -1
    • +1
    ./delete-from-loaded-dataset/delete-from-loaded-dataset.1.ddl.sqlpp
    • -8
    • +8
    ./delete-multi-statement/delete-multi-statement.1.ddl.sqlpp
    • -1
    • +1
    ./delete-syntax-change/delete-syntax-change.1.ddl.sqlpp
    • -3
    • +3
    ./drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ddl.sqlpp
    • -1
    • +1
    ./empty-load-with-index/empty-load-with-index.1.ddl.sqlpp
    • -2
    • +2
    ./insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.ddl.sqlpp
    • -1
    • +1
    ./insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp
    • -1
    • +1
    ./insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp
    • -1
    • +1
    ./insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ddl.sqlpp
    • -1
    • +1
    ./insert-duplicated-keys/insert-duplicated-keys.1.ddl.sqlpp
  1. … 2063 more files in changeset.
[ASTERIXDB-1946][STO][IDX]Create RTree/InvertedIdx for Correlated Datasets

- user model changes: allow creating secondary rtree and inverted index

for datasets using correlated merge policy

- storage format changes: no

- interface changes: no

details:

- Implmeneted create secondary RTree and Inverted Index for datasets

using correlated merge policy.

- Add tests for RTree and Inverted Index creation job

Change-Id: I100fc0b86b8a6fa36a95d77806107bad0307544e

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

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>

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

    • -0
    • +52
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-nullable/scan-delete-inverted-index-ngram-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -0
    • +30
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-nullable/scan-delete-inverted-index-ngram-correlated-secondary-index-nullable.2.update.sqlpp
    • -0
    • +24
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-nullable/scan-delete-inverted-index-ngram-correlated-secondary-index-nullable.3.ddl.sqlpp
    • -0
    • +27
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-nullable/scan-delete-inverted-index-ngram-correlated-secondary-index-nullable.4.query.sqlpp
    • -0
    • +56
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-open/scan-delete-inverted-index-ngram-correlated-secondary-index-open.1.ddl.sqlpp
    • -0
    • +31
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-open/scan-delete-inverted-index-ngram-correlated-secondary-index-open.2.update.sqlpp
    • -0
    • +23
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-open/scan-delete-inverted-index-ngram-correlated-secondary-index-open.3.ddl.sqlpp
    • -0
    • +26
    ./scan-delete-inverted-index-ngram-correlated-secondary-index-open/scan-delete-inverted-index-ngram-correlated-secondary-index-open.5.query.sqlpp
    • -0
    • +51
    ./scan-delete-inverted-index-ngram-correlated-secondary-index/scan-delete-inverted-index-ngram-correlated-secondary-index.1.ddl.sqlpp
    • -0
    • +31
    ./scan-delete-inverted-index-ngram-correlated-secondary-index/scan-delete-inverted-index-ngram-correlated-secondary-index.2.update.sqlpp
    • -0
    • +23
    ./scan-delete-inverted-index-ngram-correlated-secondary-index/scan-delete-inverted-index-ngram-correlated-secondary-index.3.ddl.sqlpp
    • -0
    • +27
    ./scan-delete-inverted-index-ngram-correlated-secondary-index/scan-delete-inverted-index-ngram-correlated-secondary-index.4.query.sqlpp
    • -0
    • +51
    ./scan-delete-inverted-index-word-correlated-secondary-index-nullable/scan-delete-inverted-index-word-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -0
    • +30
    ./scan-delete-inverted-index-word-correlated-secondary-index-nullable/scan-delete-inverted-index-word-correlated-secondary-index-nullable.2.update.sqlpp
    • -0
    • +24
    ./scan-delete-inverted-index-word-correlated-secondary-index-nullable/scan-delete-inverted-index-word-correlated-secondary-index-nullable.3.ddl.sqlpp
  1. … 154 more files in changeset.
[TEST] Test index re-creation

Change-Id: I96eda91a26362ca5b8f2e84b7ddc1c8272b59364

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

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

Reviewed-by: Xikui Wang <xkkwww@gmail.com>

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

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

BAD: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

    • -0
    • +46
    ./recreate-index/recreate-index.1.ddl.sqlpp
    • -0
    • +36
    ./recreate-index/recreate-index.2.update.sqlpp
    • -0
    • +31
    ./recreate-index/recreate-index.3.ddl.sqlpp
    • -0
    • +33
    ./recreate-index/recreate-index.4.update.sqlpp
    • -0
    • +31
    ./recreate-index/recreate-index.5.query.sqlpp
  1. … 2 more files in changeset.
[ASTERIXDB-1946][STO][IDX] Create BTreeIndex for Correlated Datasets

Implemented create seconary BTree index for datasets using

correlated merge policy. Instead of creating one component

for the new index, this change creates one component for each

component of the primary index to maintain the correlation.

The current implementation assumes when a secondary index is being

created, the dataset is locked with no modifications.

Change-Id: I2a3435e6720f07bd6a5092d4d9ce42e8d4b7894c

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

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

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

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

BAD: Jenkins <jenkins@fulliautomatix.ics.uci.edu>

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

    • -0
    • +65
    ./scan-delete-btree-correlated-secondary-index-nullable/scan-delete-btree-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -0
    • +36
    ./scan-delete-btree-correlated-secondary-index-nullable/scan-delete-btree-correlated-secondary-index-nullable.2.update.sqlpp
    • -0
    • +24
    ./scan-delete-btree-correlated-secondary-index-nullable/scan-delete-btree-correlated-secondary-index-nullable.3.ddl.sqlpp
    • -0
    • +33
    ./scan-delete-btree-correlated-secondary-index-nullable/scan-delete-btree-correlated-secondary-index-nullable.4.query.sqlpp
    • -0
    • +73
    ./scan-delete-btree-correlated-secondary-index-open/scan-delete-btree-correlated-secondary-index-open.1.ddl.sqlpp
    • -0
    • +31
    ./scan-delete-btree-correlated-secondary-index-open/scan-delete-btree-correlated-secondary-index-open.2.update.sqlpp
    • -0
    • +24
    ./scan-delete-btree-correlated-secondary-index-open/scan-delete-btree-correlated-secondary-index-open.3.ddl.sqlpp
    • -0
    • +27
    ./scan-delete-btree-correlated-secondary-index-open/scan-delete-btree-correlated-secondary-index-open.4.query.sqlpp
    • -0
    • +62
    ./scan-insert-btree-correlated-secondary-index-nullable/scan-insert-btree-correlated-secondary-index-nullable.1.ddl.sqlpp
    • -0
    • +37
    ./scan-insert-btree-correlated-secondary-index-nullable/scan-insert-btree-correlated-secondary-index-nullable.2.update.sqlpp
    • -0
    • +22
    ./scan-insert-btree-correlated-secondary-index-nullable/scan-insert-btree-correlated-secondary-index-nullable.3.ddl.sqlpp
    • -0
    • +34
    ./scan-insert-btree-correlated-secondary-index-nullable/scan-insert-btree-correlated-secondary-index-nullable.4.query.sqlpp
    • -0
    • +72
    ./scan-insert-btree-correlated-secondary-index-open/scan-insert-btree-correlated-secondary-index-open.1.ddl.sqlpp
    • -0
    • +35
    ./scan-insert-btree-correlated-secondary-index-open/scan-insert-btree-correlated-secondary-index-open.2.update.sqlpp
    • -0
    • +24
    ./scan-insert-btree-correlated-secondary-index-open/scan-insert-btree-correlated-secondary-index-open.3.ddl.sqlpp
  1. … 106 more files in changeset.
ASTERIXDB-1755: add UPSERT in SQL++.

Detailed list of changes included:

- Fix AQL RETURNING clause to use an expression instead of a query;

- Add a rule to check whether a RETURNING expression contains dataset accesses;

- Perform AST-level rewrites for INSERT/UPSERT as a whole, including the

body query and the returning expression.

Change-Id: I02b2be7ff2653573eccb48037895f5c8c4bc8c74

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

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

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

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

    • -0
    • +36
    ./insert-return-records/insert-return-records.1.ddl.sqlpp
    • -0
    • +36
    ./insert-return-records/insert-return-records.3.query.sqlpp
    • -0
    • +37
    ./insert-returning-fieldname-implicit/insert-returning-fieldname-implicit.1.ddl.sqlpp
    • -0
    • +30
    ./insert-returning-fieldname-implicit/insert-returning-fieldname-implicit.3.query.sqlpp
    • -0
    • +37
    ./insert-returning-fieldname/insert-returning-fieldname.1.ddl.sqlpp
    • -0
    • +30
    ./insert-returning-fieldname/insert-returning-fieldname.3.query.sqlpp
    • -0
    • +41
    ./insert-returning-udf/insert-returning-udf.1.ddl.sqlpp
    • -0
    • +30
    ./insert-returning-udf/insert-returning-udf.3.query.sqlpp
    • -0
    • +36
    ./insert-with-bad-return/insert-with-bad-return.1.ddl.sqlpp
    • -0
    • +41
    ./insert-with-bad-return/insert-with-bad-return.3.query.sqlpp
    • -0
    • +36
    ./upsert-dataset-with-meta/upsert-dataset-with-meta.1.ddl.sqlpp
    • -0
    • +29
    ./upsert-dataset-with-meta/upsert-dataset-with-meta.2.update.sqlpp
    • -0
    • +37
    ./upsert-return-custom-result/upsert-return-custom-result.1.ddl.sqlpp
    • -0
    • +46
    ./upsert-return-custom-result/upsert-return-custom-result.3.query.sqlpp
  1. … 90 more files in changeset.
Documentation cleanup.

1. "record"->"object",

2. JSONify sqlpp/3_query.md.

Change-Id: Idcb2be81d1bfa37dd876cd36a7a5bb824bc3ab86

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

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

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
    ./opentype-insert2/opentype-insert2.1.ddl.sqlpp
    • -1
    • +1
    ./opentype-insert2/opentype-insert2.2.update.sqlpp
    • -1
    • +1
    ./opentype-insert2/opentype-insert2.3.query.sqlpp
  1. … 810 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
    ./query-issue382/query-issue382.3.query.sqlpp
  1. … 384 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>

    • -5
    • +5
    ./compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ddl.sqlpp
    • -2
    • +2
    ./create-drop-cltype/create-drop-cltype.1.ddl.sqlpp
    • -2
    • +2
    ./create-drop-opntype/create-drop-opntype.1.ddl.sqlpp
    • -5
    • +5
    ./delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ddl.sqlpp
    • -5
    • +5
    ./delete-from-loaded-dataset/delete-from-loaded-dataset.1.ddl.sqlpp
    • -20
    • +20
    ./delete-multi-statement/delete-multi-statement.1.ddl.sqlpp
    • -5
    • +5
    ./delete-syntax-change/delete-syntax-change.1.ddl.sqlpp
    • -1
    • +1
    ./drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ddl.sqlpp
    • -13
    • +13
    ./drop-index/drop-index.1.ddl.sqlpp
    • -4
    • +4
    ./empty-load-with-index/empty-load-with-index.1.ddl.sqlpp
    • -4
    • +4
    ./insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.ddl.sqlpp
    • -2
    • +2
    ./insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.1.ddl.sqlpp
    • -1
    • +1
    ./insert-and-scan-dataset/insert-and-scan-dataset.1.ddl.sqlpp
    • -1
    • +1
    ./insert-and-scan-joined-datasets/insert-and-scan-joined-datasets.1.ddl.sqlpp
  1. … 3547 more files in changeset.
Add Flag To ExecutionTest To Enable Test Repeats

- Also, fix tests to be able to be repeated

Change-Id: Ib263ff475bb7640bb3b4309e6804e4ab2e2702fb

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

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
    • +1
    ./query-issue382/query-issue382.1.ddl.sqlpp
    • -0
    • +1
    ./query-issue433/query-issue433.1.ddl.sqlpp
  1. … 5 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>

    • -3
    • +3
    ./drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ddl.sqlpp
    • -1
    • +1
    ./insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.1.ddl.sqlpp
    • -1
    • +1
    ./load-with-index-open/load-with-index-open.1.ddl.sqlpp
    • -1
    • +1
    ./load-with-ngram-index-open/load-with-ngram-index-open.1.ddl.sqlpp
    • -1
    • +1
    ./load-with-rtree-index-open/load-with-rtree-index-open.1.ddl.sqlpp
    • -1
    • +1
    ./load-with-word-index-open/load-with-word-index-open.1.ddl.sqlpp
    • -1
    • +1
    ./scan-delete-btree-secondary-index-open/scan-delete-btree-secondary-index-open.3.ddl.sqlpp
    • -1
    • +1
    ./scan-delete-inverted-index-ngram-secondary-index-open/scan-delete-inverted-index-ngram-secondary-index-open.3.ddl.sqlpp
    • -1
    • +1
    ./scan-delete-inverted-index-word-secondary-index-open/scan-delete-inverted-index-word-secondary-index-open.3.ddl.sqlpp
    • -1
    • +1
    ./scan-delete-rtree-secondary-index-open/scan-delete-rtree-secondary-index-open.3.ddl.sqlpp
    • -1
    • +1
    ./scan-insert-btree-secondary-index-open/scan-insert-btree-secondary-index-open.3.ddl.sqlpp
    • -1
    • +1
    ./scan-insert-inverted-index-ngram-secondary-index-open/scan-insert-inverted-index-ngram-secondary-index-open.3.ddl.sqlpp
    • -1
    • +1
    ./scan-insert-inverted-index-word-secondary-index-open/scan-insert-inverted-index-word-secondary-index-open.3.ddl.sqlpp
    • -1
    • +1
    ./scan-insert-rtree-secondary-index-open/scan-insert-rtree-secondary-index-open.3.ddl.sqlpp
  1. … 774 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
    ./compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.1.ddl.sqlpp
    • -1
    • +1
    ./compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.2.update.sqlpp
    • -2
    • +2
    ./create-drop-cltype/create-drop-cltype.1.ddl.sqlpp
    • -2
    • +2
    ./create-drop-opntype/create-drop-opntype.1.ddl.sqlpp
    • -3
    • +3
    ./delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.1.ddl.sqlpp
    • -1
    • +1
    ./delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.2.update.sqlpp
    • -3
    • +3
    ./delete-from-loaded-dataset/delete-from-loaded-dataset.1.ddl.sqlpp
    • -1
    • +1
    ./delete-from-loaded-dataset/delete-from-loaded-dataset.2.update.sqlpp
    • -10
    • +10
    ./delete-multi-statement/delete-multi-statement.1.ddl.sqlpp
    • -8
    • +8
    ./delete-multi-statement/delete-multi-statement.2.update.sqlpp
    • -3
    • +3
    ./delete-syntax-change/delete-syntax-change.1.ddl.sqlpp
    • -1
    • +1
    ./delete-syntax-change/delete-syntax-change.2.update.sqlpp
    • -3
    • +3
    ./drop-empty-secondary-indexes/drop-empty-secondary-indexes.1.ddl.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
    ./compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.4.update.sqlpp
    • -2
    • +2
    ./delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.4.update.sqlpp
    • -2
    • +2
    ./delete-from-loaded-dataset/delete-from-loaded-dataset.2.update.sqlpp
    • -14
    • +13
    ./delete-multi-statement/delete-multi-statement.2.update.sqlpp
    • -2
    • +2
    ./delete-syntax-change/delete-syntax-change.2.update.sqlpp
    • -2
    • +2
    ./query-issue205/query-issue205.2.update.sqlpp
    • -2
    • +2
    ./scan-delete-btree-secondary-index-nullable/scan-delete-btree-secondary-index-nullable.4.update.sqlpp
    • -2
    • +2
    ./scan-delete-btree-secondary-index-open/scan-delete-btree-secondary-index-open.4.update.sqlpp
    • -2
    • +2
    ./scan-delete-inverted-index-ngram-secondary-index-nullable/scan-delete-inverted-index-ngram-secondary-index-nullable.4.update.sqlpp
    • -2
    • +2
    ./scan-delete-inverted-index-ngram-secondary-index-open/scan-delete-inverted-index-ngram-secondary-index-open.4.update.sqlpp
    • -2
    • +2
    ./scan-delete-inverted-index-ngram-secondary-index/scan-delete-inverted-index-ngram-secondary-index.4.update.sqlpp
    • -2
    • +2
    ./scan-delete-inverted-index-word-secondary-index-nullable/scan-delete-inverted-index-word-secondary-index-nullable.4.update.sqlpp
    • -2
    • +2
    ./scan-delete-inverted-index-word-secondary-index-open/scan-delete-inverted-index-word-secondary-index-open.4.update.sqlpp
    • -2
    • +2
    ./scan-delete-inverted-index-word-secondary-index/scan-delete-inverted-index-word-secondary-index.4.update.sqlpp
  1. … 36 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
    ./compact-dataset-and-its-indexes/compact-dataset-and-its-indexes.2.update.sqlpp
    • -1
    • +1
    ./create-drop-cltype/create-drop-cltype.3.query.sqlpp
    • -1
    • +1
    ./create-drop-opntype/create-drop-opntype.3.query.sqlpp
    • -1
    • +1
    ./delete-from-loaded-dataset-with-index/delete-from-loaded-dataset-with-index.2.update.sqlpp
    • -1
    • +1
    ./delete-from-loaded-dataset/delete-from-loaded-dataset.2.update.sqlpp
    • -8
    • +8
    ./delete-multi-statement/delete-multi-statement.2.update.sqlpp
    • -1
    • +1
    ./delete-syntax-change/delete-syntax-change.2.update.sqlpp
    • -1
    • +1
    ./drop-empty-secondary-indexes/drop-empty-secondary-indexes.3.query.sqlpp
    • -1
    • +1
    ./drop-index/drop-index.2.update.sqlpp
    • -2
    • +2
    ./empty-load-with-index/empty-load-with-index.2.update.sqlpp
    • -2
    • +2
    ./insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.2.update.sqlpp
    • -1
    • +1
    ./insert-and-scan-dataset-with-index-on-open-field/insert-and-scan-dataset-with-index-on-open-field.3.query.sqlpp
    • -2
    • +2
    ./insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.2.update.sqlpp
    • -1
    • +1
    ./insert-and-scan-dataset-with-index/insert-and-scan-dataset-with-index.3.query.sqlpp
  1. … 2118 more files in changeset.
Merge branch 'master' into hyracks-merge2

    • -1
    • +1
    ./query-issue382/query-issue382.3.query.sqlpp
  1. … 484 more files in changeset.