[ 
https://issues.apache.org/jira/browse/CASSANDRA-20235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18014077#comment-18014077
 ] 

Ruslan Fomkin commented on CASSANDRA-20235:
-------------------------------------------

{quote}It's good to fix it after CASSANDRA-20389 to avoid conflicts.
{quote}
After this it's necessary to remove a check in 
CreateIndexStatement.validateIndexTarget, which will be obsolete with 
completing this ticket.

> Relax limitation on column names for SAI
> ----------------------------------------
>
>                 Key: CASSANDRA-20235
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-20235
>             Project: Apache Cassandra
>          Issue Type: Improvement
>          Components: Feature/SAI
>            Reporter: Ruslan Fomkin
>            Assignee: Ruslan Fomkin
>            Priority: Normal
>             Fix For: 5.0.x, 5.1
>
>
> For a table:
> {code:java}
> CREATE TABLE quoted (
>    key        text,
>    "user-age"    int,
>    PRIMARY KEY (key)
> );{code}
> creating index:
> {code:java}
> CREATE CUSTOM INDEX quoted_userage ON quoted ("user-age")
>     USING 'StorageAttachedIndex';{code}
> fails with:
> {code:java}
> InvalidRequest: Error from server: code=2200 [Invalid query] message="Column 
> 'user-age' is longer than the permissible name length of 222 characters or 
> contains non-alphanumeric-underscore characters"{code}
> It will improve usability if SAI can be created on column names, which are 
> already supported during table creation. I.e., the above use case works.
> Is there any specific reason why a quoted column name with non-alpha-numeric 
> chars will not work for SAI?



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

Reply via email to