[CASSANDRA-3513] CQL Schema metadata does not contain Type information for the key unless the key is selected

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Won't Fix
• Labels: cql
• Severity: Low
• Assignee: Unassigned
• Reporter: Kelley Reynolds
• Created: 21/Nov/11 16:52
• Updated: 16/Apr/19 09:32
• Resolved: 21/Nov/11 17:47

Description

The CQL ResultSchema does not contain type information for the key unless the key is actually part of the CQL query. It's available in the column family schema but that's what we're trying to avoid by having a ResultSchema in the first place.

CREATE COLUMNFAMILY test (id varchar PRIMARY KEY, serial int)
INSERT INTO test (id, serial) VALUES ('test', 12345)
SELECT serial FROM test where id='test'

1. The Result Schema
   • • !ruby/object:CassandraCQL::ResultSchema
       names: {}

values:
serial: Int32Type

1. The row with no way to properly cast the key (though I used varchar here to make a functional example)
   • • !ruby/object:CassandraCQL::Thrift::CqlRow
       columns:

• !ruby/object:CassandraCQL::Thrift::Column
  name: serial
  timestamp: 1321893998457001
  value: !binary |
  AAAwOQ==

key: test