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

Wrong disjoint prefetch query qualifier

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 4.0.1, 4.1.B1
    • 4.0.2, 4.1.B2, 4.2.M1
    • Core Library
    • 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

              aarrsseni Arseni Bulatski
              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