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 2023/05/03 10:12:00 UTC

[jira] [Commented] (IGNITE-19330) Incorrect metadata for Decimal type

    [ https://issues.apache.org/jira/browse/IGNITE-19330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17718880#comment-17718880 ] 

Pavel Pereslegin commented on IGNITE-19330:
-------------------------------------------

Returns `INT32` after [this change|https://github.com/apache/ignite-3/pull/1939/files#diff-0e37afc24419512f532b47387b1cc0030d4e16ee50f0bffbf96d5cff0f0b2690R557].

> Incorrect metadata for Decimal type
> -----------------------------------
>
>                 Key: IGNITE-19330
>                 URL: https://issues.apache.org/jira/browse/IGNITE-19330
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Yury Gerzhedovich
>            Assignee: Yury Gerzhedovich
>            Priority: Major
>              Labels: ignite-3
>
> Metadata for decimal result has incorrect scale and precision.
>  
> {code:java}
> sql("CREATE TABLE q(id INT PRIMARY KEY, val INT)");
> sql("INSERT INTO q VALUES (10, 10)");
> AsyncResultSet<SqlRow> rs = await(ses.executeAsync("SELECT id % ? from q", 4)); rs.metadata()  {code}
> The result is DECIMAL(16393, 16383) which is wrong



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