Max Shonichev created IGNITE-10424: -------------------------------------- Summary: 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 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)