[CAY-2553] Wrong disjoint prefetch query qualifier

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.1, 4.1.B1
• Fix Version/s: 4.0.2, 4.1.B2, 4.2.M1
• Component/s: Core Library
• Assignee: Arseni Bulatski
• Reporter: Nikita Timofeev
• Created: 12/Mar/19 13:50
• Updated: 11/Jun/19 12:32
• Resolved: 12/Apr/19 12:21

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 ? 

Issue Links

• links to: GitHub Pull Request #370