[ https://issues.apache.org/jira/browse/IMPALA-12051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Quanlong Huang updated IMPALA-12051: ------------------------------------ Fix Version/s: Impala 4.3.0 > Propagate analytic tuple predicates of outer-joined InlineView > -------------------------------------------------------------- > > Key: IMPALA-12051 > URL: https://issues.apache.org/jira/browse/IMPALA-12051 > Project: IMPALA > Issue Type: Bug > Reporter: ZhuMinghui > Assignee: ZhuMinghui > Priority: Major > Fix For: Impala 4.3.0 > > Attachments: image-2023-04-07-11-57-13-571.png, > image-2023-04-07-11-57-59-883.png > > > In some cases, direct pushing down predicates that reference analytic tuple > into inline view leads to incorrect query results. such as sql: > {code:java} > WITH detail_measure AS ( > SELECT > * > FROM > ( > VALUES > ( > 1 AS `isqbiuar`, > 1 AS `bgsfrbun`, > 1 AS `result_type`, > 1 AS `bjuzzevg` > ), > (2, 2, 2, 2) > ) a > ), > order_measure_sql0 AS ( > SELECT > row_number() OVER ( > ORDER BY > row_number_0 DESC NULLS LAST, > isqbiuar ASC NULLS LAST > ) AS `row_number_0`, > `isqbiuar` > FROM > ( > VALUES > (1 AS `row_number_0`, 1 AS `isqbiuar`), > (2, 2) > ) b > ) > SELECT > detail_measure.`isqbiuar` AS `isqbiuar`, > detail_measure.`bgsfrbun` AS `bgsfrbun`, > detail_measure.`result_type` AS `result_type`, > detail_measure.`bjuzzevg` AS `bjuzzevg`, > `row_number_0` AS `row_number_0` > FROM > detail_measure > LEFT JOIN order_measure_sql0 ON order_measure_sql0.isqbiuar = > detail_measure.isqbiuar > WHERE > row_number_0 BETWEEN 1 > AND 1 > ORDER BY > `row_number_0` ASC NULLS LAST, > `bgsfrbun` ASC NULLS LAST{code} > The current query result is: > !image-2023-04-07-11-57-13-571.png! > The correct query result is: > !image-2023-04-07-11-57-59-883.png! > -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org