Some problems with the MariaDB parser

The IN where clause fails when used with a user variable. Example:

SET @Y = "'UK','USA'";

SELECT * FROM customer WHERE country in (@Y );

Returns 0 lines. The problem is that MariaDB, wrongly thinking the IN clause contains only one item transforms it in an EQUAL clause that fails.

Comparison operators modified by ALL, ANY, or SOME are only accepted with sub-select's. According to SQL they should by also accepted with list of values. For instance:

SELECT 5 > ANY (4,5,6);

This raises a syntax error; should not.