Bulk rejecting stale issues. If this is still a legitimate issue on ORM 4, feel free to comment and attach a test case. I'll address responses case-by-case. Thanks!

In an effort to clean up, in bulk, tickets that are most likely out of date, we're transitioning all ORM 3 tickets to an "Awaiting Test Case" state. Please see http://in.relation.to/Bloggers/HibernateORMJIRAPoliciesAndCleanUpTactics for more information.

If this is still a legitimate bug in ORM 4, please provide either a test case that reproduces it or enough detail (entities, mappings, snippets, etc.) to show that it still fails on 4. If nothing is received within 3 months or so, we'll be automatically closing them.

Thank you!

HQL:

13:34:03,477 DEBUG QueryTranslatorImpl:241 - HQL: SELECT r FROM org.hibernate.test.joinedmapfilter.Toplevel AS r WHERE r.toplevelId=? AND r.productDetail.attributes[?]=?

SQL (written out nicer) :

13:34:03,478 DEBUG QueryTranslatorImpl:242 - SQL:
select
toplevel0_.toplevel_id as toplevel1_0_,
toplevel0_.long_value_one as long2_0_,
toplevel0_.product_detail_id as product3_0_,
toplevel0_.description as descript4_0_
from
toplevel toplevel0_,
/////////////// MISSING TABLE NOT EMITTED BY HIB "product_detail productdet1_, " ///////////////
product_detail_attrs attributes2_
where
toplevel0_.product_detail_id=productdet1_.product_detail_id
and productdet1_.product_detail_id=attributes2_.product_detail_id
and attributes2_.name = ?
and toplevel0_.toplevel_id=?
and attributes2_.value=?

I inserted the missing: "product_detail productdet1_" in the FROM clause. That missing table is the reason for this bug report (just in case it hasn't been obvious so far).

Attached is a logging output of testcase here are the notable entries.

13:34:02,609 DEBUG DotNode:591 - getDataType() : productDetail -> org.hibernate.type.ManyToOneType(org.hibernate.test.joinedmapfilter.ProductDetail)
13:34:02,610 DEBUG DotNode:390 - dereferenceEntityJoin() : generating join for productDetail in org.hibernate.test.joinedmapfilter.Toplevel {no alias} parent = [ ( . ( . toplevel0_.toplevel_id productDetail ) attributes ) ]
13:34:02,616 DEBUG FromElement:131 - FromClause{level=1} : org.hibernate.test.joinedmapfilter.ProductDetail (no alias) -> productdet1_
13:34:02,617 DEBUG FromClause:257 - addJoinByPathMap() : r.productDetail -> product_detail productdet1_
13:34:02,618 DEBUG FromReferenceNode:74 - Resolved : r.productDetail -> toplevel0_.product_detail_id

Notice here the 2nd FROM_FRAGMENT of ImpliedFromElement with '' as the getText(). This should be 'product_detail productdet1_' you can see it knows the tableName and tableAlias but the getText() is blank.

13:34:02,680 DEBUG AST:258 - — SQL AST —
-[SELECT] QueryNode: 'SELECT' querySpaces (product_detail_attrs,toplevel,product_detail)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'

There is also ./core/src/main/java/org/hibernate/hql/ast/SqlGenerator.java around line 249. I guess my missing table in the FROM clause is one of these "ghosts".

///////////////////////////////////////////////////////////////////////
// HACK ALERT !!!!!!!!!!!!!!!!!!!!!!!!!!!!
// Attempt to work around "ghost" ImpliedFromElements that occasionally
// show up between the actual things being joined. This consistently
// occurs from index nodes (at least against many-to-many). Not sure
// if there are other conditions
//
// Essentially, look-ahead to the next FromElement that actually
// writes something to the SQL
while ( right != null && !hasText( right ) ) {
right = ( FromElement ) right.getNextSibling();
}
if ( right == null ) {
return;
}
///////////////////////////////////////////////////////////////////////

Logging output of testcase.