Following https://ibm-analytics.slack.com/archives/C09EFMSN3NZ/p1771281506444369?thread_ts=1771279656.187539&cid=C09EFMSN3NZ
When you add a UDT column to a table, drop the column, and then attempt to re-add the column, you get this error that prevents re-adding the column:
{"status":{"ok":0},"errors":[{"message":"An unexpected server error occurred while using the driver with the database. \n\nThe command against the TABLE default_keyspace.quickstart_table may be in an inconsistent state due to the error encountered. It may have either: \n* Failed to start communicating with the database.\n* Encountered an error when being processed by the database.\n* Completed successfully, but returned an unexpected response.\n\nConsult the the detailed error message below for more information:\n\nError Class: InvalidQueryException\nError Message: Cannot re-add previously dropped column 'president' of type person, incompatible with previous type tuple<text, text>\n\nReview the Error Message before retrying this request.","scope":"DATABASE","errorCode":"UNEXPECTED_DRIVER_ERROR","id":"6f47c8ae-add7-42ef-bdc0-331ccd2bafd5","family":"SERVER","title":"Unexpected driver error"}]}
In this example, person is the UDT name and president is the column name.
It sounds like this is expected due to https://issues.apache.org/jira/browse/CASSANDRA-8099. However, we could make the error message clearer about what is happening.
Following https://ibm-analytics.slack.com/archives/C09EFMSN3NZ/p1771281506444369?thread_ts=1771279656.187539&cid=C09EFMSN3NZ
When you add a UDT column to a table, drop the column, and then attempt to re-add the column, you get this error that prevents re-adding the column:
In this example,
personis the UDT name andpresidentis the column name.It sounds like this is expected due to https://issues.apache.org/jira/browse/CASSANDRA-8099. However, we could make the error message clearer about what is happening.