Clone Tools
  • last updated a few minutes ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[ASTERIXDB-2648][COMP] Fix dataset order in broadcast hint

- user model changes: yes

- storage format changes: no

- interface changes: no

details:

- Provides hash-bcast hint to replace bcast hint which makes

broadcast join consistent with other types of joins for choosing

the broadcasting dataset based on dataset order in FROM clause.

- Chooses the build dataset to get broadcast based on the order

in the FROM clause not the WHERE clause (which was the case for

bcast hint).

Change-Id: I505fc8e0bc32c760ae0471c6b302bbfd8499be4a

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

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

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

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

  1. … 51 more files in changeset.
[NO ISSUE][COMP] Prevent broadcast hint changes left-outer-join semantic

- user model changes: no

- storage format changes: no

- interface changes: no

Details:

The current way of handling broadcast hint can cause a problem in a

certain case. When we have a subquery containing join, the inline

subplan rule will transform it into a left-outer-join. If the join in

the subquery has a broadcast hint and the broadcast side is left, then

the JoinUtils will switch the two branches blindly which can break the

semantic of the left-outer-join.

Change-Id: I522b5f1edf35a1c46f2e2ef1b265049d3c18a575

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

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
    • +41
    ./nested_query_with_bcast.sqlpp
  1. … 2 more files in changeset.