[
https://issues.apache.org/jira/browse/IGNITE-19947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17749198#comment-17749198
]
Maksim Zhuravkov commented on IGNITE-19947:
-------------------------------------------
[~zstan]
PG accepts the following query
{code:java}
SELECT CAST (0.0001 AS DECIMAL(1,4))
# 0.0001
{code}
Ignite returns numeric overflow.
> Sql. Fix CAST(n AS DECIMAL(precision, scale) behaviour for scale > precision.
> -----------------------------------------------------------------------------
>
> Key: IGNITE-19947
> URL: https://issues.apache.org/jira/browse/IGNITE-19947
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Maksim Zhuravkov
> Assignee: Evgeny Stanilovsky
> Priority: Minor
> Labels: ignite-3
>
> CAST(n AS DECIMAL(p, s) always returns `numeric field overflow` error when s
> > p which is not correct, in such case we should also check `n`.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
