[hibernate-issues] [Hibernate-JIRA] Commented: (ANN-647) @Where JavaDoc does not specify that it describes a SQL fragment
Geoffrey De Smet (JIRA)
noreply at atlassian.com
Wed Aug 8 12:13:13 EDT 2007
[ http://opensource.atlassian.com/projects/hibernate/browse/ANN-647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_27777 ]
Geoffrey De Smet commented on ANN-647:
--------------------------------------
"cool = true" works on MySQL (I tried with the mysql query browser.
However it doesn't work in @Where, as "true" gets wrongly prefixed with "projectpo1_."
Apprently the following are escaped from being prefixed:
- string literals, for example 'hello'
- numbers: for example 123
But these are missing:
- keywords: true, false
> @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 :)
--
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list