Github user wangyum commented on a diff in the pull request:
https://github.com/apache/spark/pull/18853#discussion_r137965884
--- Diff: sql/core/src/test/scala/org/apache/spark/sql/DataFrameSuite.scala
---
@@ -1966,7 +1966,7 @@ class DataFrameSuite extends QueryTest with
SharedSQLContext {
test("SPARK-17913: compare long and string type column may return
confusing result") {
val df = Seq(123L -> "123", 19157170390056973L ->
"19157170390056971").toDF("i", "j")
- checkAnswer(df.select($"i" === $"j"), Row(true) :: Row(false) :: Nil)
+ checkAnswer(df.select($"i" === $"j"), Row(true) :: Row(true) :: Nil)
--- End diff --
To compatible with Hive, MySQL and Oracle:
<img width="1319" alt="oracle"
src="https://user-images.githubusercontent.com/5399861/30254791-f2e6cc28-96cf-11e7-817e-c837c42d7504.png";>
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
![https://user-images.githubusercontent.com/5399861/30254791-f2e6cc28-96cf-11e7-817e-c837c42d7504.png"](https://user-images.githubusercontent.com/5399861/30254791-f2e6cc28-96cf-11e7-817e-c837c42d7504.png"){kind=link}