Duplicate InvestigationInstruments returned

[GoogleCodeExporter]

When using the query below on ICAT 4.3 I got the strange side effect that in 
the results I had two InvestigationInstruments returned despite the fact I only 
had on Instrument linked to each Investigation. The first was the same 
InvestigationInstrument object as the second but without the Instrument 
attached. I resolved the problem by removing "inv.investigationInstruments" 
from the query but I believe ICAT should have dealt with this for me. 

List<Object> invObjs = icatEP.search(sessionId, "SELECT inv FROM Investigation 
inv WHERE inv.name='Temp_TA2' INCLUDE inv.facility, inv.type, 
inv.investigationInstruments, inv.investigationInstruments.instrument");

Original issue reported on code.google.com by kevin.ph...@googlemail.com on 29 Aug 2014 at 3:39

[GoogleCodeExporter]

Reproduced by test

Original comment by dr.s.m.f...@gmail.com on 18 Sep 2014 at 11:41

• Changed state: Started

[GoogleCodeExporter]

This will now return an error message: INCLUDE clause contains redundant path 
to investigationInstruments. I considered making it silently remove the 
redundant path but don't think it is worth the extra code.

Original comment by dr.s.m.f...@gmail.com on 18 Sep 2014 at 12:45

• Changed state: CheckedIn

[GoogleCodeExporter]

Original comment by dr.s.m.f...@gmail.com on 18 Sep 2014 at 12:46

• Added labels: Milestone-4.4

[GoogleCodeExporter]

All these are now released

Original comment by dr.s.m.f...@gmail.com on 9 Dec 2014 at 1:54

• Changed state: Fixed