Details
-
Type:
Bug
-
Status: Verified
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.7, 11.4
-
Fix Version/s: 11.5 [Tentative], 12.0
-
Component/s: Kernel
-
Labels:
-
11 status:Resolved
-
10 status:Please Merge
-
Previous Issue Keys:KNL-1475
Description
Site has two sections and 150+ groups. Using MySQL 5.6. The query observed returns 152 results.
The old getSelectRealmRoleGroupUserIdSql seems to use a sub-query for no apparent reason.
Attaching screenshots showing query performance with two separate MySQL 5.6 instances.