partition is now a reserved word in MariaDB 10.
the column name is correctly quoted with native libmysqlclient/libmariadb so works

the column name is not quoted with unixodbc+(libmyodbc8|libmaodbc) and so fails

try unquoted insert

-- fails unixodbc+libmaodbc
insert into location (partition) values (1000);

-- works native libmysqlclient|libmariadb
insert into location (partition) values (1000);

SQL insert into statement fails

—
Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you are subscribed to this thread.