cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <j...@apache.org>
Subject [jira] Created: (CAY-1348) Allow to-many relationships from non-pk columns
Date Thu, 24 Dec 2009 12:32:29 GMT
Allow to-many relationships from non-pk columns
-----------------------------------------------

                 Key: CAY-1348
                 URL: https://issues.apache.org/jira/browse/CAY-1348
             Project: Cayenne
          Issue Type: Improvement
          Components: Cayenne Core Library
    Affects Versions: 3.1M1
            Reporter: Andrus Adamchik
            Assignee: Andrus Adamchik
            Priority: Minor


This is something that came up in my work, and the feature is about allowing Cayenne to handle
some really loose schemas. Consider 2 tables:

t1 ( pk1, pk2, c1)
t2 ( pk, fk_c1, fk_pk2)

t1 has PK defined as (pk1,pk2), at the same time (pk2, c1) also uniquely identifies each row.
A relationship t2 join t1 on (t2.fk_c1 = t1.c1 and t2.fk_pk2 = t1.pk2) doesn't work. When
1..N part is resolved, a query like this is generated:

SELECT t2.* FROM t2 WHERE t2.fk_c1 = NULL AND t2.fk_pk2 = ? [bind: 1->fk_pk2:'correct_value']

This is not super high priority, but I think we should support such fuzzy relationships. Cayenne
traditionally had strong support for various legacy schemas. So we should support this case
as well.



-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message