[hibernate-issues] [Hibernate-JIRA] Commented: (ANN-647) @Where JavaDoc does not specify that it describes a SQL fragment

From a user's perspective, it would very usefull if HQL/JPA-QL was allowed in @Where and @OrderBy too.

@Where JavaDoc does not specify that it describes a SQL fragment ---------------------------------------------------------------- Key: ANN-647 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-647 Project: Hibernate Annotations Issue Type: Bug Components: documentation Affects Versions: 3.3.0.ga Environment: Mysql 5 Reporter: Geoffrey De Smet Priority: Minor Fix For: 3.3.1 The problem is that the "true" gets prefixed with the tablename: For example this is an annotated class @ManyToMany(targetEntity = ProjectPO.class, mappedBy="coolholders") @Where(clause = " cool = 'true' ") public List<Project> getInCoolProjects() Here's the generated SQL: ... where ( projectpo1_.cool = projectpo1_.true ) ... while it should probably be: ... where ( projectpo1_.cool = true ) ... PS: it's a bit unclear if @Where(clause) accepts SQL or HQL. If it's only SQL, allowing HQL too would be useful :)