cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Trevor Higgins (JIRA)" <>
Subject [jira] [Created] (CAY-1979) Prefetches on Many-to-Many Relationships with Longvarchar
Date Fri, 12 Dec 2014 19:17:13 GMT
Trevor Higgins created CAY-1979:

             Summary: Prefetches on Many-to-Many Relationships with Longvarchar
                 Key: CAY-1979
             Project: Cayenne
          Issue Type: Bug
          Components: Core Library
    Affects Versions: 3.1
            Reporter: Trevor Higgins
            Priority: Critical

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

This message was sent by Atlassian JIRA

View raw message