Affects Version/s: 3.1.0
Fix Version/s: None
Query via DAS 1.3.0 or beeline 22.214.171.124.1.0.0-78
When cast is called on a column (or derived column) and the cast does not succeed it is supposed to return null. Which is what it returns at the end of the query, but some evaluations within the query do not evaluate to null, unless the predicate of the cast is null.
will return null
will return true (which is wrong)
will return false (which is correct)
full example to demonstrate problem
Expected result is true if the date string was a valid convertible date string, false otherwise.
Query (incorrectly) returns true for actual result when dateString is empty, whitespace, or characters.
Query only returns correct result when dateString is convertible or null.