On Thu, May 3, 2012 at 12:46 PM, Eric Czech <firstname.lastname@example.org> wrote:
I can't believe I have to ask this but I have a CF with about 10 rows and the keys are literally 1 through 9.Why does this not work if I want the row where the key is ascii('5')?
cqlsh:Keyspace1> select first 1 * from CF where key = '5';KEY-----05
* I saw the Jira about the sort of phantom row with no values so I know why that's thereListing the keys shows something like this:cqlsh:Keyspace1> select key from CF ;key------333635383231393437If I prepend a '3' to my key queries it works but I can't possibly see why I would have to do that.cqlsh:Keyspace1> select first 1 * from CF where key = '35';( Returns the right rows for key '5')
Changing the validator appears to make no material difference beyond the key listing: