[
https://issues.apache.org/jira/browse/IGNITE-25317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-25317:
--------------------------------------
Fix Version/s: 3.1
> Sql. Time, Timestamp, Timestamp LTZ. Cast Format. Sub-millsecond fractional
> format is broken
> --------------------------------------------------------------------------------------------
>
> Key: IGNITE-25317
> URL: https://issues.apache.org/jira/browse/IGNITE-25317
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Assignee: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
> Fix For: 3.1
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> This error is caused by SimpleDateFormat that is used by parsing function is
> apache calcite.
> {noformat}
> sql-cli> SELECT CAST('23:02:03.123456789' AS TIME FORMAT 'hh24:mi:ss.FF9')
> ╔════════════════════════════════════════════════════════════╗
> ║ CAST('23:02:03.123456789' AS TIME FORMAT 'hh24:mi:ss.FF9') ║
> ╠════════════════════════════════════════════════════════════╣
> ║ 09:19:39 ║
> ╚════════════════════════════════════════════════════════════╝
> sql-cli> SELECT CAST('23:02:03.12345678' AS TIME FORMAT 'hh24:mi:ss.FF8')
> ╔═══════════════════════════════════════════════════════════╗
> ║ CAST('23:02:03.12345678' AS TIME FORMAT 'hh24:mi:ss.FF8') ║
> ╠═══════════════════════════════════════════════════════════╣
> ║ 02:27:48 ║
> ╚═══════════════════════════════════════════════════════════╝
> sql-cli> SELECT CAST('23:02:03.1234567' AS TIME FORMAT 'hh24:mi:ss.FF7')
> ╔══════════════════════════════════════════════════════════╗
> ║ CAST('23:02:03.1234567' AS TIME FORMAT 'hh24:mi:ss.FF7') ║
> ╠══════════════════════════════════════════════════════════╣
> ║ 23:22:37 ║
> ╚══════════════════════════════════════════════════════════╝
> sql-cli> SELECT CAST('23:02:03.1234567' AS TIME FORMAT 'hh24:mi:ss.FF6')
> ╔══════════════════════════════════════════════════════════╗
> ║ CAST('23:02:03.1234567' AS TIME FORMAT 'hh24:mi:ss.FF6') ║
> ╠══════════════════════════════════════════════════════════╣
> ║ 23:22:37 ║
> ╚══════════════════════════════════════════════════════════╝
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
