Clone Tools
  • last updated a few minutes ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fix issue849.

Change-Id: I4d2933c94c4139a6c8e2cf15e3cd1f6a52335f6b

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/217

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

Reviewed-by: Young-Seok Kim <kisskys@gmail.com>

Reviewed-by: Steven Jacobs <sjaco002@ucr.edu>

    • -0
    • +24
    ./query_issue849-2.aql
    • -0
    • +24
    ./query_issue849.aql
  1. … 15 more files in changeset.
Fix for issues 838, 841, 527

These fixes help to recognize and rewrite plans that should use index lookups rather than nested loops or outer joins

Change-Id: Icad72c10e7c6afbc46cfb014c6198429d4e338e2

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/215

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

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

    • -0
    • +45
    ./rtree-index-join/query-issue838.aql
  1. … 9 more files in changeset.
Fix issue 562.

Change-Id: If5829d66910294ef5c764c6cba8743effda68b28

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/203

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

Reviewed-by: Pouria Pirzadeh <pouria.pirzadeh@gmail.com>

    • -0
    • +99
    ./query-issue562.aql
  1. … 9 more files in changeset.
Fix issue827

Change-Id: If21e2a4efc69e46ee452353fc06507b3f890db0d

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/189

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

Reviewed-by: Preston Carman <ecarm002@ucr.edu>

    • -0
    • +52
    ./query-issue827-2.aql
  1. … 13 more files in changeset.
1. Fix for issue 810. 2. Add regression tests for issue 567 and 697.

Change-Id: I1eb4d7ca5d757f317efbe373ba502c6db61d93f4

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/179

Reviewed-by: Preston Carman <ecarm002@ucr.edu>

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

    • -0
    • +27
    ./query-issue697.aql
    • -0
    • +54
    ./query-issue810-2.aql
    • -0
    • +49
    ./query-issue810.aql
  1. … 28 more files in changeset.
Fix for issue 813 - enabling prefix btree search with non-matching predicates

Change-Id: I59eb43afa7dbcabd7f43269566d75c9361c55386

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/171

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

Reviewed-by: abdullah alamoudi <bamousaa@gmail.com>

    • -0
    • +24
    ./btree-index-join/primary-composite-key-join_01.aql
    • -0
    • +24
    ./btree-index-join/primary-composite-key-join_02.aql
    • -0
    • +24
    ./btree-index-join/primary-composite-key-join_03.aql
    • -0
    • +24
    ./btree-index-join/primary-composite-key-prefix-join_01.aql
    • -0
    • +24
    ./btree-index-join/primary-composite-key-prefix-join_02.aql
    • -0
    • +24
    ./btree-index-join/primary-composite-key-prefix-join_03.aql
    • -0
    • +24
    ./btree-index-join/primary-composite-key-prefix-join_04.aql
    • -0
    • +24
    ./btree-index-join/primary-composite-key-prefix-join_05.aql
    • -0
    • +24
    ./btree-index-join/primary-composite-key-prefix-join_06.aql
    • -0
    • +26
    ./btree-index/btree-primary-31.aql
  1. … 77 more files in changeset.
Fix issue785 -- using the algebricks fixes for subplans. Fix RemoveRedundantListifyRule -- listify/scan-collection pair within a nested plan can be removed. Fix issue550. Add a regression test for issue638.

Change-Id: Id56539cd5ab7ed0cc05897b468c26aec169102fd

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/150

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

Reviewed-by: Preston Carman <ecarm002@ucr.edu>

Reviewed-by: Till Westmann <westmann@gmail.com>

    • -0
    • +22
    ./query-issue550.aql
    • -0
    • +105
    ./query-issue785.aql
  1. … 20 more files in changeset.
This change enable prefix search on Btrees

The following commits from your working branch will be included:

commit 0a1299c3d72b56a0045385cb9476ab99b1fbd7f6

Author: Abdullah Alamoudi <bamousaa@Abdullahs-MacBook-Pro.local>

Date: Thu Oct 23 13:49:34 2014 +0300

Enabled prefix search

Change-Id: Iebefb7c40d6eb7b55d023caaa148cc8512bd6e9e

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/126

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

Reviewed-by: Taewoo Kim <wangsaeu@gmail.com>

  1. … 13 more files in changeset.
Fix issue 786, issue 601, the prefix search issue reported by Abdullah, and the workaround query for issue 785.

Change-Id: I8bc4f18cd34c3d581f99f1509a4531c093aeec31

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/145

Reviewed-by: abdullah alamoudi <bamousaa@gmail.com>

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

    • -0
    • +40
    ./query-issue601.aql
  1. … 22 more files in changeset.
New test cases for the new replicate operator

- added new execution and optimizer tests for replicate operator

- fixed optimizer test plans after reducing live variables for unnestmap operator

