cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laing, Michael" <michael.la...@nytimes.com>
Subject Re: Getting code=2200 [Invalid query] message=Invalid column name ... while executing ALTER statement
Date Sat, 21 Nov 2015 13:52:15 GMT
>
> All these pain we need to take because the column names have special
>> character like " ' _- ( ) '' ¬ " etc.
>>
>
Hmm. I tried:

cqlsh:test> create table quoted_col_name ( pk int primary key, "'_-()""¬"
int);

cqlsh:test> select * from quoted_col_name;

 *pk* | *'_-()"¬*

----+---------
(0 rows)


So one can quote at least some chars, including all the ones you mentioned.

However, cqlsh does have a bug:

cqlsh:test> DESCRIBE TABLE quoted_col_name

*'ascii' codec can't decode byte 0xc2 in position 72: ordinal not in
range(128)*

Anyway, perhaps you can avoid the "pain" you referenced above.

ml

Mime
View raw message