This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB ODBC connector 3.1.4 with BEGIN NOT ATOMIC

getting an error from a MariaDB server (version 10.3.11) when my query includes a BEGIN ATOMIC.

Query works fine when using mysql ODBC connector 5.3.10 to the same server.

BEGIN NOT ATOMIC SET @CONTEXT_INFO ='HP17 # Nigel:::rentman.opendata@21:rentman.finddata@32';select * from misc; END;

[10.3.11-MariaDB-1:10.3.11+mariacosmic]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

what am i missing?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.