[ https://issues.apache.org/jira/browse/SPARK-17617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-17617: ------------------------------------ Assignee: Apache Spark > Remainder(%) expression.eval returns incorrect result > ----------------------------------------------------- > > Key: SPARK-17617 > URL: https://issues.apache.org/jira/browse/SPARK-17617 > Project: Spark > Issue Type: Bug > Components: SQL > Reporter: Sean Zhong > Assignee: Apache Spark > > h2.Problem > Remainder(%) expression returns incorrect result when using expression.eval > to calculate the result. expression.eval is called in case like constant > folding. > {code} > scala> -5083676433652386516D % 10 > res19: Double = -6.0 > // Wrong answer with eval!!! > scala> Seq("-5083676433652386516D").toDF.select($"value" % 10).show > |(value % 10)| > +------------+ > | 0.0| > +------------+ > // Triggers codegen, will not do constant folding > scala> sc.makeRDD(Seq("-5083676433652386516D")).toDF.select($"value" % > 10).show > +------------+ > |(value % 10)| > +------------+ > | -6.0| > +------------+ > {code} > Behavior of postgres: > {code} > seanzhong=# select -5083676433652386516.0 % 10; > ?column? > ---------- > -6.0 > (1 row) > {code} -- 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