[jira] [Assigned] (IGNITE-23171) Sql. Result of division doesn't match derived type

["Maksim Zhuravkov (Jira)" <ji...@apache.org>]

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

Maksim Zhuravkov reassigned IGNITE-23171:
-----------------------------------------

    Assignee: Maksim Zhuravkov

> Sql. Result of division doesn't match derived type
> --------------------------------------------------
>
>                 Key: IGNITE-23171
>                 URL: https://issues.apache.org/jira/browse/IGNITE-23171
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Konstantin Orlov
>            Assignee: Maksim Zhuravkov
>            Priority: Major
>              Labels: ignite-3
>
> Try to execute following query:
> {code}
> ignite.sql().execute(null, "SELECT CAST(? AS DECIMAL(32767, 32767)) / CAST(? AS DECIMAL(32767, 32767))", 1, 3)
> {code}
> Although type of the division and therefore type of a single column of result provided in metadata is {{DECIMAL(32767, 0)}}, actual value returned in result set has type {{DECIMAL(16, 16)}}.
> Need to make execution to respect types derived during query planning.



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