0001214: Amber: implement the "join" spec in the "from" clause

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001214

[Resin]

minor

always

06-25-06 10:20

08-31-06 13:39

Reporter

anonymous

View Status

public

Assigned To

Priority

normal

Resolution

fixed

Status

closed

Product Version

3.0.19

Summary

0001214: Amber: implement the "join" spec in the "from" clause

Description

Here is the error generated by Resin:

expected end of query at 'from'
in "select distinct o from SectorBean o join o.suscripcionList s where s.tipo = ?1"

Resin-3.0.19 (built Mon, 15 May 2006 04:50:47 PDT)

workaround: the above query can be rewrite as "select distinct o from SectorBean o where o.suscripcionList.tipo = ?1"

Note: the "join" keyword combined with "fetch" is very useful to manage detached objects.

Additional Information

Attached Files

Relationships

Notes
(0001306) fbertra 06-25-06 18:55	Reported by me (Francois Bertrand)

(0001486) westrupp 08-31-06 11:53	It is implemented and tested in jpa/1143. (Rodrigo Westrupp)

(0001487) westrupp 08-31-06 13:39	Implemented and tested (jpa/1143). (Rodrigo Westrupp)

Issue History
Date Modified	Username	Field	Change
06-25-06 10:20	anonymous	New Issue
06-25-06 18:55	fbertra	Note Added: 0001306
08-31-06 11:53	westrupp	Note Added: 0001486
08-31-06 13:39	westrupp	Status	new => closed
08-31-06 13:39	westrupp	Note Added: 0001487
08-31-06 13:39	westrupp	Resolution	open => fixed
08-31-06 13:39	westrupp	Fixed in Version	=> 3.1.0

Mantis 1.0.0rc3[^]

33 total queries executed.
28 unique queries executed.