title: Grails Order By Not Working
body: <p>I have a Grails query that has an order by clause, but when the results come back they are not ordered by that field. If I run the same query in the database it works correctly. </p>
  
  <pre><code>String sql = "select child From Affiliation a join a.childrenPhases cp join cp.affiliation child where a = :affiliation and child.type = '${TYPE_CONFERENCE}' order by a.name asc"
          return  executeQuery(sql, [affiliation: this])
  </code></pre>
  
  <p><code>name</code> off of <code>a</code> is a hibernate formula field. Could this have to do with it?  Thanks.</p>