ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Max Shonichev (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-10424) expected SqlException not thrown
Date Tue, 27 Nov 2018 13:26:00 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-10424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Max Shonichev updated IGNITE-10424:
-----------------------------------
    Labels: sql  (was: )

> expected SqlException not thrown
> --------------------------------
>
>                 Key: IGNITE-10424
>                 URL: https://issues.apache.org/jira/browse/IGNITE-10424
>             Project: Ignite
>          Issue Type: Bug
>    Affects Versions: 2.5
>            Reporter: Max Shonichev
>            Priority: Major
>              Labels: sql
>             Fix For: 2.8
>
>
> When running query 
> {noformat}
> SELECT SUM(field2*1000000000) FROM tmp_table_age_name_wage;
> {noformat}
> Apache Ignite 2.4 threw SqlException Numeric value out of range: "100000000000000";
> Apache Ignite 2.5 does not wrap underlying exception and throws javax.cache.CacheException
instead
> {noformat}
> SELECT SUM(field2*1000000000) FROM tmp_table_age_name_wage;
> Expected error:
> Numeric value out of range
> Actual error:
> Error: javax.cache.CacheException: Failed to execute map query on remote node [nodeId=76cea51c-87a3-4054-b39e-1ad6d01c0df6,
errMsg=Failed to execute SQL query. Numeric value out of range: "100000000000000"; SQL statement:
>  SELECT
>  SUM(__Z0.FIELD2 * 1000000000) __C0_0
>  FROM PUBLIC.TMP_TABLE_AGE_NAME_WAGE __Z0 [22003-195]] (state=50000,code=0)
>  java.sql.SQLException: javax.cache.CacheException: Failed to execute map query on remote
node [nodeId=76cea51c-87a3-4054-b39e-1ad6d01c0df6, errMsg=Failed to execute SQL query. Numeric
value out of range: "100000000000000"; SQL statement:
>  SELECT
>  SUM(__Z0.FIELD2 * 1000000000) __C0_0
>  FROM PUBLIC.TMP_TABLE_AGE_NAME_WAGE __Z0 [22003-195]]
>  	at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:779)
>  	at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:210)
>  	at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:473)
>  	at sqlline.Commands.execute(Commands.java:823)
>  	at sqlline.Commands.sql(Commands.java:733)
>  	at sqlline.SqlLine.dispatch(SqlLine.java:795)
>  	at sqlline.SqlLine.runCommands(SqlLine.java:1706)
>  	at sqlline.Commands.run(Commands.java:1317)
>  	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>  	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>  	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>  	at java.lang.reflect.Method.invoke(Method.java:498)
>  	at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
>  	at sqlline.SqlLine.dispatch(SqlLine.java:791)
>  	at sqlline.SqlLine.initArgs(SqlLine.java:595)
>  	at sqlline.SqlLine.begin(SqlLine.java:643)
>  	at sqlline.SqlLine.start(SqlLine.java:373)
>  	at sqlline.SqlLine.main(SqlLine.java:265)
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message