#55959Joins on SubClasses
Description
The Typo3DbBackend Class does not respect the possibility you join a table with the same table. This happens if you use SubClasses which are connected.
An alias should be taken there. I managed to make this work, but its just a very quick and dirty solution. I replaced the backend by a patched, its attached to this issue. Just ignore the other modifications.
The approach is the usage of alias and a additional param in the function for the parent.
The problem occured when i made a query like this
->contains(location.rootline,uid)
where the aggregate i want to filter is a SubClass of the same class my location is a subClass of. So the join looked like
select * from tx_ex_domain_model_object left join tx_ex_domain_model_object on ….
Because SuperClass and SubClasses are a feature of extbase this is a must-have.
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.