[
https://issues.apache.org/jira/browse/CASSANDRA-20235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruslan Fomkin updated CASSANDRA-20235:
--------------------------------------
Fix Version/s: 5.0.x
5.1
> Fails creating custom index on column with special chars
> --------------------------------------------------------
>
> Key: CASSANDRA-20235
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20235
> Project: Apache Cassandra
> Issue Type: Bug
> 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}
> I see two issues:
> # The error message is misleading as the column name is not long.
> # May be the column name should be permitted.
> 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: [email protected]
For additional commands, e-mail: [email protected]
