MaxGekk commented on issue #26034: [SPARK-29364][SQL] Return an interval from date subtract according to SQL standard URL: https://github.com/apache/spark/pull/26034#issuecomment-538714490 > Oh, PostgreSQL doesn't follow ANSI like this PR? it doesn't in dates subtract. > If this is different from the existing Apache Spark behavior and also different from PostgreSQL, it makes the decision on this PR more harder. This introduces new behavior in **non-default configuration** when `spark.sql.ansi.enabled = true` which means by definition _"When true, Spark tries to conform to the ANSI SQL specification ..."_ > If then, please add the other DBMS reference for this ANSI feature into the PR description. What is the purpose of such comparison. Would you like to see how others conform to the SQL standard? If let's say most of them doesn't, Spark also should not?
---------------------------------------------------------------- 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]
