You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Ksenia Khailenko (JIRA)" <ji...@apache.org> on 2010/01/11 15:50:54 UTC
[jira] Updated: (CAY-1069) EJBQL: support paths across flattened
relationships
[ https://issues.apache.org/jira/browse/CAY-1069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ksenia Khailenko updated CAY-1069:
----------------------------------
Attachment: CAY-1069-flattened-relationships.patch
> 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.0
> Reporter: Andrus Adamchik
> Assignee: Andrus Adamchik
> Fix For: Short term future
>
> Attachments: 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.