cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nikita Timofeev (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CAY-2389) DbEntity qualifier with DbPath expression translates into wrong SQL
Date Wed, 13 Dec 2017 14:10:00 GMT
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)

Mime
View raw message