[OPENJPA-658] select count(o) in subquery or not exists subquery generates SQL with syntax error

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Catalina Wei
• Created: 14/Jul/08 04:02
• Updated: 18/Aug/12 08:51

Description

Table aliase resolution is still a problem in the following JPQL queries when query contains subqueries using select count(o) or not exists:

1. "select o from Order o where o.amount > (select count(o) from Order o)",
"select o from Order o where o.amount > (select count(o2) from Order o2)",
2. "select c from Customer c left join c.orders p where not exists"
+ " (select o2 from c.orders o2 where o2 = o",

the generated incorrect SQL has an empty FROM body, for example:
{SELECT t0.oid, t0.amount .. FROM WHERE ( t0.amount > (select count(....

Issue Links

• relates to: OPENJPA-2251 EXISTS with subquery from superclass generates SQL with syntax error