[CASSANDRA-13116] Don't allow changing the primary key from int to varint

• Type: Bug
• Status: Resolved
• Priority: Urgent
• Resolution: Duplicate
• Component/s: Legacy/Core
• Severity: Critical
• Assignee: Unassigned
• Reporter: Tom van der Woerdt
• Created: 11/Jan/17 09:13
• Updated: 16/Apr/19 09:30
• Resolved: 11/Jan/17 09:38

Description

Simply put :

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

This could really ruin someone's day...

Issue Links

• duplicates: CASSANDRA-12443 Remove alter type support