Status: Open (View Workflow)
Affects Version/s: 3.1.12
Fix Version/s: 3.1
Environment:Windows 10 1909+ 64 bit, MS Access 2016 32 bit, MariaDB ODBC driver 32 bit 3.1.12 (same with 3.1.11), Remote Mariadb 10.5.9 linux 64 bit.
Exporting a table through odbc that contains single/double data type results in error "[ma-3.1.12][10.5.9-MariaDB-log]Incorrect column specifier for column 'h2'" 1063
The SQL trace log converts for both single/double to type FLOAT(255), which mariadb does not allow insertion.
Is there anything that I might have missed on configurations. Tried to remove strict all tables setting in mariadb but that does not help.
My understanding is that FLOAT, FLOAT(255,0) or alike are expected by database.
Error log attached per ODBC trace and a screenshot of simple unit test access db.
Many thanks for any feedback.