[
https://issues.apache.org/jira/browse/ASTERIXDB-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17944625#comment-17944625
]
ASF subversion and git services commented on ASTERIXDB-3589:
------------------------------------------------------------
Commit 83a47bc6425e9fae4bce4f402c626d8cf3e8bd6c in asterixdb's branch
refs/heads/master from murali4104
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=83a47bc642 ]
[ASTERIXDB-3589][COMP] replace complex join predicate with expressions
Ext-ref: MB-66121
Change-Id: I355943fbf65fa0879b8a1e1827f6a4405997b05b
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/19608
Reviewed-by: <[email protected]>
Reviewed-by: <[email protected]>
Reviewed-by: Hussain Towaileb <[email protected]>
Tested-by: Jenkins <[email protected]>
Integration-Tests: Jenkins <[email protected]>
> Complex join predicate needs to be replaced with expressions from assign
> statements
> -----------------------------------------------------------------------------------
>
> Key: ASTERIXDB-3589
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3589
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: *DB - AsterixDB
> Reporter: murali krishna
> Assignee: murali krishna
> Priority: Minor
> Labels: triaged
>
> Consider part of the following plan from q05 ch2.
> select (true)
> assign [$$109] <- [numeric-mod(numeric-multiply($$107, $$108),
> 10000)] <<<<
> data-scan []<-[$$107, $$108, $$s] <- Default.stock
> empty-tuple-source
> Later on in the plan there is a join predicate that references $$109.
> join (and(eq($$103, $$107), eq($$100, $$107), eq($$109, $$106)))
> eq ($$109, $$106) needs to replaced with
> eq(numeric-mod(numeric-multiply($$107, $$108), 10000), $$106).
> Otherwise, we will assume it a simple col = col join predicate which will
> yield an incorrect selectivity value. Our only option is to join the
> corresponding samples here as this is a complex expression.
> This is a subtle bug because we already handle this case when the assign
> [$$109] operator appears between join operators in the plan. In this case,
> it appeared in the leafinput which we had not handled previously.
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
