[CAY-1979] Prefetches on Many-to-Many Relationships with Longvarchar

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 3.1
• Fix Version/s: 4.0.M2, 3.1.1
• Component/s: Core Library
• Assignee: Andrus Adamchik
• Reporter: Trevor Higgins
• Created: 12/Dec/14 19:16
• Updated: 23/Dec/14 13:45
• Resolved: 23/Dec/14 13:45

Description

Discovered when performing a prefetch on a many-to-many relationship involving a jump table, but may affect a varietey of prefetches.

(Note: this is a 'disjoint' prefetch, as selected by Cayenne not by the calling code)
When performing a prefetch SelectAction.performAction checks 'translator.isSuppressingDistinct()' and if so wraps the resultset iterator in a DistinctResultIterator.

The problem arises because when the unsupported distinct type is detected in the target table SelectTranslator sets 'suppressingDistinct' to true and DistinctResultIterator does NOT use full row comparisons (alternatively it could also use the PKs from both sides of the arc but that currently isn't implemented).

This causes only the first row that a foreign pk appears in to be used and the rest discarded, resulting in some to most of the relationships not being represented in the object model.

Expected behavior is for all arcs to show up in the object model regardless of the column types.