gengliangwang commented on issue #26412: [SPARK-29774][SQL] Date and Timestamp type +/- null should be null as Postgres URL: https://github.com/apache/spark/pull/26412#issuecomment-566268589 @yaooqinn Thanks for the work, but I don't know the behavior before this PR from the PR description and discussions. I would suggest adding that in the PR description as well. I have to check with Spark 2.4.4 to find the previous behavior: ``` > spark.sql("select timestamp'1999-12-31 00:00:00' - null").show() org.apache.spark.sql.AnalysisException: cannot resolve '(TIMESTAMP('1999-12-31 00:00:00.0') - NULL)' due to data type mismatch: differing types in '(TIMESTAMP('1999-12-31 00:00:00.0') - NULL)' (timestamp and null).; line 1 pos 7; 'Project [unresolvedalias((946627200000000 - null), None)] +- OneRowRelation ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
