Scott Marlow commented on Bug HHH-7928

In case its helpful, I'm pasting the SQL that gets executed for the TCK test part (after setup is complete).

17:42:34,697 DEBUG [org.hibernate.SQL] (EJB default - 1) select customer0_.ID as ID20_, customer0_.code as code20_, customer0_.country as country20_, customer0_.FK6_FOR_CUSTOMER_TABLE as FK5_20_, customer0_.NAME as NAME20_, customer0_.FK5_FOR_CUSTOMER_TABLE as FK6_20_ from CUSTOMER_TABLE customer0_ inner join FKS_ALIAS_CUSTOMER aliases1_ on customer0_.ID=aliases1_.FK_FOR_CUSTOMER_TABLE inner join ALIAS_TABLE alias2_ on aliases1_.FK_FOR_ALIAS_TABLE=alias2_.ID where alias2_.ALIAS=? fetch first 20 rows only

17:42:34,708 DEBUG [org.hibernate.SQL] (EJB default - 1) select address0_.ID as ID1_0_, address0_.CITY as CITY1_0_, address0_.STATE as STATE1_0_, address0_.STREET as STREET1_0_, address0_.ZIP as ZIP1_0_ from ADDRESS address0_ where address0_.ID=?

17:42:34,712 DEBUG [org.hibernate.SQL] (EJB default - 1) select address0_.ID as ID1_0_, address0_.CITY as CITY1_0_, address0_.STATE as STATE1_0_, address0_.STREET as STREET1_0_, address0_.ZIP as ZIP1_0_ from ADDRESS address0_ where address0_.ID=?

17:42:34,713 DEBUG [org.hibernate.SQL] (EJB default - 1) select spouse0_.ID as ID61_4_, spouse0_.FK7_FOR_CUSTOMER_TABLE as FK6_61_4_, spouse0_.FIRSTNAME as FIRSTNAME61_4_, spouse0_.FK_FOR_INFO_TABLE as FK7_61_4_, spouse0_.LASTNAME as LASTNAME61_4_, spouse0_.MAIDENNAME as MAIDENNAME61_4_, spouse0_.SOCSECNUM as SOCSECNUM61_4_, customer1_.ID as ID20_0_, customer1_.code as code20_0_, customer1_.country as country20_0_, customer1_.FK6_FOR_CUSTOMER_TABLE as FK5_20_0_, customer1_.NAME as NAME20_0_, customer1_.FK5_FOR_CUSTOMER_TABLE as FK6_20_0_, address2_.ID as ID1_1_, address2_.CITY as CITY1_1_, address2_.STATE as STATE1_1_, address2_.STREET as STREET1_1_, address2_.ZIP as ZIP1_1_, address3_.ID as ID1_2_, address3_.CITY as CITY1_2_, address3_.STATE as STATE1_2_, address3_.STREET as STREET1_2_, address3_.ZIP as ZIP1_2_, info4_.ID as ID41_3_, info4_.INFOCITY as INFOCITY41_3_, info4_.INFOSTATE as INFOSTATE41_3_, info4_.INFOSTREET as INFOSTREET41_3_, info4_.INFOZIP as INFOZIP41_3_ from SPOUSE_TABLE spouse0_ left outer join CUSTOMER_TABLE customer1_ on spouse0_.FK7_FOR_CUSTOMER_TABLE=customer1_.ID left outer join ADDRESS address2_ on customer1_.FK6_FOR_CUSTOMER_TABLE=address2_.ID left outer join ADDRESS address3_ on customer1_.FK5_FOR_CUSTOMER_TABLE=address3_.ID left outer join INFO_TABLE info4_ on spouse0_.FK_FOR_INFO_TABLE=info4_.ID where spouse0_.FK7_FOR_CUSTOMER_TABLE=?

17:42:34,714 DEBUG [org.hibernate.SQL] (EJB default - 1) select address0_.ID as ID1_0_, address0_.CITY as CITY1_0_, address0_.STATE as STATE1_0_, address0_.STREET as STREET1_0_, address0_.ZIP as ZIP1_0_ from ADDRESS address0_ where address0_.ID=?

17:42:34,715 DEBUG [org.hibernate.SQL] (EJB default - 1) select address0_.ID as ID1_0_, address0_.CITY as CITY1_0_, address0_.STATE as STATE1_0_, address0_.STREET as STREET1_0_, address0_.ZIP as ZIP1_0_ from ADDRESS address0_ where address0_.ID=?

17:42:34,716 DEBUG [org.hibernate.SQL] (EJB default - 1) select spouse0_.ID as ID61_4_, spouse0_.FK7_FOR_CUSTOMER_TABLE as FK6_61_4_, spouse0_.FIRSTNAME as FIRSTNAME61_4_, spouse0_.FK_FOR_INFO_TABLE as FK7_61_4_, spouse0_.LASTNAME as LASTNAME61_4_, spouse0_.MAIDENNAME as MAIDENNAME61_4_, spouse0_.SOCSECNUM as SOCSECNUM61_4_, customer1_.ID as ID20_0_, customer1_.code as code20_0_, customer1_.country as country20_0_, customer1_.FK6_FOR_CUSTOMER_TABLE as FK5_20_0_, customer1_.NAME as NAME20_0_, customer1_.FK5_FOR_CUSTOMER_TABLE as FK6_20_0_, address2_.ID as ID1_1_, address2_.CITY as CITY1_1_, address2_.STATE as STATE1_1_, address2_.STREET as STREET1_1_, address2_.ZIP as ZIP1_1_, address3_.ID as ID1_2_, address3_.CITY as CITY1_2_, address3_.STATE as STATE1_2_, address3_.STREET as STREET1_2_, address3_.ZIP as ZIP1_2_, info4_.ID as ID41_3_, info4_.INFOCITY as INFOCITY41_3_, info4_.INFOSTATE as INFOSTATE41_3_, info4_.INFOSTREET as INFOSTREET41_3_, info4_.INFOZIP as INFOZIP41_3_ from SPOUSE_TABLE spouse0_ left outer join CUSTOMER_TABLE customer1_ on spouse0_.FK7_FOR_CUSTOMER_TABLE=customer1_.ID left outer join ADDRESS address2_ on customer1_.FK6_FOR_CUSTOMER_TABLE=address2_.ID left outer join ADDRESS address3_ on customer1_.FK5_FOR_CUSTOMER_TABLE=address3_.ID left outer join INFO_TABLE info4_ on spouse0_.FK_FOR_INFO_TABLE=info4_.ID where spouse0_.FK7_FOR_CUSTOMER_TABLE=?

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira