Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.10
-
None
Description
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'
)
)