Update query with LIMIT ( setMaxResults ) in doctrine2 using createQueryBuilder not working

[mfsianoopj]

I have following update query written using doctrine query builder:

$qb = $this->createQueryBuilder('cs')
->update()
->set('cs.is_active', 1)
->where('cs.reward_coupon = :reward_coupon')
->setMaxResults($limit)
->setParameter('reward_coupon', $rewardCoupon);
$qb->getQuery()->execute();

This doesn’t apply the LIMIT in the resultant query.

[Ocramius]

DQL doesn't allow limit on UPDATE queries, as it is not portable.
On Sep 2, 2014 6:25 AM, "mfsianoopj" notifications@github.com wrote:

I have the following code

$qb = $this->createQueryBuilder('cs')
->update()
->set('cs.is_active', 1)
->where('cs.reward_coupon = :reward_coupon')
->setMaxResults($limit)
->setParameter('reward_coupon', $rewardCoupon);
$qb->getQuery()->execute();

This doesn’t apply the LIMIT in the resultant query.

—
Reply to this email directly or view it on GitHub
#326.

[stof]

and this has nothing to do with DoctrineBundle. This issue tracker is not the issue tracker of the ORM

[deeky666]

Not sure if that works but you could try to solve this by using an EXISTS expression condition with a subquery that selects the limited resultset and then performing the UPDATE operation on that resultset.