Lauri Koobas created SPARK-36544:
------------------------------------
Summary: 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
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
