Details
-
Type:
Bug
-
Status: Verified
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 11.2
-
Fix Version/s: 12.0
-
Component/s: Forums Tool
-
Labels:
-
11 status:Please Merge
Description
Seen in production. Need MFR_PERMISSION_LEVEL_T with 900k+ rows. A lot of queries like this :
select straight_join count(*) as NBR from MFR_AREA_T area inner join MFR_OPEN_FORUM_T openforum on openforum.surrogateKey=area.ID inner join MFR_TOPIC_T topic on topic.of_surrogateKey=openforum.ID inner join MFR_MEMBERSHIP_ITEM_T membership on topic.ID=membership.t_surrogateKey, MFR_PERMISSION_LEVEL_T permission where area.CONTEXT_ID = 'ab6017e2-cd27-4e37-a0c4-22d38e1c7d32' and topic.MODERATED = true and (membership.NAME in ( 'Student', 'XXXXXXXXXXXXX.499.01.Sp17' ) and permission.MODERATE_POSTINGS = true and permission.TYPE_UUID <> '5927e5d7-355c-4d7e-b7b5-e4e8cd1e32ac' and permission.NAME=membership.PERMISSION_LEVEL_NAME)