You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Arseni Bulatski (JIRA)" <ji...@apache.org> on 2019/04/12 12:22:00 UTC
[jira] [Closed] (CAY-2553) Wrong disjoint prefetch query qualifier
[ https://issues.apache.org/jira/browse/CAY-2553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arseni Bulatski closed CAY-2553.
--------------------------------
Resolution: Fixed
> Wrong disjoint prefetch query qualifier
> ---------------------------------------
>
> Key: CAY-2553
> URL: https://issues.apache.org/jira/browse/CAY-2553
> Project: Cayenne
> Issue Type: Bug
> Components: Core Library
> Affects Versions: 4.0.1, 4.1.B1
> Reporter: Nikita Timofeev
> Assignee: Arseni Bulatski
> Priority: Major
> Fix For: 4.0.2, 4.1.B2, 4.2.M1
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> For query like this:
> {code}
> List<Painting> result = ObjectSelect.query(Painting.class)
> .where(Painting.TO_ARTIST
> .dot(Artist.PAINTING_ARRAY)
> .dot(Painting.PAINTING_TITLE).like("p1%"))
> .and(Painting.PAINTING_TITLE.like("p2%"))
> .prefetch(Painting.TO_ARTIST.disjoint())
> .select(context);
> {code}
> We got prefetch query with wrong qualifier (main query is ok):
> {code}
> SELECT
> DISTINCT RTRIM(t0.ARTIST_NAME), t0.DATE_OF_BIRTH, t0.ARTIST_ID
> FROM
> ARTIST t0
> JOIN PAINTING t1 ON t0.ARTIST_ID = t1.ARTIST_ID
> WHERE
> t1.PAINTING_TITLE LIKE ? AND t1.PAINTING_TITLE LIKE ?
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)