[jira] [Created] (IGNITE-25000) Sql. Time. Cast operation accept negative time components

[Maksim Zhuravkov (Jira)]

Maksim Zhuravkov created IGNITE-25000:
-----------------------------------------

             Summary: Sql. Time. Cast operation accept negative time components
                 Key: IGNITE-25000
                 URL: https://issues.apache.org/jira/browse/IGNITE-25000
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Maksim Zhuravkov



{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}




--
This message was sent by Atlassian Jira
(v8.20.10#820010)