[
https://issues.apache.org/jira/browse/IGNITE-23171?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-23171:
--------------------------------------
Description:
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.
was:
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.
> 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
> 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)
