My company has recently started using MemSQL for database storage. They claim to be compatible with MySQL, so they advise to use MySQL drivers whenever communicating with their database. Given this, I have added it as a MySQL database in DataGrip. So far this has been working... I am able to execute queries without any issues. However, DataGrip is unable to introspect the schema. When I start the introspection, I receive the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by seq_in_index separator '\n') as column_names,
from informa' at line 4
MemSQL is a newer, less popular database, so I understand why it is not (yet?) supported. However, I wondered if there is something I might be able to do (a configuration tweak or some such thing) to get this working. MySQL Workbench works with MemSQL without issue, so I don't believe there is a compatibility issue on the MemSQL side. Rather, it doesn't like the syntax of the introspection query generated by DataGrip.
Does anybody have experience or advice with this combination?