Mantis Bugtracker
  

Viewing Issue Advanced Details Jump to Notes ] View Simple ] Issue History ] Print ]
ID 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   OS
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[^]
Copyright © 2000 - 2005 Mantis Group
33 total queries executed.
28 unique queries executed.
Powered by Mantis Bugtracker