[CASSANDRA-16482] CQL schema generated by DESCRIBE KEYSPACE fails to import with custom indexes

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 4.0-rc1, 4.0
• Component/s: CQL/Syntax
• Bug Category: Correctness
• Severity: Normal
• Complexity: Normal
• Discovered By: User Report
• Platform: All
• Since Version: 4.0-beta1

Source Control Link

https://github.com/apache/cassandra/commit/87db9187c1cc56f0dcdcd4b1ae50a31f4191f580

Test and Documentation Plan

The patch add additional unit tests to DescribeStatementTest and SchemaCQLHelperTest

• Assignee: Benjamin Lerer
• Reporter: Mike Adamson

Authors

Benjamin Lerer

Reviewers

Brandon Williams

• Created: 03/Mar/21 18:17
• Updated: 16/Mar/22 15:32
• Resolved: 04/Mar/21 16:59

Description

The CQL schema generated by a DESCRIBE KEYSPACE on a keyspace with a table that contains a custom index cannot be reimported.

The reimport of the schema fails with:

InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot specify class_name as a CUSTOM option"

The reason for this is that the custom index definition is created with class_name and target options added to it in it's WITH OPTIONS section. This is then picked up by the IndexAttributes.validate method that specifically rejects them.

Note: This only seems to happen if the custom index was created with options in the first place. So if the CREATE CUSTOM INDEX statement didn't originally have a WITH OPTIONS section then it won't have the class_name and target options added to it.

Steps to reproduce

CREATE KEYSPACE test WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'};
CREATE TABLE test.test (id int PRIMARY KEY, value text);
CREATE CUSTOM INDEX ON test.test(value) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'is_literal': 'false'};
DESCRIBE KEYSPACE test;

Trying to import the resultant schema will fail.