[jira] [Created] (IGNITE-23232) Sql. Different forms of notation for CAST operator return different results for same operands.

["Evgeny Stanilovsky (Jira)" <ji...@apache.org>]

Evgeny Stanilovsky created IGNITE-23232:
-------------------------------------------

             Summary: Sql. Different forms of notation for CAST operator return different results for same operands.
                 Key: IGNITE-23232
                 URL: https://issues.apache.org/jira/browse/IGNITE-23232
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 3.0.0-beta1
            Reporter: Evgeny Stanilovsky


Expected that:

{code:java}
SELECT -9223372036854775808::BIGINT/-1::BIGINT

{code}
and 

{code:java}
SELECT CAST (-9223372036854775808 as BIGINT)/-1::BIGINT
{code}
returns the same results, but it not true, check issue related code



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