Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
4.0.1, 4.1.B1
-
None
Description
For query like this:
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);
We got prefetch query with wrong qualifier (main query is ok):
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 ?
Attachments
Issue Links
- links to