You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Ian Maxon (Jira)" <ji...@apache.org> on 2025/04/04 17:06:00 UTC

[jira] [Assigned] (ASTERIXDB-3589) Complex join predicate needs to be replaced with expressions from assign statements

     [ https://issues.apache.org/jira/browse/ASTERIXDB-3589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ian Maxon reassigned ASTERIXDB-3589:
------------------------------------

    Assignee: murali krishna

> 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
>
> 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)