[
https://issues.apache.org/jira/browse/IGNITE-22160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich updated IGNITE-22160:
----------------------------------------
Summary: Sql. Usability of error message in case of numeric overflow
(was: Sql. Usability for error message in case of numeric overflow )
> Sql. Usability of error message in case of numeric overflow
> ------------------------------------------------------------
>
> Key: IGNITE-22160
> URL: https://issues.apache.org/jira/browse/IGNITE-22160
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Iurii Gerzhedovich
> Priority: Major
> Labels: ignite-3
>
> Let's consider error messages for the following queries:
> SELECT '1'::DECIMAL(3, 3)::VARCHAR;
> SELECT '-1'::DECIMAL(3, 3)::VARCHAR;
> SELECT '0.1'::DECIMAL(3, 4);
> Right now the queries expected to fail, but we have not so user-friendly
> error messages like a
> {code:java}
> IGN-SQL-9 TraceId:0460f382-120f-49a4-9ee2-e09ee90d4764 Numeric field
> overflow{code}
> For example, an error in PG looks so:
> {code:java}
> ERROR: numeric field overflow DETAIL: A field with precision 3, scale 4 must
> round to an absolute value less than 10^-1.
>
> {code}
> Let's improve error messages.
> Start point is using of
> {code:java}
> org.apache.ignite.internal.sql.engine.prepare.IgniteSqlValidator#NUMERIC_FIELD_OVERFLOW_ERROR{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
