translations on many-to-many object relationships returns no rows

Description

if you have an object called e.g. farm which has a many-to-many to another object called animals. We run the selectManyToManyData() method to get all animals for our farm.

If you then make animals translatable, and create a french farm animal, then the selectManyToManyData() fails when trying to select all the original language animals, as by default it is now joining onto the translation tables all the time, and there isn't a row for english

e.g. this returns no rows, when i would expect it to return 1

if we delete the french (all) translations for pobj_cmeformat then the query works perfectly and returns 1 row, as it doesn't now join onto the translation table

Environment

None

Assignee

Unassigned

Reporter

Steve Dowle

Labels

None

Accepted

Yes

Fix versions

Affects versions

Priority

Medium
Configure