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] [Commented] (CAY-2389) DbEntity qualifier with DbPath expression translates into wrong SQL
Date Wed, 13 Dec 2017 14:40:00 GMT

    [ https://issues.apache.org/jira/browse/CAY-2389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16289340#comment-16289340
] 

Nikita Timofeev commented on CAY-2389:
--------------------------------------

*4.1* https://github.com/apache/cayenne/commit/41dd56c5af47c9d9afb8e259727dfaf4dd9a6cca

> 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: 3.1.1, 4.0.B2, 4.1.M1
>            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