[KULRICE-2451] Bad query generated when invoking KimRoleDaoOjb.getDelegationImplMapFromRoleIds Created: 18/Nov/08  Updated: 17/Aug/09  Resolved: 04/Dec/08

Status: Closed
Project: Kuali Rice Development
Component/s: Development
Affects Version/s: None
Fix Version/s: 1.0, KFS Release 3.0

Type: Bug Fix Priority: Critical
Reporter: Eric Westfall Assignee: Jonathan Keller
Resolution: Complete Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates KFSOLD-17376 Bad query generated when invoking Kim... Closed
Fix
is fixed by KFSOLD-19293 Merge the Group Member / Role Member ... Closed
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.



 Comments   
Comment by Eric Westfall [ 18/Nov/08 ]

Ailish, if this is something which needs to be resolved, feel free to re-assign as needed.

Comment by Jonathan Keller [ 01/Dec/08 ]

I'm updating the role service to skip the call to the method if the role list is blank. This method is only called from 2 places and one already checks the list before passing it in.

Comment by Jonathan Keller [ 04/Dec/08 ]

This is now committed to Rice. (revision 5515) It will get pulled into the KFS KIM branch with any subsequent changes.

Comment by Eric Westfall [ 17/Aug/09 ]

Bulk change of all Rice 1.0 issues to closed after public release.

Generated at Fri Jul 10 21:43:41 CDT 2020 using JIRA 6.1.5#6160-sha1:a61a0fc278117a0da0ec9b89167b8f29b6afdab2.