Description Guy Pelletier 2011-05-16 10:53:38 EDT

Background: Bug 337323

The following query:

TypedQuery<MafiaFamily> q = em.createQuery("SELECT m FROM MafiaFamily m ORDER BY m.id DESC", MafiaFamily.class);
q.setHint(QueryHints.FETCH, "m.mafiosos");
q.getResultList();

Executed against the testing model from background bug fails with:

nternal Exception: java.sql.SQLException: ORA-00904: "JPA_MAFIOSO"."TENANT_ID": invalid identifier

Error Code: 904
Call: SELECT t5.ID, t5.TENANT_ID, t6.ID, t5.NAME, t6.REVENUE, t0.ID, t0.DTYPE, t0.TENANT_ID, t0.FIRSTNAME, t0.GENDER, t0.LASTNAME, t0.FAMILY_ID, t1.ID, t1.UNDERBOSS_ID, t2.ID, t3.ID, t3.UNDERBOSS_ID, t4.ID, t4.CAPO_ID FROM JPA_MAFIOSO t0 LEFT OUTER JOIN JPA_BOSS t1 ON (t1.ID = t0.ID) LEFT OUTER JOIN JPA_UNDERBOSS t2 ON (t2.ID = t0.ID) LEFT OUTER JOIN JPA_CAPO t3 ON (t3.ID = t0.ID) LEFT OUTER JOIN JPA_SOLDIER t4 ON (t4.ID = t0.ID), JPA_FAMILY_REVENUE t6, JPA_MAFIA_FAMILY t5 WHERE (((t6.ID = t5.ID) AND (t5.TENANT_ID = ?)) AND ((t0.FAMILY_ID = t5.ID) AND (t0.TENANT_ID = JPA_MAFIOSO.TENANT_ID))) ORDER BY t5.ID DESC
	bind => [1 parameter bound]
Query: ReadAllQuery(referenceClass=MafiaFamily sql="SELECT t5.ID, t5.TENANT_ID, t6.ID, t5.NAME, t6.REVENUE, t0.ID, t0.DTYPE, t0.TENANT_ID, t0.FIRSTNAME, t0.GENDER, t0.LASTNAME, t0.FAMILY_ID, t1.ID, t1.UNDERBOSS_ID, t2.ID, t3.ID, t3.UNDERBOSS_ID, t4.ID, t4.CAPO_ID FROM JPA_MAFIOSO t0 LEFT OUTER JOIN JPA_BOSS t1 ON (t1.ID = t0.ID) LEFT OUTER JOIN JPA_UNDERBOSS t2 ON (t2.ID = t0.ID) LEFT OUTER JOIN JPA_CAPO t3 ON (t3.ID = t0.ID) LEFT OUTER JOIN JPA_SOLDIER t4 ON (t4.ID = t0.ID), JPA_FAMILY_REVENUE t6, JPA_MAFIA_FAMILY t5 WHERE (((t6.ID = t5.ID) AND (t5.TENANT_ID = ?)) AND ((t0.FAMILY_ID = t5.ID) AND (t0.TENANT_ID = JPA_MAFIOSO.TENANT_ID))) ORDER BY t5.ID DESC")