Change-Id: If1341cc712542b0023cebb17bd0d16ee345b359d

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/88

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

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

    • -0
    • +85
    ./split-materialization-above-join.aql
    • -0
    • +31
    ./split-materialization.aql
  1. … 68 more files in changeset.
1. Add an asterix-specific IntroduceGroupByCombinerRule to deal with null-test in the nested plan in a group-by operator 2. Add a regression test case for issue782, including optimizer test and runtime test

Change-Id: Ia678414451ebddb7367238fef9f22a6753aa6206

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/65

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

Reviewed-by: Till Westmann <westmann@gmail.com>

    • -0
    • +116
    ./nest_aggregate.aql
  1. … 13 more files in changeset.
fixed issue 731, 740, and more.

commit 0b46141bea8d503896dc06308f102131df2e4f3d

Author: Young-Seok <kisskys@gmail.com>

Date: Tue May 20 12:52:54 2014 -0700

fixed issues of access method rules that try to use incompatible indexes and similarity functions

commit a0ea4e411503de265f1883aa3837a45be4a8747a

Merge: bb8fe91 b5785a9

Author: Young-Seok <kisskys@gmail.com>

Date: Sun May 18 13:00:33 2014 -0700

merged from master branch to kisskys/left-outer-join-issue branch

commit bb8fe91ffd4fec3d495d32442020447693be8548

Author: Young-Seok <kisskys@gmail.com>

Date: Sun May 18 11:33:54 2014 -0700

another fix for picking available index for leftouterjoin plan

commit 60b057ecec6a157e3e11cb316ef7d38601483741

Merge: a743e44 6cb7fd9

Author: Young-Seok <kisskys@gmail.com>

Date: Sun May 11 22:22:42 2014 -0700

merged master to kisskys/left-outer-join-issue branch

commit a743e4493f0f84f7a71e671478592d487e7510e3

Author: Young-Seok <kisskys@gmail.com>

Date: Sun May 11 20:51:50 2014 -0700

changes for left-outer-join to pick available indexes

Change-Id: I0d89d20c6cc076f40d1fbc5687f0b70e49a91eed

Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/33

Reviewed-by: Inci Cetindil <icetindil@gmail.com>

Tested-by: Ian Maxon <imaxon@uci.edu>

    • -0
    • +53
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_01.aql
    • -0
    • +55
    ./btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_02.aql
    • -0
    • +47
    ./inverted-index-join/issue741.aql
    • -0
    • +55
    ./inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.aql
    • -0
    • +55
    ./inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.aql
    • -0
    • +47
    ./inverted-index-join/ngram-contains.aql
    • -1
    • +1
    ./inverted-index-join/word-jaccard-check-after-btree-access.aql
    • -0
    • +44
    ./rtree-index-join/issue730.aql
    • -0
    • +53
    ./rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.aql
    • -0
    • +53
    ./rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.aql
  1. … 64 more files in changeset.
fix for issue 765: stacking multiple index access methods

    • -0
    • +51
    ./inverted-index-join/word-jaccard-check-after-btree-access.aql
  1. … 10 more files in changeset.
optimization for disjunctive selection predicates - add rule to rewrite a disjunction of eq-comparisons on the same variable in a selection to a join

    • -0
    • +14
    ./disjunction-to-join-delete-1.aql
    • -0
    • +14
    ./disjunction-to-join-delete-2.aql
    • -0
    • +14
    ./disjunction-to-join-delete-3.aql
  1. … 14 more files in changeset.
edit-distance-contains function implementation

    • -0
    • +38
    ./inverted-index-join/ngram-edit-distance-contains.aql
  1. … 13 more files in changeset.
addressed code review comments, retracted the rule that converts existential query to distinct by

    • -1
    • +3
    ./inverted-index-complex/ngram-edit-distance-check-word-tokens.aql
  1. … 5 more files in changeset.
fix for issue 731, needs optimization on existential queries

    • -0
    • +31
    ./inverted-index-complex/ngram-edit-distance-check-substring.aql
    • -0
    • +31
    ./inverted-index-complex/ngram-edit-distance-check-word-tokens.aql
  1. … 21 more files in changeset.
fixing issue #352

    • -0
    • +26
    ./hashjoin-with-unnest.aql
  1. … 2 more files in changeset.
Added another test case to cover the composite keys.

    • -0
    • +25
    ./skip-index/skip-secondary-btree-index-2.aql
  1. … 1 more file in changeset.
