[
https://issues.apache.org/jira/browse/CASSANDRA-15317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16959038#comment-16959038
]
Benedict Elliott Smith commented on CASSANDRA-15317:
----------------------------------------------------
There was a discussion on this topic on the [mailing
list|https://www.mail-archive.com/[email protected]/msg13235.html] some
time ago, however it was hard to build consensus on the correct semantics to
offer.
FWIW, I agree with you, but it was contentious and I did not feel I had gained
sufficient authority to make any changes, even for the equivalent problem on
more recently introduced features.
> CAST AS function vulnerable to integer overflow
> -----------------------------------------------
>
> Key: CASSANDRA-15317
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15317
> Project: Cassandra
> Issue Type: Bug
> Components: CQL/Interpreter
> Reporter: Avi Kivity
> Priority: Normal
>
>
> {noformat}
> cqlsh:ks1> create table bigdec (k decimal primary key);
> cqlsh:ks1> insert into bigdec (k) values (100000000000000);
> cqlsh:ks1> select * from bigdec;
> k
> -----------------
> 100000000000000
> (1 rows)
> cqlsh:ks1> select cast(k as int) from bigdec;
> cast(k as int)
> ----------------
> 276447232{noformat}
> This overflow is unexpected for the user and can lead to incorrect results.
> Better to refuse to execute the query.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
