Invalid SQL: missing join and column ------------------------------------ Key: HHH-3363 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3363 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.3.0.CR1, 3.2.6 Environment: hsqldb Reporter: Istvan Kovacs Using the same sources as in HHH-3362 select p.name, s.name, s.stock[p] from Shop s, Product p This produces SQL that does not contain the stock column, and does not join tables PRODUCT and SHOP via SHOP_PRODUCT_STOCK: select product1_.name as col_0_0_, shop0_.name as col_1_0_ from Shop shop0_, PRODUCT product1_ In another query, the join is performed when stock[p] is referenced: select emp.name, shop.name from Employee emp join emp.shop as shop, Product p where shop.stock[p] > 5 and p.name='Product_10' SQL: select employee0_.name as col_0_0_, shop1_.name as col_1_0_ from Employee employee0_ inner join Shop shop1_ on employee0_.SHOP_ID=shop1_.SHOP_ID, PRODUCT product2_, SHOP_PRODUCT_STOCK stock3_ where shop1_.SHOP_ID=stock3_.SHOP_ID and stock3_.PRODUCT_ID = product2_.PRODUCT_ID and stock3_.AMOUNT>5 and product2_.name='Product_10' -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira