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 2019/03/12 13:51:00 UTC
[jira] [Created] (CAY-2553) Wrong disjoint prefetch query qualifier
Nikita Timofeev created CAY-2553:
------------------------------------
Summary: 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
Fix For: 4.0.2, 4.1.B2, 4.2.M1
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)