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] Updated: (CAY-1069) EJBQL: support paths across flattened relationships
Date Fri, 05 Feb 2010 13:46:29 GMT

     [ https://issues.apache.org/jira/browse/CAY-1069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Andrus Adamchik updated CAY-1069:
---------------------------------

    Fix Version/s:     (was: 3.1M1)
                   3.0RC2

> EJBQL: support paths across flattened relationships
> ---------------------------------------------------
>
>                 Key: CAY-1069
>                 URL: https://issues.apache.org/jira/browse/CAY-1069
>             Project: Cayenne
>          Issue Type: Task
>          Components: Core Library
>    Affects Versions: 3.0RC2
>            Reporter: Andrus Adamchik
>            Assignee: Andrus Adamchik
>             Fix For: 3.0RC2
>
>         Attachments: 0001-Added-support-paths-across-flattened-attributes.patch, 0001-Fixed-errors-in-test-for-flattened-attributes.patch,
CAY-1069-flattened-relationships.patch
>
>
> Flattened relationships are not parsed properly by EJBQL yet. E.g.:
>   String ejbql = "SELECT f FROM FlattenedTest3 f, FlattenedTest1 ft "
>                 + "WHERE f MEMBER OF ft.ft3Array AND ft = :ft";
> SELECT t0.FT2_ID AS ec0_0, t0.NAME AS ec0_1, t0.FT3_ID AS ec0_2 
> FROM FLATTENED_TEST_3 t0, FLATTENED_TEST_1 t1 
> WHERE EXISTS (SELECT 1 FROM FLATTENED_TEST_3 t2 WHERE t2.FT1_ID = t1.FT1_ID AND t2.FT3_ID
= t0.FT3_ID) AND t1.FT1_ID = ? [bind: 1:1]
> 				
> 				java.sql.SQLException: Column not found: T2.FT1_ID in statement [SELECT t0.FT2_ID
AS ec0_0, t0.NAME AS ec0_1, t0.FT3_ID AS ec0_2 FROM FLATTENED_TEST_3 t0, FLATTENED_TEST_1
t1 WHERE EXISTS (SELECT 1 FROM FLATTENED_TEST_3 t2 WHERE t2.FT1_ID = t1.FT1_ID AND t2.FT3_ID
= t0.FT3_ID) AND t1.FT1_ID = ?]

-- 
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