[ https://issues.apache.org/jira/browse/SPARK-17494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Davies Liu reassigned SPARK-17494: ---------------------------------- Assignee: Davies Liu > Floor function rounds up during join > ------------------------------------ > > Key: SPARK-17494 > URL: https://issues.apache.org/jira/browse/SPARK-17494 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 1.6.1, 2.0.0 > Reporter: Gokhan Civan > Assignee: Davies Liu > Labels: correctness > > If you create tables as follows: > create table a as select 'A' as str, cast(10.5 as decimal(15,6)) as num; > create table b as select 'A' as str; > Then > select floor(num) from a; > returns 10 > but > select floor(num) from a join b on a.str = b.str; > returns 11 -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org