[ https://issues.apache.org/jira/browse/IGNITE-22160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Iurii Gerzhedovich updated IGNITE-22160: ---------------------------------------- Description: 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 (seems need to look alternative in different DBs): {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} was: 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} > 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 (seems need to look alternative in > different DBs): > {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)