Bug appears in JBoss 3.2.5:
When I create a dynamic query, using EJBQLToSQL92Compiler as the QL copmiler, the LIMIT part of my clause is ignored. The same query works fine with JDBCEJBQLCompiler.
Query is as follows:
SELECT OBJECT(c) FROM BusinessType AS bt, IN( bt.customers ) AS c WHERE bt.name='School' AND c.ownerID.personID=1 ORDER BY c.name OFFSET 0 LIMIT 10
Does anybody see any problem with my query, or is this a bug?
Cheers,
Jon