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.
Sorry did not wat to come up right, here it is again
SELECT OBJECT(o) from Table o WHERE o.blah.id = ?1 AND o.meef.id < > -1 ORDER BY o.meef.foo.id