Closed
Description
openedon Aug 19, 2024
Problem
Validation failed for data: Cannot cast expression `'[]'` of type `text` to `text_array`
Details
@wierdvanderhaar reported that when the CDC transformer processes an UPDATE event, generating an SQL statement like that
UPDATE "demo" SET data['items'] = '[]'an exception is raised.
sqlalchemy.exc.ProgrammingError: (crate.client.exceptions.ProgrammingError) ColumnValidationException[Validation failed for data: Cannot cast expression `'[]'` of type `text` to `text_array`]Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Metadata
Assignees
Labels
No labels