[ https://issues.apache.org/jira/browse/SPARK-40732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17734038#comment-17734038 ]
Yang Jie commented on SPARK-40732: ---------------------------------- Thanks [~dongjoon] > Double type precision problem > ----------------------------- > > Key: SPARK-40732 > URL: https://issues.apache.org/jira/browse/SPARK-40732 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.4.0 > Reporter: Yang Jie > Priority: Major > > Some case in SQLQueryTestSuite(sql/core) and > ThriftServerQueryTestSuite(sql/hive-thriftserver) failed for this reason: > for example: > > {code:java} > SQLQueryTestSuite- > try_aggregates.sql *** FAILED *** > try_aggregates.sql > Expected "4.61168601842738[79]E18", but got "4.61168601842738[8]E18" Result > did not match for query #20 > SELECT try_avg(col) FROM VALUES (9223372036854775807L), (1L) AS tab(col) > (SQLQueryTestSuite.scala:495) > {code} > {code:java} > ThriftServerQueryTestSuite- try_aggregates.sql *** FAILED *** > Expected "4.61168601842738[79]E18", but got "4.61168601842738[8]E18" Result > did not match for query #20 > SELECT try_avg(col) FROM VALUES (9223372036854775807L), (1L) AS tab(col) > (ThriftServerQueryTestSuite.scala:222)- try_arithmetic.sql *** FAILED *** > Expected "-4.65661287307739[26]E-10", but got "-4.65661287307739[3]E-10" > Result did not match for query #26 > SELECT try_divide(1, (2147483647 + 1)) > (ThriftServerQueryTestSuite.scala:222)- datetime-{code} -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org