[
https://issues.apache.org/jira/browse/CASSANDRA-20235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruslan Fomkin updated CASSANDRA-20235:
--------------------------------------
Description:
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?
was:
For a table:
```
CREATE TABLE quoted (
key text,
"user-age" int,
PRIMARY KEY (key)
);
```
creating index:
```
CREATE CUSTOM INDEX quoted_userage ON quoted ("user-age")
USING 'StorageAttachedIndex';
```
fails with:
```
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"
```
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?
> 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
> Reporter: Ruslan Fomkin
> Priority: Normal
>
> 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]
