Description Oliver Baum 2011-08-10 05:00:14 EDT

Build Identifier: 2.3.0

A concat function inside a sub select doesn't work in a query.

The query:

Query query = em.createQuery(
"select distinct v from Partnersuche v where v.partnerIndex  in 
(SELECT concat(p.pk.nebenPartnerNr, max(p.pk.paLfdAdressNr)) 
from PartnersucheV p where p.psPartnerartKey = 1 group by p.pk.nebenPartnerNr)"
);

ERROR:

java.lang.IllegalArgumentException: An exception occurred while creating a
query in EntityManager:
Exception Description: Syntax error parsing the query [select distinct v
from Partnersuche v where v.partnerIndex in (SELECT
concat(p.pk.nebenPartnerNr, max(p.pk.paLfdAdressNr)) from PartnersucheV p
where p.psPartnerartKey = 1 group by p.pk.nebenPartnerNr)], line 1, column
71: unexpected token [concat].
Internal Exception: NoViableAltException(16@[1292:16: ( DISTINCT )?])


I use JPA 2.0 and eclipselink 2.3 with a Oracle 11G database.

Thanks for help
Oliver

Reproducible: Always

Steps to Reproduce:
1. build a query with a concat function inside a sub select
2.
3.