Uploaded image for project: 'MidPoint'
  1. MidPoint
  2. MID-5815

Validity scanner goes through users only

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Reviewed
    • Affects Version/s: None
    • Fix Version/s: 4.1
    • Component/s: Model
    • Labels:
    • Subscription:
      Active subscription

      Description

      Validity scanner goes probaly only through users and it's doing full table scan, which takes forever to execute

      SELECT ruser0_.oid AS col_0_0, ruser0_2_.fullObject AS col_1_0
      FROM m_user ruser0
               INNER JOIN m_focus ruser0_1 ON ruser0_.oid = ruser0_1_.oid
               INNER JOIN m_object ruser0_2 ON ruser0_.oid = ruser0_2_.oid
               LEFT OUTER JOIN m_assignment assignment1
      ON ruser0_.oid = assignment1_.owner_oid AND (assignment1_.assignmentOwner = :1)
      WHERE
            ruser0_1_.validFrom > :2  AND ruser0_1_.validFrom<=:3  OR ruser0_1_.validTo>:4  AND
            ruser0_1_.validTo<=:5  OR assignment1_.validFrom>:6  AND assignment1_.validFrom<=:7  OR assignment1_.validTo>:8  AND assignment1_.validTo<=:9
      ORDER BY NLSSORT(ruser0_.oid, 'NLS_SORT=BINARY_AI') ASC FETCH FIRST :10 ROWS ONLY
      
      
      SELECT count(ruser0_.oid) AS col_0_0
      FROM m_user ruser0
               INNER JOIN m_focus ruser0_1 ON ruser0_.oid = ruser0_1_.oid
               INNER JOIN m_object ruser0_2 ON ruser0_.oid = ruser0_2_.oid
               LEFT OUTER JOIN m_assignment assignment1_
      ON ruser0_.oid = assignment1_.owner_oid AND (assignment1_.assignmentOwner = :1)
      WHERE
            ruser0_1_.validFrom > :2  AND ruser0_1_.validFrom<=:3  OR ruser0_1_.validTo>:4  AND
            ruser0_1_.validTo<=:5  OR assignment1_.validFrom>:6  AND assignment1_.validFrom<=:7  OR assignment1_.validTo>:8  AND assignment1_.validTo<=:9 

        Attachments

          Activity

            People

            Assignee:
            mederly Pavol Mederly
            Reporter:
            lazyman Viliam Repan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: