Create a table with table name `ann` will invoke `SyntaxError` exception

[Hazel-Datastax]

Reproduction:

create table :

{
    "createTable": {
        "name": "ann",
        "definition": {
            "columns": {
                "t": "text",
                "v": {
                    "type": "vector",
                    "dimension": 5
                }
            },
            "primaryKey": "t"
        }
    }
}

response:

{
    "status": {
        "ok": 0
    },
    "errors": [
        {
            "message": "An unexpected server error occurred while processing the request. \n\nError Class: SyntaxError\nError Message: line 1:34 mismatched character '(' expecting set null",
            "scope": "",
            "errorCode": "UNEXPECTED_SERVER_ERROR",
            "exceptionClass": "ServerException",
            "id": "04ac1a97-232b-42ac-bdc2-38b6764f9ab0",
            "family": "SERVER",
            "title": "Unexpected server error"
        }
    ]
}

log:

RequestLogger.java:244 - [default_tenant|1390275793][Node(endPoint=/127.0.0.1:9042, hostId=0696a29c-0adb-4f00-904a-45a3450049a7, hashCode=2ad7212e)] Error (9 ms) [0 values] CREATE TABLE default_keyspace.ann (t text PRIMARY KEY,v VECTOR<float,5>) WITH extensions={'com.datastax.data-api.schema-type':'0x7461626c65','com.datastax.data-api.schema-def-version':'0x31'}: com.datastax.oss.driver.api.core.servererrors.SyntaxError: line 1:34 mismatched character '(' expecting set null

I think the issue is ann is the keyword in CQL so it invokes the SyntaxError when executing CREATE TABLE default_keyspace.ann (t text PRIMARY KEY,v VECTOR<float,5>) ....

[Hazel-Datastax]

Using another CQL keyword select in CQL also triggers error:

cassandra@cqlsh:default_keyspace> CREATE TABLE default_keyspace.select (t text PRIMARY KEY,v VECTOR<float,5>);
SyntaxException: line 1:30 no viable alternative at input 'select' (CREATE TABLE default_keyspace.[select]...)

By adding a quote ("ann", "select"), the query will be fine:

cassandra@cqlsh:default_keyspace> CREATE TABLE default_keyspace."ann" (t text PRIMARY KEY,v VECTOR<float,5>);

cassandra@cqlsh:default_keyspace> CREATE TABLE default_keyspace."select" (t text PRIMARY KEY,v VECTOR<float,5>);

[Hazel-Datastax]

Tested another keyword select, it works:

{
    "createTable": {
        "name": "select",
        "definition": {
            "columns": {
                "t": "text",
                "v": {
                    "type": "vector",
                    "dimension": 5
                }
            },
            "primaryKey": "t"
        }
    }
}

CQL console:

cassandra@cqlsh:default_keyspace> describe tables;

"select" 

[Hazel-Datastax]

The problem could be easily solved in the driver. Created a PR in there: apache/cassandra-java-driver#2005

[anclrii]

We hit this issue in https://datastax.jira.com/browse/DBPE-15094. Is there a workaround we can apply?

[amorton]

Valid, we should fix and have a driver overload if needed

[tatu-at-datastax]

As per #2284 (test to reproduce issue):

• Fails on DSE 6.9
• PASSES on HCD

which is interesting.