1 Reply Latest reply on Apr 8, 2004 7:41 AM by Jacob Thompson

    Order By and JBOSS-QL

    Jacob Thompson Newbie

      I am using JBoss 3.2.2 and MySQL 4.0.18

      I I run this query
      SELECT OBJECT(o) from Table o WHERE o.blah.id = ?1 ORDER BY o.meef.foo.id

      It does not seem to joint correctly and generates a full cartesian product of the tables.

      However, if I do:
      SELECT OBJECT(o) from Table o WHERE o.blah.id = ?1 AND o.meef.ORDER BY o.meef.foo.id

      The query runs normally and returns the expected results.
      Has anyone else seen this behavior and if sho what have they done about it?

      Thanks,
      Jake T.