Message:
The following issue has been closed.
Resolver: Gavin King
Date: Tue, 23 Sep 2003 9:46 AM
Please read the Hibernate documentation.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-350
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-350
Summary: Mysql dialect produced sql subquery.
Type: Bug
Status: Closed
Priority: Major
Resolution: REJECTED
Project: Hibernate2
Components:
core
Versions:
2.0.3
Assignee:
Reporter: Krzysztof Dabrowski
Created: Sun, 21 Sep 2003 9:43 AM
Updated: Tue, 23 Sep 2003 9:46 AM
Environment: Resin 2.1.10, Mysql 4.0.15 InnoDb
Description:
I've created the following hql query:
"from itm in class pl.elysium.boxlife.hibernate.Item where size(itm.ItemFolders)=0"
Ant this query produced the following SQL:
"select itm.itm_id as x0_0_ from item itm where ((select count(*) from item_itemfolder_binding itemfold0_ where itm.itm_id=itemfold0_.itm_id)=0 )"
As you probably now, MySQL does not have subselects so it producted the following error:
"ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select count(*) from item_itemfolder_binding itemfold0_ where i"
Shouldn't it rather use other methods to perform the size() in case of Mysql dialect?
---------------------------------------------------------------------
JIRA INFORMATION:
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
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
