[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1689) unexpected AST node: query -- CASE WHEN THEN subquery

[Alejandro T. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1689?page=comments#action_22826 ] 

Alejandro Torras commented on HHH-1689:
---------------------------------------

I think that a simple change in the grammar can fix the problem.

> unexpected AST node: query -- CASE WHEN THEN subquery
> -----------------------------------------------------
>
>          Key: HHH-1689
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1689
>      Project: Hibernate3
>         Type: Bug

>   Components: query-sql
>  Environment: Hibernate 3.x
> Oracle 9.2.0
>     Reporter: Alejandro Torras

>
> Original Estimate: 2 days, 4 hours
>         Remaining: 2 days, 4 hours
>
> Hello,
> I got a <<org.hibernate.hql.ast.QuerySyntaxError: unexpected AST node: query [ >> exception with the following query:
> FROM
> t1 AS vo, 
> t2 AS vo2
> WHERE vo2.indIdiomaSistema = 'S'
>  AND vo.id.codiIdioma.id = :id_codiIdioma_id 
>  GROUP BY vo.id.codiTipusIdent.id 
> 	HAVING COUNT(*) BETWEEN 
> 		CASE :estat 
> 		WHEN '1' THEN (SELECT COUNT(*) FROM t2 WHERE ind_idioma_sistema = 'S')
> 		ELSE 0 END 
> 	AND 4
>  ORDER BY vo.nomTipusIdent asc
> It seems that the THEN clause doesn't expect a query that Oracle 9.2 handles properly.
> Regards,
> Alejandro Torras.

-- 
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