Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-2553

Wrong disjoint prefetch query qualifier

    XMLWordPrintableJSON

    Details

    • 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
    • Labels:
      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

            Activity

              People

              • Assignee:
                aarrsseni Arseni Bulatski
                Reporter:
                ntimofeev Nikita Timofeev
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m