11:05 a.m.
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
11:12 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2045) in () result in "unexpected end of subtree"
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045?page=c...
]
Max Rydahl Andersen commented on HHH-2045:
------------------------------------------
this bug could also be changed to convert "x in ()" to either "in ()"
or "1=1" depending on dialect.
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
2:32 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2045) in () result in "unexpected end of subtree"
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045?page=c...
]
Steve Ebersole commented on HHH-2045:
-------------------------------------
So you just now realize that HQLTest.testEmptyInListFailureExpected() fails and what that
failure means? ;)
I thought there was already a JIRA case for this, but was just unable to find it. So
we'll leave this one as the official issue for that for now...
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
2:34 p.m.
New subject: [Hibernate-JIRA] Assigned: (HHH-2045) in () result in "unexpected end of subtree"
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045?page=all ]
Steve Ebersole reassigned HHH-2045:
-----------------------------------
Assign To: Steve Ebersole
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
Assignee: Steve Ebersole
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
2:38 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2045) in () result in "unexpected end of subtree"
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045?page=c...
]
Max Rydahl Andersen commented on HHH-2045:
------------------------------------------
i looked in the wrong testsuite - darn ;)
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
Assignee: Steve Ebersole
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
2:58 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2045) in () result in "unexpected end of subtree"
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045?page=c...
]
Josh Moore commented on HHH-2045:
---------------------------------
At least for Postgresql, Max, it's not valid :
omero3=# select * from project where id in ();
ERROR: syntax error at or near ")" at character 36
LINE 1: select * from project where id in ();
whereas:
omero3=# select * from project where id in (null);
id | owner_id | group_id | creation_id | update_id | permissions | version | name |
description
----+----------+----------+-------------+-----------+-------------+---------+------+-------------
(0 rows)
And, using Postgres, I've not been able to use the "in ()" construct, though
I can't remember the first version where I discovered that (could check subversion if
anyone's interested.) Never tried to do "in (null)", but a
q.setParameterList( "list", null ) certaily failed.
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
Assignee: Steve Ebersole
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
3:03 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2045) in () result in "unexpected end of subtree"
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045?page=c...
]
Steve Ebersole commented on HHH-2045:
-------------------------------------
I am not concerned about whether this construct works on particular databases. I am more
interested in getting it to parse correctly, which is the point of the test case.
As long as it parses fine and passes "... in ()..." along to the database, then
my work here is done...
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
Assignee: Steve Ebersole
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
3:03 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2045) in () result in "unexpected end of subtree"
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045?page=c...
]
Max Rydahl Andersen commented on HHH-2045:
------------------------------------------
well its valid ansi sql ;) (can't remember which db's supports it, but they are
out there)
and setParameterList("list", null) is wrong at the Hibernate API level, it
should be setParameterList("list", someEmptyCollection);
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate3
Type: Bug
Components: core
Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
Assignee: Steve Ebersole
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
3:05 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2045) in () result in "unexpected end of subtree"
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045?page=all ]
Steve Ebersole updated HHH-2045:
--------------------------------
Component: query-hql
(was: core)
Priority: Minor (was: Major)
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate3
Type: Bug
Components: query-hql
Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
Assignee: Steve Ebersole
Priority: Minor
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
7:45 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2045) in () result in "unexpected end of subtree"
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045?page=c...
]
Paul Benedict commented on HHH-2045:
------------------------------------
I just ran into this issue myself using Hibernate 3.1.1. An empty IN list should be
allowed.
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate Core
Issue Type: Bug
Components: query-hql
Affects Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
Assignee: Steve Ebersole
Priority: Minor
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:38 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2045) in () result in "unexpected end of subtree"
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045?page=c...
]
Tuukka Mustonen commented on HHH-2045:
--------------------------------------
Using Hibernate 3.4.0 GA for JPA and just got this issue. It sounds like a very common
case, yet I there are not too many comments here or Google hits for it.
How are you supposed to act with empty lists? Always build queries dynamically when there
is possibility for empty lists? That makes me really sad.
It sounds logical to have support for this in product: if list is empty, drop the clause
from query. But I guess that's forbidden in JPA spec and maybe in Hibernate world as
well?
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate Core
Issue Type: Bug
Components: query-hql
Affects Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
Assignee: Steve Ebersole
Priority: Minor
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:02 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2045) in () result in "unexpected end of subtree"
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045?page=c...
]
Paul Benedict commented on HHH-2045:
------------------------------------
My workaround is to provide a sentinel value that will never match. For example, -1 for a
primary key.
in () result in "unexpected end of subtree"
--------------------------------------------
Key: HHH-2045
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2045
Project: Hibernate Core
Issue Type: Bug
Components: query-hql
Affects Versions: 3.2.0.cr4
Reporter: Max Rydahl Andersen
Assignee: Steve Ebersole
Priority: Minor
"in ()" is a valid sql construct and works with previous versions of Hibernate.
The new parser throws an "unexpected end of subtree".
example:
from Animal an where an.id in ()
or
from Animal an where an.id in (:list)
and input list is an empty list.
Is this the behavior we want from now on or ?
--
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:21 a.m.
New subject: [Hibernate-JIRA] (HHH-2045) in () result in "unexpected end of subtree"
5:31 p.m.
New subject: [Hibernate-JIRA] (HHH-2045) in () result in "unexpected end of subtree"
3:25 p.m.
New subject: [Hibernate-JIRA] (HHH-2045) in () result in "unexpected end of subtree"
10:45 p.m.
New subject: [Hibernate-JIRA] (HHH-2045) in () result in "unexpected end of subtree"
11:26 p.m.
New subject: [Hibernate-JIRA] (HHH-2045) in () result in "unexpected end of subtree"
5:09 p.m.
New subject: [Hibernate-JIRA] (HHH-2045) in () result in "unexpected end of subtree"
1:14 p.m.
New subject: [Hibernate-JIRA] (HHH-2045) in () result in "unexpected end of subtree"
4055
days inactive
6440
days old
hibernate-issues@lists.jboss.org
18 comments
10 participants
participants (10)
-
Brett Meyer (JIRA) -
David Veldhuizen (JIRA)
-
Gareth Daniel Smith (JIRA)
-
Josh Moore (JIRA)
-
Lukasz Antoniak (JIRA)
-
Max Rydahl Andersen (JIRA)
-
Nick Upton (JIRA)
-
Paul Benedict (JIRA)
-
Steve Ebersole (JIRA)
-
Tuukka Mustonen (JIRA)