Bugzilla – Full Text Bug Listing
| Summary: | Validation show problems with NamedQuery with subquery in where clause | ||
|---|---|---|---|
| Product: | [WebTools] Dali JPA Tools | Reporter: | Mariusz Tusiński <m.tusinski> |
| Component: | JPA | Assignee: | Pascal Filion <pascal.filion> |
| Status: | VERIFIED FIXED | QA Contact: | |
| Severity: | major | ||
| Priority: | P3 | CC: | jolene.moffitt, neil.hauge |
| Version: | unspecified | ||
| Target Milestone: | 3.0.1 | ||
| Hardware: | PC | ||
| OS: | Windows 7 | ||
| Whiteboard: | |||
| Bug Depends on: | 353142 | ||
| Bug Blocks: | |||
This was fixed in EclispeLink and the build has been updated to include this new build. Verified in Build I-3.4.0-20110822071621 Verified if you add a named queries which has a subquery in where clause no id variable errors appear. See the link to view test steps for verification. http://wiki.eclipse.org/Dali_3.0.1 |
Build Identifier: 20110615-0604 Validation tool shows problems in named queries which have subquery in where clause. Example: @Entity @Table(name="test_table") @NamedQuery(name = "TestEntity.testQuery", query = "select t from TestEntity t where t.id = (select max(tt.id) from TestEntity tt)") public class TestEntity { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name = "id", unique = true, nullable = false) private Integer id; @Column(name="name", length=255) private String name; } Validation tool shows following errors: Multiple markers at this line - The identification variable 't' is not defined in the FROM clause. - The identification variable 't' is not defined in the FROM clause. - The identification variable 'tt' is not defined in the FROM clause. Reproducible: Always Steps to Reproduce: 1.Create entity class 2.Add javax.persistence.NamedQuery annotation to class with select query having subquery in where clause