[
https://issues.apache.org/jira/browse/SPARK-57563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated SPARK-57563:
-----------------------------------
Labels: pull-request-available (was: )
> Add SQL golden-file test coverage for TIME to match DATE/TIMESTAMP
> ------------------------------------------------------------------
>
> Key: SPARK-57563
> URL: https://issues.apache.org/jira/browse/SPARK-57563
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 4.3.0
> Reporter: Max Gekk
> Priority: Major
> Labels: pull-request-available
>
> h2. What
> Add TIME coverage to the SQL golden-file tests (sql-tests) where
> DATE/TIMESTAMP have it but
> TIME does not.
> h2. Gaps
> * try_cast.sql: add TRY_CAST(... AS time).
> * try_datetime_functions.sql: add try_to_time.
> * datetime-parsing.sql / datetime-parsing-invalid.sql /
> datetime-parsing-legacy.sql: TIME parsing.
> * datetime-formatting.sql / datetime-formatting-invalid.sql /
> datetime-formatting-legacy.sql:
> TIME formatting (coordinate with time_format, SPARK-54588).
> * typeCoercion/native/dateTimeOperations.sql: TIME +/- interval and TIME -
> TIME coercion cases.
> * Port a postgreSQL/time.sql analogous to postgreSQL/date.sql and
> postgreSQL/timestamp.sql.
> h2. Scope
> * Add inputs and regenerate results + analyzer-results via SQLQueryTestSuite.
> Do NOT hand-edit
> the generated .sql.out files; regenerate and review the diff.
> h2. Acceptance criteria
> * New/updated golden files are committed and reviewed; TIME reaches parity
> with date/timestamp
> for these suites.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
