Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-2451

Bad query generated when invoking KimRoleDaoOjb.getDelegationImplMapFromRoleIds

    Details

    • Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Critical Critical
    • Resolution: Complete
    • Affects Version/s: None
    • Fix Version/s: 1.0, KFS Release 3.0
    • Component/s: Development
    • Labels:
      None
    • Similar issues:
      KULRICE-11508Ajax field query enhancement on load
      KULRICE-9958Bad ids on subcollections
      KULRICE-7094DocumentSearchGeneratorImpl creates bad SQL when UI date format is changed
      KULRICE-1651When invoking ActionListImmediateEmailReminderService remotely, ActionItem.getRouteHeader is null
      KULRICE-7690Date Approved Workflow Preference can cause an excessive amount of sql queries
      KULRICE-6790ClassCastException when background KSB message processing invokes kimCacheAdminService (embedded mode)
      KULRICE-11712Suggest queries should be case insensitive
      KULRICE-3575when a new rule delegation is created, the document requeuer is never invoked
      KULRICE-11961Ajax field queries do not work
    • Rice Module:
      KIM

      Description

      In the case that the list of roleIds that are passed in are empty, the following sql is generated:

      SELECT A0.DLGN_ID,A0.ROLE_ID,A0.ACTV_IND,A0.KIM_TYP_ID,A0.DLGN_TYP_CD,A0.VER_NBR,A0.OBJ_ID FROM KRIM_DLGN_T A0 WHERE (A0.ROLE_ID IN ()) AND A0.ACTV_IND = ?

      This causes a confusing error from MySQL which is hard to figure out (makes it look like an issue with ACTV_IND instead).

      Not sure if this is something that needs to be handled but wanted to be sure I recorded it in case it does.

        Issue Links

          Activity

            People

            • Assignee:
              Jonathan Keller
              Reporter:
              Eric Westfall
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel