[jira] [Updated] (IGNITE-22160) Sql. Usability of error message in case of numeric overflow

2024-05-08 Thread Iurii Gerzhedovich (Jira) 


 [ 
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)

[jira] [Updated] (IGNITE-22160) Sql. Usability for error message in case of numeric overflow

2024-05-02 Thread Iurii Gerzhedovich (Jira) 


 [ 
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 for error message in case of numeric overflow   
(was: Sql. Usability for )

> Sql. Usability for 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)

[jira] [Updated] (IGNITE-22160) Sql. Usability of error message in case of numeric overflow

2024-05-02 Thread Iurii Gerzhedovich (Jira) 


 [ 
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)