I disagree with you when you say that if I want to fetch b.a.id it should not create any joins. It is the same type of thing as trying to fetch b.a.description. If you wanted to fetch just the id, then you do not try to access the joined table. You simple access the column on table B. b.a_id. Why would you need to access the id column on table A when it is the same as the a_id column on table B?
I understand that some of the other frameworks may not join the tables for this query but I think they are just over compensating for developer sloppiness. Personally, I do not see a bug in OpenJPA for this query. I think the query needs to be reworked. Would the developers of OpenJPA confirm/deny this? Once again this is my opinion. -- View this message in context: http://openjpa.208410.n2.nabble.com/Unnecesery-INNER-JOIN-tp5297321p5329587.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
