[jira] [Created] (IGNITE-28371) Sql. Cast special floating-point values to integer must produce out of range error

[Pavel Pereslegin (Jira)]

Pavel Pereslegin created IGNITE-28371:
-----------------------------------------

             Summary: Sql. Cast special floating-point values to integer must 
produce out of range error
                 Key: IGNITE-28371
                 URL: https://issues.apache.org/jira/browse/IGNITE-28371
             Project: Ignite
          Issue Type: Improvement
          Components: sql ai3
            Reporter: Pavel Pereslegin


Example:
{code:sql}
'NaN'::FLOAT::INT
{code}

Currently returns 0, but according to SQL spec must raise "data exception — 
numeric value out of range." (6.13 cast specification -> general rule 8).



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