2 Replies Latest reply on Aug 12, 2004 6:52 AM by aloubyansky

    bug in EJBQLToSQL92Compiler

    jbeyer

      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