Moved the skip secondary index search hint closer to the predicates.

    • -1
    • +1
    ./skip-index/dont-skip-primary-index-search-in-delete.aql
    • -2
    • +1
    ./skip-index/dont-skip-primary-index.aql
    • -1
    • +1
    ./skip-index/skip-ngram-index-search-in-delete.aql
    • -1
    • +1
    ./skip-index/skip-rtree-index-search-in-delete.aql
    • -2
    • +1
    ./skip-index/skip-rtree-secondary-index.aql
    • -1
    • +1
    ./skip-index/skip-secondary-btree-index-search-in-delete.aql
    • -2
    • +1
    ./skip-index/skip-secondary-btree-index.aql
    • -1
    • +1
    ./skip-index/skip-word-index-search-in-delete.aql
  1. … 13 more files in changeset.
Added a hint to AQL to exclude secondary indexes from the query plan.

    • -0
    • +31
    ./skip-index/dont-skip-primary-index-search-in-delete.aql
    • -0
    • +24
    ./skip-index/dont-skip-primary-index.aql
    • -0
    • +24
    ./skip-index/skip-ngram-index-search-in-delete.aql
    • -0
    • +29
    ./skip-index/skip-ngram-index.aql
    • -0
    • +29
    ./skip-index/skip-rtree-index-search-in-delete.aql
    • -0
    • +40
    ./skip-index/skip-rtree-secondary-index.aql
    • -0
    • +32
    ./skip-index/skip-secondary-btree-index-search-in-delete.aql
    • -0
    • +26
    ./skip-index/skip-secondary-btree-index.aql
    • -0
    • +25
    ./skip-index/skip-word-index-search-in-delete.aql
    • -0
    • +29
    ./skip-index/skip-word-index.aql
  1. … 20 more files in changeset.
Changed create-polygon to accept a list of doubles.

  1. … 14 more files in changeset.
fix issue 558

    • -0
    • +149
    ./q08_group_by.aql
    • -0
    • +153
    ./q09_group_by.aql
  1. … 3 more files in changeset.
corresponding changes for fixing operator execution mode

  1. … 5 more files in changeset.
added materialization step before an insert and a scan/join of the same dataset.

    • -0
    • +33
    ./insert-and-scan-dataset-with-index.aql
    • -0
    • +26
    ./insert-and-scan-dataset.aql
    • -0
    • +32
    ./insert-and-scan-joined-datasets.aql
  1. … 20 more files in changeset.
rename single-digit TPC-H queries from qn_* to q0n_*

    • -0
    • +50
    ./q01_pricing_summary_report_nt.aql
    • -0
    • +83
    ./q03_shipping_priority.aql
    • -0
    • +122
    ./q05_local_supplier_volume.aql
  1. … 103 more files in changeset.
Change order of elements in unordered list to make sure it works correctly

    • -1
    • +1
    ./inverted-index-basic/ulist-fuzzyeq-jaccard.aql
    • -1
    • +1
    ./inverted-index-basic/ulist-jaccard-check.aql
    • -1
    • +1
    ./inverted-index-basic/ulist-jaccard.aql
  1. … 1 more file in changeset.
modifying some optimizer test cases to have unordered list as second parameter of jaccard-similarity function

    • -1
    • +1
    ./inverted-index-basic/ulist-fuzzyeq-jaccard.aql
    • -1
    • +1
    ./inverted-index-basic/ulist-jaccard-check.aql
    • -1
    • +1
    ./inverted-index-basic/ulist-jaccard.aql
  1. … 1 more file in changeset.
revised the list of private functions as per the recent changes to the google doc

    • -0
    • +1
    ./inverted-index-basic/ngram-fuzzyeq-jaccard.aql
    • -1
    • +2
    ./inverted-index-basic/ngram-jaccard-check.aql
    • -0
    • +1
    ./inverted-index-basic/ngram-jaccard.aql
    • -1
    • +2
    ./inverted-index-complex/ngram-jaccard-check-let.aql
    • -1
    • +2
    ./inverted-index-complex/ngram-jaccard-check-multi-let.aql
    • -1
    • +2
    ./inverted-index-join-noeqjoin/ngram-fuzzyeq-jaccard.aql
    • -1
    • +2
    ./inverted-index-join-noeqjoin/ngram-jaccard-inline.aql
    • -1
    • +2
    ./inverted-index-join-noeqjoin/ngram-jaccard.aql
    • -1
    • +2
    ./inverted-index-join/ngram-fuzzyeq-jaccard_01.aql
    • -1
    • +2
    ./inverted-index-join/ngram-fuzzyeq-jaccard_02.aql
    • -1
    • +2
    ./inverted-index-join/ngram-fuzzyeq-jaccard_03.aql
    • -1
    • +2
    ./inverted-index-join/ngram-jaccard-check_01.aql
    • -1
    • +2
    ./inverted-index-join/ngram-jaccard-check_02.aql
    • -1
    • +2
    ./inverted-index-join/ngram-jaccard-check_03.aql
    • -1
    • +2
    ./inverted-index-join/ngram-jaccard-check_04.aql
  1. … 16 more files in changeset.
fix for issue 350

  1. … 6 more files in changeset.