[Hibernate-issues] [Hibernate-JIRA] Created: (HB-350) Mysql dialect produced sql subquery.

[<leg...@at...>]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
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: Unassigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.3

   Assignee: 
   Reporter: Krzysztof Dabrowski

    Created: Sun, 21 Sep 2003 9:43 AM
    Updated: Sun, 21 Sep 2003 9:43 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