[SPARK-52715] Pretty SQL string of TIME - DAY-TIME INTERVAL - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Sub-task
Status: Resolved
Priority: Major
Resolution: Fixed
Affects Version/s: 4.1.0
Fix Version/s: 4.1.0
Component/s: SQL
Labels:
- pull-request-available

Description

Improve SQL representation of subtract of TIME and DAY-TIME INTERVAL.

Current form is:

TIME '12:30:00' + (- INTERVAL '12:29:59.000001' HOUR TO SECOND

should be changed to:

TIME '12:30:00' - INTERVAL '12:29:59.000001' HOUR TO SECOND

Attachments

Issue Links

links to

GitHub Pull Request #51403

Activity

People

Assignee:: Max Gekk

Reporter:: Max Gekk

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 08/Jul/25 20:22

Updated:: 09/Jul/25 05:38

Resolved:: 09/Jul/25 05:38