Clone Tools
  • last updated 20 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[ASTERIXDB-2438][COMP] Allow assigns when pushing limit into data scan

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Handle assign operators between select and data scan

when pushing limit into data scan

Change-Id: I3b68890d034dded3db7572462f47161721aa18fa

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

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: Taewoo Kim <wangsaeu@gmail.com>

    • -0
    • +28
    ./push-limit-to-primary-lookup-select/push-limit-to-primary-lookup-select.5.query.sqlpp
    • -0
    • +27
    ./push-limit-to-primary-lookup-select/push-limit-to-primary-lookup-select.6.query.sqlpp
    • -2
    • +7
    ./push-limit-to-primary-scan-select/push-limit-to-primary-scan-select.1.ddl.sqlpp
    • -0
    • +2
    ./push-limit-to-primary-scan-select/push-limit-to-primary-scan-select.2.update.sqlpp
    • -0
    • +26
    ./push-limit-to-primary-scan-select/push-limit-to-primary-scan-select.6.query.sqlpp
    • -0
    • +25
    ./push-limit-to-primary-scan-select/push-limit-to-primary-scan-select.7.query.sqlpp
    • -0
    • +26
    ./push-limit-to-primary-scan-select/push-limit-to-primary-scan-select.8.query.sqlpp
    • -0
    • +25
    ./push-limit-to-primary-scan-select/push-limit-to-primary-scan-select.9.query.sqlpp
  1. … 10 more files in changeset.
[ASTERIXDB-2428][COMP] Incorrect result with limit if offset is negative

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- Guarantee non negative limit and offset value during plan generation,

so it is correct to add them in CopyLimitDownRule

Change-Id: I2238cc5d8f48e14aa2b74d120248a4848dd35691

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

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: Taewoo Kim <wangsaeu@gmail.com>

    • -0
    • +39
    ./limit_negative_value/limit_negative_value.1.ddl.sqlpp
    • -0
    • +21
    ./limit_negative_value/limit_negative_value.2.update.sqlpp
    • -0
    • +67
    ./limit_negative_value/limit_negative_value.3.query.sqlpp
    • -0
    • +25
    ./limit_negative_value/limit_negative_value.4.query.sqlpp
  1. … 4 more files in changeset.
[ASTERIXDB-2424][COMP] No limit pushdown if multiple limit clauses

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- CopyLimitDownRule should not stop at the first limit clause it processes

Change-Id: Id92bb99c57d1363740b0ccbb09bceb59da968ca0

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

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: Taewoo Kim <wangsaeu@gmail.com>

    • -0
    • +36
    ./push-limit-to-primary-scan-select/push-limit-to-primary-scan-select.5.query.sqlpp
  1. … 2 more files in changeset.
[ASTERIXDB-2420][COMP] Internal error with limit clause

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

- CopyLimitDownRule must not copy limit below clauses

that produce that limit’s variables

Change-Id: I6c77b7e24d6d0a95f3c772301d592c5b5c478119

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

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: Taewoo Kim <wangsaeu@gmail.com>

    • -0
    • +40
    ./query-ASTERIXDB-2420/query-ASTERIXDB-2420.1.ddl.sqlpp
    • -0
    • +22
    ./query-ASTERIXDB-2420/query-ASTERIXDB-2420.2.update.sqlpp
    • -0
    • +25
    ./query-ASTERIXDB-2420/query-ASTERIXDB-2420.3.query.sqlpp
  1. … 3 more files in changeset.
[ASTERIXDB-2417][COMP] Fix issues with LIMIT clause

- user model changes: yes

- storage format changes: no

- interface changes: no

Details:

- Fixed NPE in optimizer when limit/offset is non-integer

- Allow float/double values that are integers in limit/offset

- Make consistent limit/offset value types (integer) between

runtime and optimizer rules

- Add internal function treat-as-integer() that returns integer

if input number conforms to the integer type or fails otherwise

Change-Id: I986fab3e79b072aa2441af293f3e16c3f37bf508

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

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>

    • -0
    • +29
    ./limit_type_01/limit_type_01.1.query.sqlpp
    • -0
    • +28
    ./limit_type_02/limit_type_02.1.query.sqlpp
    • -0
    • +28
    ./limit_type_02/limit_type_02.2.query.sqlpp
    • -0
    • +28
    ./limit_type_02/limit_type_02.3.query.sqlpp
    • -0
    • +28
    ./limit_type_02/limit_type_02.4.query.sqlpp
    • -0
    • +28
    ./limit_type_02/limit_type_02.5.query.sqlpp
    • -0
    • +28
    ./limit_type_02/limit_type_02.6.query.sqlpp
    • -0
    • +25
    ./push-limit-to-primary-lookup/push-limit-to-primary-lookup.5.query.sqlpp
    • -0
    • +26
    ./push-limit-to-primary-scan/push-limit-to-primary-scan.5.query.sqlpp
  1. … 14 more files in changeset.
[ASTERIXDB-2344] LIMIT pushdown for primary index

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

-Implement LIMIT pushdown for primary index scan/lookup. In case of

a select operator, we also push the select condition to the priamry

search operator to ensure correctness.

Change-Id: I824fcad79995325e12a1a81d629160025294b915

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

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
    • +54
    ./push-limit-to-primary-lookup-select/push-limit-to-primary-lookup-select.1.ddl.sqlpp
    • -0
    • +24
    ./push-limit-to-primary-lookup-select/push-limit-to-primary-lookup-select.2.update.sqlpp
    • -0
    • +25
    ./push-limit-to-primary-lookup-select/push-limit-to-primary-lookup-select.3.query.sqlpp
    • -0
    • +26
    ./push-limit-to-primary-lookup-select/push-limit-to-primary-lookup-select.4.query.sqlpp
    • -0
    • +54
    ./push-limit-to-primary-lookup/push-limit-to-primary-lookup.1.ddl.sqlpp
    • -0
    • +24
    ./push-limit-to-primary-lookup/push-limit-to-primary-lookup.2.update.sqlpp
    • -0
    • +25
    ./push-limit-to-primary-lookup/push-limit-to-primary-lookup.3.query.sqlpp
    • -0
    • +26
    ./push-limit-to-primary-lookup/push-limit-to-primary-lookup.4.query.sqlpp
    • -0
    • +42
    ./push-limit-to-primary-scan-select/push-limit-to-primary-scan-select.1.ddl.sqlpp
    • -0
    • +24
    ./push-limit-to-primary-scan-select/push-limit-to-primary-scan-select.2.update.sqlpp
    • -0
    • +27
    ./push-limit-to-primary-scan-select/push-limit-to-primary-scan-select.3.query.sqlpp
    • -0
    • +26
    ./push-limit-to-primary-scan-select/push-limit-to-primary-scan-select.4.query.sqlpp
    • -0
    • +42
    ./push-limit-to-primary-scan/push-limit-to-primary-scan.1.ddl.sqlpp
    • -0
    • +24
    ./push-limit-to-primary-scan/push-limit-to-primary-scan.2.update.sqlpp
    • -0
    • +26
    ./push-limit-to-primary-scan/push-limit-to-primary-scan.3.query.sqlpp
  1. … 39 more files in changeset.