Collation aggregation for IN works differently for scalar and row arguments.
This script demonstrates the same problem:
i and j are equal letters in utf8_roman_ci
- c1 doing IN for scalar data returns the expected result
- c2 doing IN for ROW data with one value returns the expected result
- c3 doing IN for ROW data with more than one values returns a wrong result