You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@cayenne.apache.org by "Nikita Timofeev (JIRA)" <ji...@apache.org> on 2017/12/13 14:10:00 UTC

[jira] [Created] (CAY-2389) DbEntity qualifier with DbPath expression translates into wrong SQL

Nikita Timofeev created CAY-2389:
------------------------------------

             Summary: DbEntity qualifier with DbPath expression translates into wrong SQL
                 Key: CAY-2389
                 URL: https://issues.apache.org/jira/browse/CAY-2389
             Project: Cayenne
          Issue Type: Bug
    Affects Versions: 4.1.M1, 4.0.B2, 3.1.1
            Reporter: Nikita Timofeev
            Priority: Minor


When qualifier with {{DbPath}} expression attached to {{DbEntity}} (e.g. programmatically set {{ExpressionFactory.matchDbExpression()}} qualifier) used in JOIN clause, it generates wrong SQL.

For example: {{JOIN GROUP t2 ON (t1.GROUPID = t2.GROUPID AND t0.DELETED = 0)}}
Note {{t0}} alias used with DELETED field, {{t2}} should be used instead.

Everything works fine if {{ObjPath}} used in qualifier.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)