When using CONNECT Engine and Table Type ODBC, when using a HAVING clause for filtering data, wrong results are returned if no WHERE and GROUP BY clause is used.

For example:

SELECT

     *

FROM

     MyTable

HAVING

     MyColumn <> 'MyValue' OR MyColumn IS NULL

Does not perform a correct filtering. I think that the correct MariaDB behaviour with the HAVING clause shall be that a "local" copy of the table is done in MariaDB Server, bringing the table through ODBC connection, and then filter it in the "local" server itself.

Thank you,
Juan