#80380Missing Distinct / GroupBy option in Query
Description
I encounter this Problem under Typo3 8.6.1
my Problem, I try to get objects with a condition which created joins.
my Result contains duplicate Records.
Example:
my Database contains 3 Records (CityA, CityB, CityC)
every city has 2 Pools of Zones which contains some Stores.
Some Stores are zone overlapping, which means,
CityA with innerZone1 contains StoreA and CityB with outerZone3 contains also StoreA
Now i want all Cities with a Specific store.
In our Example “Get all Cities which contains StoreA” will not only Result CityA, CityB …
the Actual Result is [CityA, CityA, CityB, CityB].
I have no chance to use an GroupBy or Distinct :(
See: https://github.com/brannow/frd_querybug/blob/master/Classes/Domain/Repository/CityRepository.php#L47-L59
For better understanding I created a proof of concept Extension for this behavior.
https://github.com/brannow/frd_querybug