[ 
https://issues.apache.org/jira/browse/CASSANDRA-15269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17364054#comment-17364054
 ] 

Berenguer Blasi commented on CASSANDRA-15269:
---------------------------------------------

There it goes:

{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="The operation 'decimal % decimal' failed: Division impossible"

cqlsh> select * from test.d;

 numerator                            | denominator
--------------------------------------+-------------
 123456789112345678921234567893123456 |           2

(1 rows)
{noformat}

> 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.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

Reply via email to