Hi!
I’m working on a POC to set up central schema management inside our team.
I’d like to use SQLAlchemy and alembic to combine a pipeline where we can leverage the abstractions provided to generate the migration/revision files.
I’ve had initial success in using this to create tables and to progress an example schema backwards and forwards.
I’m running into issues I guess with the queries generated by alembic and SQLAlchemy of which this would be one example:
pymysql.err.OperationalError: (1706, “Feature ‘CHANGE which includes a type definition. Use MODIFY to change a columns type.’ is not supported by MemSQL.”)
It seems that there are inconsistencies on the driver level with what is used by MemSQL and I’m wondering is this something that is supposed to be an error like this?
Which mysql python driver would provide us with a compatiblity that MemSQL expects and correct queries. As you can see this is an error happening on pymysql which would be the best pick as it stands. Alternatively we could use the mysql-connector or mysqldb but these have other issues in db handshake etc.
Mind you this is something that, if it were targeting mysql db would and should work out of the box with our example schema.
Is there a way to maybe fix this on the MemSQL side or cluster configuration side? It seems to me that this breaks after it would hit the middle layer of mysql.