[ https://issues.apache.org/jira/browse/CASSANDRA-13116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tom van der Woerdt updated CASSANDRA-13116: ------------------------------------------- Description: Simply put : {code} cqlsh> create table foo (id int primary key, value text); [some inserts] cqlsh> select * from foo where id in (1, 128, 256, 65535, 65536, 16777215, 16777216, 2147483647); id | value ------------+------- 1 | test 128 | test 256 | test 65535 | test 65536 | test 16777215 | test 16777216 | test 2147483647 | test (8 rows) cqlsh> alter table foo alter id TYPE varint; cqlsh> select * from foo where id in (1, 128, 256, 65535, 65536, 16777215, 16777216, 2147483647); id | value ------------+------- 16777215 | test 16777216 | test 2147483647 | test (3 rows) cqlsh> select * from foo; id | value ------------+------- 128 | test 16777216 | test 1 | test 2147483647 | test 16777215 | test 256 | test 65535 | test 65536 | test {code} This could really ruin someone's day... was: Simply put : {code} cqlsh> select * from foo where id in (1, 128, 256, 65535, 65536, 16777215, 16777216, 2147483647); id | value ------------+------- 1 | test 128 | test 256 | test 65535 | test 65536 | test 16777215 | test 16777216 | test 2147483647 | test (8 rows) cqlsh> alter table foo alter id TYPE varint; cqlsh> select * from foo where id in (1, 128, 256, 65535, 65536, 16777215, 16777216, 2147483647); id | value ------------+------- 16777215 | test 16777216 | test 2147483647 | test (3 rows) cqlsh> select * from foo; id | value ------------+------- 128 | test 16777216 | test 1 | test 2147483647 | test 16777215 | test 256 | test 65535 | test 65536 | test {code} This could really ruin someone's day... > Don't allow changing the primary key from int to varint > ------------------------------------------------------- > > Key: CASSANDRA-13116 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13116 > Project: Cassandra > Issue Type: Bug > Components: Core > Reporter: Tom van der Woerdt > Priority: Critical > > Simply put : > {code} > cqlsh> create table foo (id int primary key, value text); > [some inserts] > cqlsh> select * from foo where id in (1, 128, 256, 65535, 65536, 16777215, > 16777216, 2147483647); > id | value > ------------+------- > 1 | test > 128 | test > 256 | test > 65535 | test > 65536 | test > 16777215 | test > 16777216 | test > 2147483647 | test > (8 rows) > cqlsh> alter table foo alter id TYPE varint; > cqlsh> select * from foo where id in (1, 128, 256, 65535, 65536, 16777215, > 16777216, 2147483647); > id | value > ------------+------- > 16777215 | test > 16777216 | test > 2147483647 | test > (3 rows) > cqlsh> select * from foo; > id | value > ------------+------- > 128 | test > 16777216 | test > 1 | test > 2147483647 | test > 16777215 | test > 256 | test > 65535 | test > 65536 | test > {code} > This could really ruin someone's day... -- This message was sent by Atlassian JIRA (v6.3.4#6332)