[ https://issues.apache.org/jira/browse/IMPALA-7254?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Taras Bobrovytsky updated IMPALA-7254: -------------------------------------- Affects Version/s: Impala 3.0 > Inconsistent decimal behavior for the IN predicate > -------------------------------------------------- > > Key: IMPALA-7254 > URL: https://issues.apache.org/jira/browse/IMPALA-7254 > Project: IMPALA > Issue Type: Bug > Components: Frontend > Affects Versions: Impala 3.0 > Reporter: Taras Bobrovytsky > Priority: Major > > The following query returns an error: > {code:java} > select cast(2 as decimal(38,37)) in (cast(3 as decimal(38,1)), cast(2 as > double)){code} > However, this query succeeds and returns true: > {code:java} > select cast(2 as decimal(38,37)) in (cast(2 as double), cast(3 as > decimal(38,1))){code} > The only difference is that the elements in the list are in a different > order. This behavior seems strange. Perhaps we should sort the elements > before analyzing? -- 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