You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Pereslegin (Jira)" <ji...@apache.org> on 2026/03/26 08:55:00 UTC

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

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)