Affects Version/s: 1.2.2
Fix Version/s: None
I can not figure out how to make a subquery work in doctrine. I get the subquery to look fine in DQL but when doctrine converts the DQL to SQL the subquery is automatically removed.
Here is an example:
Creates this DQL:
Which creates this broken SQL:
Notice that the subquery has been replaced with just "()".
Is there something wrong with my execution, does doctrine just not support subqueries, or is there a bug here?
Thanks much in advance.