title: How to make LIMIT work in Grails HQL executeUpdate()?
body: <p>I'm running grails 1.3.6 and I have this code:</p>
  
  <pre><code>String hql = '''
      UPDATE
          ApiResponse a
      SET
          a.lockId = :lockId
      WHERE
          a.lockId = 0
      ORDER BY
          a.dateAdded asc
      LIMIT 5
      '''
  ApiResponse.executeUpdate(hql, [lockId : workerId])
  </code></pre>
  
  <p>It seems that this code updates all rows in DB instead of the 5 oldest entries. Does this mean LIMIT is not working in HQL? Please help me how to achieve the same SQL logic in GORM or HQL. Basically, I need to do a bulk update using LIMIT.</p>