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

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ 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

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.1.0

Product Version

3.0.19

Product Build

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.

Steps To Reproduce

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.