[
https://issues.apache.org/jira/browse/IGNITE-18657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17842003#comment-17842003
]
Iurii Gerzhedovich commented on IGNITE-18657:
---------------------------------------------
Right now the queries expected fails, but we have not so user-friendly error
message:
org.apache.ignite.sql.SqlException: IGN-SQL-9
TraceId:0460f382-120f-49a4-9ee2-e09ee90d4764 Numeric field overflow
For example, error in PG looks so:
ERROR: numeric field overflow DETAIL: A field with precision 3, scale 4 must
round to an absolute value less than 10^-1.
> Sql. Decimal casts DECIMAL::VARCHAR
> -----------------------------------
>
> Key: IGNITE-18657
> URL: https://issues.apache.org/jira/browse/IGNITE-18657
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Minor
> Labels: calcite2-required, calcite3-required, ignite-3
> Fix For: 3.0.0-beta2
>
>
> The following test cases in test_decimal.test do not fail:
> {code:java}
> # any value >= 1 becomes out of range, though
> skipif ignite3
> statement error
> SELECT '1'::DECIMAL(3, 3)::VARCHAR;
> skipif ignite3
> statement error
> SELECT '-1'::DECIMAL(3, 3)::VARCHAR;
> # various error conditions
> # scale must be bigger than or equal to width
> skipif ignite3
> statement error
> SELECT '0.1'::DECIMAL(3, 4);
> # width/scale out of range
> skipif ignite3
> statement error
> SELECT '0.1'::DECIMAL(1000);
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
