Large IN expression may fail with 'duplicate column name'

The following query will return all records from the table. It will work just fine. However, once the IN's haystack becomes sufficiently large (e.g. >500 items), then an error message is given "#1060 - Duplicate column name 'aaaaa'". I suppose MariaDB creates a temporary internally and uses the searched expressions as column names. As we can see, this may fail.

SELECT ALL * FROM `test_table_schema`.`test_table`
WHERE
(
(
'aaaaa',
'aaaaa'
)
)
IN
(
(
'aaaaa',
'aaaaa'
),
(
'aaaaa',
'aaaaa'
)
)