[jira] [Commented] (CASSANDRA-20235) Relax limitation on column names for SAI

["Ruslan Fomkin (Jira)" <ji...@apache.org>]

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

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

It's good to fix it after CASSANDRA-20389 to avoid conflicts.

> 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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org