[ https://issues.apache.org/jira/browse/IMPALA-7211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zoltán Borók-Nagy reassigned IMPALA-7211: ----------------------------------------- Assignee: Zoltán Borók-Nagy > Query with a decimal between predicate needlessly fails > ------------------------------------------------------- > > Key: IMPALA-7211 > URL: https://issues.apache.org/jira/browse/IMPALA-7211 > Project: IMPALA > Issue Type: Bug > Components: Frontend > Affects Versions: Impala 3.0 > Reporter: Taras Bobrovytsky > Assignee: Zoltán Borók-Nagy > Priority: Critical > Labels: regression > > The following query causes an analysis exception because decimal(38,2) and > decimal(38,3) are not compatible, i.e. it is not possible to cast them to the > same decimal type without losing information. > {code} > select cast(1 as decimal(38,2)) between 0.9 * cast(1 as decimal(38,3)) and 3 > {code} > However, if we rewrite the between predicate, it succeeds. > {code} > select cast(1 as decimal(38,2)) >= 0.9*cast(1 as decimal(38,3)) and cast(1 as > decimal(38,2)) <= 3 > {code} > Both queries should execute successfully. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org