[
https://issues.apache.org/jira/browse/IGNITE-25000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-25000:
--------------------------------------
Affects Version/s: 3.0
> Sql. Time. Cast operation accepts negative time components / out of range
> values
> --------------------------------------------------------------------------------
>
> Key: IGNITE-25000
> URL: https://issues.apache.org/jira/browse/IGNITE-25000
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0
> Reporter: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> {noformat}
> sql-cli> SELECT '-1:00:00'::TIME
> SQL query execution error
> Invalid value for NanoOfDay (valid values 0 - 86399999999999): -3600000000000
> sql-cli> SELECT '-0:00:00'::TIME
> ╔════════════════════╗
> ║ '-0:00:00' :: TIME ║
> ╠════════════════════╣
> ║ 00:00 ║
> ╚════════════════════╝
> sql-cli> SELECT '0:-00:00'::TIME
> ╔════════════════════╗
> ║ '0:-00:00' :: TIME ║
> ╠════════════════════╣
> ║ 00:00 ║
> ╚════════════════════╝
> sql-cli> SELECT '0:-10:00'::TIME
> SQL query execution error
> Invalid value for NanoOfDay (valid values 0 - 86399999999999): -600000000000
> sql-cli> SELECT '0:-01:00'::TIME
> SQL query execution error
> Invalid value for NanoOfDay (valid values 0 - 86399999999999): -60000000000
> sql-cli> SELECT '0:-1:00'::TIME
> SQL query execution error
> Invalid value for NanoOfDay (valid values 0 - 86399999999999): -60000000000
> sql-cli> SELECT '0:00:-00'::TIME
> ╔════════════════════╗
> ║ '0:00:-00' :: TIME ║
> ╠════════════════════╣
> ║ 00:00 ║
> ╚════════════════════╝
> sql-cli> SELECT '0:00:-01'::TIME
> SQL query execution error
> Invalid value for NanoOfDay (valid values 0 - 86399999999999): -1000000000
> sql-cli> SELECT '0:10:-01'::TIME
> ╔════════════════════╗
> ║ '0:10:-01' :: TIME ║
> ╠════════════════════╣
> ║ 00:09:59 ║
> ╚════════════════════╝
> sql-cli> SELECT '10:-01:00'::TIME
> ╔═════════════════════╗
> ║ '10:-01:00' :: TIME ║
> ╠═════════════════════╣
> ║ 09:59 ║
> ╚═════════════════════╝
> sql-cli> SELECT '23:00:60'::TIME
> ╔════════════════════╗
> ║ '23:00:60' :: TIME ║
> ╠════════════════════╣
> ║ 23:01 ║
> ╚════════════════════╝
> sql-cli> SELECT '23:59:60'::TIME
> SQL query execution error
> Invalid value for NanoOfDay (valid values 0 - 86399999999999): 86400000000000
> sql-cli> SELECT '22:60:60'::TIME
> ╔════════════════════╗
> ║ '22:60:60' :: TIME ║
> ╠════════════════════╣
> ║ 23:01 ║
> ╚════════════════════╝
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
