Iurii Gerzhedovich created IGNITE-22160:
-------------------------------------------
Summary: Sql. Usability for
Key: IGNITE-22160
URL: https://issues.apache.org/jira/browse/IGNITE-22160
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Iurii Gerzhedovich
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)
