[OJB] Issue #OJB173 - IN() Clause optimisation broken on 1:1 relationships when SQ...

[carl boyes <ca...@dla.com>]

You can view the issue detail at the following URL:
<http://scarab.werken.com/scarab/issues/id/OJB173>

Type :        Defect
Issue Id :    OJB173
Reported by: carl boyes
             carlboyes - (carl.boyes@dla.com)

Details:

Platform: All
Operating system: windows 2000
Summary: IN() Clause optimisation broken on 1:1 relationships when SQL IN limit used
Description: RelationshipPrefetcherImpl.prefetchRelationship() forces all relationships to be retrieved, irrelevent of the fact that only the first sql - IN clause limit sql has been executed.

Status: New
Priority: Medium

Re: [OJB] Issue #OJB173 - IN() Clause optimisation broken on 1:1 relationships when SQ...

[Jakob Braeuchi <jb...@gmx.ch>]

hi carl,

could you please explain a little bit in more detail ?

jakob

carl boyes wrote:

>You can view the issue detail at the following URL:
><http://scarab.werken.com/scarab/issues/id/OJB173>
>
>Type :        Defect
>Issue Id :    OJB173
>Reported by: carl boyes
>             carlboyes - (carl.boyes@dla.com)
>
>Details:
>
>Platform: All
>Operating system: windows 2000
>Summary: IN() Clause optimisation broken on 1:1 relationships when SQL IN limit used
>Description: RelationshipPrefetcherImpl.prefetchRelationship() forces all relationships to be retrieved, irrelevent of the fact that only the first sql - IN clause limit sql has been executed.
>
>Status: New
>Priority: Medium
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
>For additional commands, e-mail: ojb-dev-help@db.apache.org
>
>
>  
>