MS Access + MariaDB connector crashes when running specific query

In my company we use a MS Access application with a MariaDB Galera cluster. For the moment we use the MySQL connector, but we would like to migrate to the MariaDB connector at some point.

Therefore we are performing some test right now and realised that the development version of our application fails to open one specific window. The changes made in that window, and which definitely are causing the issue (the simple query works), are just a query change from this simple query:

SELECT id, titleen as title FROM tblorg

to this query:

SELECT tblomain.id, tblomain.title

FROM (

SELECT tbloaux1.id, tbloaux1.titleen as title 

FROM tblorg tbloaux1 

UNION 

SELECT tbloaux2.id, tbloaux2.titlelongen as title 

FROM tblorg tbloaux2)  

AS tblomain

ORDER BY tblomain.title;

When including this last query, the application fails to open the window correctly and crashes.

I am aware that this query is somehow weird, but this is quite a special request from our users and access sql is also a bit weird for certain things sometimes.

Thanks in advance for having a look to this issue.