Subselect throws Unexpected End of Subtree

Description

I feel the following queries, which are valid SQL should be valid HQL.

SELECT (SELECT 1)
SELECT (SELECT 1), (SELECT 2)

But instead they throw:

3157 [main] ERROR org.hibernate.hql.PARSER - <AST>:0:0: unexpected end of subtree

Thanks.

Environment

Running against HSQLDB 2.0.1-rc3

Activity

Show:
Amir Pashazadeh
March 17, 2012, 1:09 AM

I'm not sure whether HQL should support any possible SQL or not. This is not my case, but there were some other SQL queries which I wished HQL would support too.

Thomas Hehl
March 17, 2012, 2:52 AM

What I'm really doing is doing subselects and returning an array of counts. I feel it's important that HQL support this.

Brett Meyer
October 14, 2013, 4:02 PM

These types of discussions are best started at Hibernate's user forums: https://forum.hibernate.org/viewforum.php?f=1. Please open JIRA tickets only for concise, reproduceable issues with an attached test case. Thanks!

Assignee

Unassigned

Reporter

Thomas Hehl

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure