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

Wrong disjoint prefetch query qualifier

Agile BoardRank to TopRank to BottomAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          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

              Slack

                Issue deployment