| I'd say related to however they both seem to be issues with the dialect and how it formats the SQL. Incidently, this issues arrises using it on paged data. If you do the old trick of
outer.setFirstResult(((page - 1) * pageSize) + 1)
Then it does appear to work. It's like the first time it runs it doesn't get the paged items |