[jira] [Updated] (IGNITE-25000) Sql. Time. Cast operation accepts negative time components / out of range values

[Maksim Zhuravkov (Jira)]

     [ 
https://issues.apache.org/jira/browse/IGNITE-25000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Maksim Zhuravkov updated IGNITE-25000:
--------------------------------------
    Description: 
{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: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}


  was:
{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               ║
╚═════════════════════╝
{noformat}



> 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
>            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: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)