[CASSANDRA-4171] cql3 ALTER TABLE foo WITH default_validation=int has no effect

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: Legacy/CQL
• Labels: cql3
• Severity: Low
• Assignee: Sylvain Lebresne
• Reporter: paul cannon

Authors

Sylvain Lebresne

Reviewers

Jonathan Ellis

• Created: 18/Apr/12 21:01
• Updated: 16/Apr/19 09:32
• Resolved: 20/Apr/12 15:36

Description

running the following with cql3:

CREATE TABLE test (foo text PRIMARY KEY) WITH default_validation=timestamp;
ALTER TABLE test WITH default_validation=int;

does not actually change the default validation type of the CF. It does under cql2.

No error is thrown. Some properties can be successfully changed using ALTER WITH, such as comment and gc_grace_seconds, but I haven't tested all of them. It seems probable that default_validation is the only problematic one, since it's the only (changeable) property which accepts CQL typenames.