We are using a MySQL 5.6 compatible DB (AWS Aurora Serverless 5.6.10a) and have a table named "position".
Until now, we used the MySQL connector and had no issues accessing that table.
Recently we tried to switch to MariaDB Connector/J 2.5.4 and encountered a surprising issue:
While selecting from or updating that table works fine using MariaDB Connector/J, inserting into the "position" table raises the error:
java.sql.SQLSyntaxErrorException: (conn=106) 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 'position (asset_name, [...]
The issue is that the table is named "position", though "position" does not seem to be a reserved keyword in either MariaDB or MySQL (according to online docs). Also it's weird that selecting and updating works but not inserting...
We could of course work around this by putting position in ticks (`position`) or by renaming the table but it struck us as weird and maybe it's a bug in MariaDB Connector/J.