[
https://issues.apache.org/jira/browse/CASSANDRA-19897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Caleb Rackliffe reassigned CASSANDRA-19897:
-------------------------------------------
Assignee: Caleb Rackliffe
> Unable to create custom index on a column as index rejects columns with 48
> characters or more
> ---------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-19897
> URL: https://issues.apache.org/jira/browse/CASSANDRA-19897
> Project: Cassandra
> Issue Type: Bug
> Components: Feature/2i Index
> Reporter: David Capwell
> Assignee: Caleb Rackliffe
> Priority: Normal
> Fix For: 5.x
>
>
> {code}
> Caused by: org.apache.cassandra.exceptions.InvalidRequestException: Column
> '7RhJJOWurQaPmFzN3igcD1i7sfv0SzbEVp05XssFWH_Zjygpol' is longer than the
> permissible name length of 48 characters or contains
> non-alphanumeric-underscore characters
> at
> org.apache.cassandra.cql3.statements.schema.AlterSchemaStatement.ire(AlterSchemaStatement.java:222)
> at
> org.apache.cassandra.cql3.statements.schema.CreateIndexStatement.validateIndexTarget(CreateIndexStatement.java:218)
> at
> org.apache.cassandra.cql3.statements.schema.CreateIndexStatement.lambda$apply$1(CreateIndexStatement.java:177)
> at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
> at
> org.apache.cassandra.cql3.statements.schema.CreateIndexStatement.apply(CreateIndexStatement.java:177)
> at
> org.apache.cassandra.cql3.statements.schema.AlterSchemaStatement.execute(AlterSchemaStatement.java:159)
> at
> org.apache.cassandra.cql3.statements.schema.AlterSchemaStatement.executeLocally(AlterSchemaStatement.java:107)
> at org.apache.cassandra.cql3.CQLTester.schemaChange(CQLTester.java:1564)
> {code}
> Test that shows this
> {code}
> String name = createTable("CREATE TABLE %s(pk int PRIMARY KEY,
> this_is_a_very_long_name_that_create_table_allows int)");
> // create index in legacy works fine
> schemaChange(String.format("CREATE INDEX legacy ON
> %s.%s(this_is_a_very_long_name_that_create_table_allows)", KEYSPACE, name));
> schemaChange(String.format("DROP INDEX %s.legacy", KEYSPACE));
> // try again with CUSTOM index
> schemaChange(String.format("CREATE INDEX modern ON
> %s.%s(this_is_a_very_long_name_that_create_table_allows) USING 'SAI'",
> KEYSPACE, name));
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
