It seems INDEX BY only works in the FROM, not in JOIN clauses.
This is a dependency for DDC-250
DDC-250 ArrayCollection Key Column @indexBy
Fixed
Fixed