cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vivek Mishra (JIRA)" <>
Subject [jira] [Created] (CASSANDRA-4779) Boolean type of composite column of compound primary key converted into UTF8Type
Date Tue, 09 Oct 2012 10:06:02 GMT
Vivek Mishra created CASSANDRA-4779:

             Summary: Boolean type of composite column of compound primary key converted into
                 Key: CASSANDRA-4779
             Project: Cassandra
          Issue Type: Bug
    Affects Versions: 1.1.5
            Reporter: Vivek Mishra

Steps to reproduce:
1) connect to cqlsh --cql3
2) create keyspace testcomp;
3) CREATE TABLE altercations (
       instigator text,
       started_at timestamp,
       ships_destroyed int,
       energy_used float,
       alliance_involvement boolean,
       PRIMARY KEY (instigator,started_at,ships_destroyed)
4) INSERT INTO altercations (instigator, started_at, ships_destroyed,
                             energy_used, alliance_involvement)
                     VALUES ('Jayne Cobb', '2012-07-24', 2, 4.6, 'false');
5) select * from altercations; gives output:
 instigator | started_at               | ships_destroyed | alliance_involvement | energy_used
 Jayne Cobb | 2012-07-23 00:00:00+0000 |               2 |                False |        

But when try to connect via cassandra-cli and execute:

6)list altercations; (output gives an error as below):
Using default limit of 100
Using default column limit of 100
RowKey: Jayne Cobb
=> (column=2012-07-23 00:00:00+0530:2:alliance_involvement, value=, timestamp=1349772570037000)
invalid UTF8 bytes 40933333

gives me  {invalid UTF8 bytes 40933333} 

Keyspace description:
Keyspace: testcomp:
  Replication Strategy: org.apache.cassandra.locator.NetworkTopologyStrategy
  Durable Writes: true
    Options: [datacenter1:1]
  Column Families:
    ColumnFamily: altercations
      Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
      Default column value validator: org.apache.cassandra.db.marshal.UTF8Type
      Columns sorted by: org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.DateType,org.apache.cassandra.db.marshal.Int32Type,org.apache.cassandra.db.marshal.UTF8Type)
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/32
      Read repair chance: 0.1
      DC Local Read repair chance: 0.0
      Replicate on write: true
      Caching: KEYS_ONLY
      Bloom Filter FP chance: default
      Built indexes: []
      Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
      Compression Options:


Although alliance_involvement is of "boolean" data type! which is causing this issue.

Looks like an issue with CompositeType creation, somehow boolean is also treated as UTF8Type.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message