[ https://issues.apache.org/jira/browse/SPARK-36544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17402366#comment-17402366 ]
Kousuke Saruta commented on SPARK-36544: ---------------------------------------- [~laurikoobas] The behavior was changed. See SPARK-35581. > Special strings for dates are no longer automatically converted without the > "date" keyword > ------------------------------------------------------------------------------------------ > > Key: SPARK-36544 > URL: https://issues.apache.org/jira/browse/SPARK-36544 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.1.2 > Environment: Databricks Runtime 9.0 > Reporter: Lauri Koobas > Priority: Major > > Comparison of a date type and a special string fail with DBR 9.0. > Works in earlier versions, returns "false": > {{select current_date > 'today'}} > With DBR 9.0 the same query returns "null" > Version that works in DBR 9.0: > {{select current_date > *date* 'today'}} > It's especially bad because people have written a lot of queries without > using this keyword and now all of those queries just silently fail as the > comparison returns a NULL. > Works (or rather fails) in the same way with all comparison operations. -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org