-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 4.0.1, 4.1.B1
-
Component/s: Core Library
-
Labels:None
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 ?
- links to