Ruslan Fomkin created CASSANDRA-20235:
-----------------------------------------
Summary: 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
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?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
