[jira] Created: (CAY-1069) EJBQL: support paths across flattened relationships

From: Andrus Adamchik (JIRA) ("Andrus)
Date: Mon Jun 09 2008 - 04:55:52 EDT

  • Next message: Andrey Razumovsky (JIRA): "[jira] Updated: (CAY-888) CM Usability: Object Select Query Improvements"

    EJBQL: support paths across flattened relationships
    ---------------------------------------------------

                     Key: CAY-1069
                     URL: https://issues.apache.org/cayenne/browse/CAY-1069
                 Project: Cayenne
              Issue Type: Task
              Components: Cayenne Core Library
        Affects Versions: 3.0
                Reporter: Andrus Adamchik
                Assignee: Andrus Adamchik
                 Fix For: 3.0

    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.

    This archive was generated by hypermail 2.0.0 : Mon Jun 09 2008 - 04:56:29 EDT