[SPARK-46380] Replacing current time prior to inline table eval

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0, 3.5.1
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Aleksandar Tomic
• Reporter: Aleksandar Tomic
• Created: 12/Dec/23 13:52
• Updated: 22/Dec/23 01:53
• Resolved: 21/Dec/23 08:00

Description

When current time/date specific functions are being used as part of inline tables each invocation will be evaluated. Instead, proper behaviour would be to replace time expressions with current time/date and always return single value. Example

SELECT COUNT(DISTINCT ct) FROM VALUES
(CURRENT_TIMESTAMP()),
(CURRENT_TIMESTAMP()),
(CURRENT_TIMESTAMP()) as data(ct)
 
Is supposed to return 1, while currently it returns 3.

Issue Links

• links to: GitHub Pull Request #44316
• links to: GitHub Pull Request #44447