Max Gekk created SPARK-57560:
--------------------------------
Summary: Support TRY eval mode for TIME datetime arithmetic
Key: SPARK-57560
URL: https://issues.apache.org/jira/browse/SPARK-57560
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 4.3.0
Reporter: Max Gekk
h2. What
Support TRY-eval semantics for TIME datetime arithmetic ({{TIME +/- day-time
INTERVAL}},
and TIME-related add expressions) so that {{try_*}} wrappers and {{try}} mode
return NULL
on overflow/out-of-range instead of throwing.
h2. Why
{{TryEval}} carries a TODO to support TRY eval mode on datetime arithmetic
expressions.
TIME arithmetic ({{TimeAddInterval}}, {{SubtractTimes}}) is in this family;
without TRY
support, {{try_add}}-style usage over TIME cannot suppress errors consistently
with the
rest of the datetime types.
h2. Scope
* Extend the datetime-arithmetic TRY handling in {{TryEval}} (and the relevant
arithmetic
expressions) to cover the TIME expressions.
* Ensure ANSI/non-ANSI behavior parity with other datetime arithmetic.
h2. Acceptance criteria
* TRY-mode TIME arithmetic returns NULL (not an error) on out-of-range results.
* Tests added covering boundary/overflow cases.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
