[ https://issues.apache.org/jira/browse/CASSANDRA-15269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17361546#comment-17361546 ]
Berenguer Blasi commented on CASSANDRA-15269: --------------------------------------------- Thx! So if I didn't get things wrong is this what we're after? {noformat} [cqlsh 6.0.0 | Cassandra 4.0-rc2-SNAPSHOT | CQL spec 3.4.5 | Native protocol v5] Use HELP for help. cqlsh> select numerator % denominator from test.d; Traceback (most recent call last): File "/home/bereng/work/repos/bdpWS/15269/bin/cqlsh.py", line 1076, in perform_simple_statement result = future.result() File "/home/bereng/work/repos/bdpWS/15269/bin/../lib/cassandra-driver-internal-only-3.25.0.zip/cassandra-driver-3.25.0/cassandra/cluster.py", line 4894, in result raise self._final_exception cassandra.FunctionFailure: Error from server: code=1400 [User Defined Function failure] message="execution of 'system._modulo[decimal, decimal]' failed: the operation 'decimal % decimal' failed: Division impossible" cqlsh> select * from test.d; numerator | denominator --------------------------------------+------------- 123456789112345678921234567893123456 | 2 (1 rows) {noformat} PR is [here|https://github.com/apache/cassandra/pull/1057] with the mentioned revert so that it can be tested with the repro steps at the top of the ticket. Once we agree is good I'll remove the revert. > Cassandra fails to process OperationExecutionException which causes > ClassCastException > -------------------------------------------------------------------------------------- > > Key: CASSANDRA-15269 > URL: https://issues.apache.org/jira/browse/CASSANDRA-15269 > Project: Cassandra > Issue Type: Bug > Components: CQL/Interpreter > Reporter: Liudmila Kornilova > Assignee: Berenguer Blasi > Priority: Normal > Fix For: 4.0-rc2, 4.0, 4.0.x > > > While working on CASSANDRA-15232 I noticed that OperationExecutionException > is not processed correctly. > How to reproduce the issue: > 1. {{create table d (numerator decimal primary key, denominator decimal);}} > 2. {{insert into d (numerator, denominator) values > (123456789112345678921234567893123456, 2);}} > 3. {{select numerator % denominator from d;}} > What happens: > 1. remainder operation throws ArithmeticException (BigDecimal:1854) > 2. The exception is wrapped in OperationExecutionException > 3. ClassCastException appears (OperationExecutionException cannot be cast to > FunctionExecutionException at ErrorMessage.java:280) > What should happen: > OperationExecutionException with message "the operation 'decimal % decimal' > failed: Division impossible" should be delivered to user > Note that after fixing CASSANDRA-15232 {{select numerator % denominator from > d;}} will produce correct result of remainder operation. > Currently I am not aware of other cases when OperationExecutionException may > be treated as FunctionExecutionException -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org