doctrine2 DQL subquery 1 row limit

Question

I want to do a DQL query like:

$dql = "select p
        from AcmeDemoBundle:UserTypeA p 
        where p.UserTypeB = :id
        and (
                 select top 1 r.boolean
                 from AcmeDemoBundle:Registry r
             ) 
        = true";

But it seems that TOP 1 it's not a valid function in doctrine2.

I can't figure out how can I limit the result of the subquery to one row.

Answer 1

DQL does not support limits on subqueries and neither LIMIT nor OFFSET.

See http://www.doctrine-project.org/jira/browse/DDC-885