commit fdbece1bac3d4d42d7ced45077c1301f03fba5e6
Author: Rodolfo Alonso Hernandez <email address hidden>
Date: Sun May 28 17:43:30 2023 +0200
Add a "GROUP BY" clause on queries with RBAC entries
As reported in the Neutron patch [1], this change introduce a
"GROUP BY" clause on the SQL queries with RBAC entries. With [1],
all resouces with RBAC entries ('network', 'qospolicy',
'securitygroup', 'addressscope', 'subnetpool', 'addressgroup') will
load the RBAC entries with "joined" strategy.
Because of the low cardinality of the RBAC query when all the RBAC
registers are in one single project, this patch groups the resource
queries by the resource ID. That will reduce the results returned by
the SQL engine to only the singular registers required.
Reviewed: https:/ /review. opendev. org/c/openstack /neutron- lib/+/885081 /opendev. org/openstack/ neutron- lib/commit/ fdbece1bac3d4d4 2d7ced45077c130 1f03fba5e6
Committed: https:/
Submitter: "Zuul (22348)"
Branch: stable/zed
commit fdbece1bac3d4d4 2d7ced45077c130 1f03fba5e6
Author: Rodolfo Alonso Hernandez <email address hidden>
Date: Sun May 28 17:43:30 2023 +0200
Add a "GROUP BY" clause on queries with RBAC entries
As reported in the Neutron patch [1], this change introduce a oup', 'addressscope', 'subnetpool', 'addressgroup') will
"GROUP BY" clause on the SQL queries with RBAC entries. With [1],
all resouces with RBAC entries ('network', 'qospolicy',
'securitygr
load the RBAC entries with "joined" strategy.
Because of the low cardinality of the RBAC query when all the RBAC
registers are in one single project, this patch groups the resource
queries by the resource ID. That will reduce the results returned by
the SQL engine to only the singular registers required.
[1]https:/ /review. opendev. org/c/openstack /neutron/ +/884877
Related-Bug: #1918145 ba93ab6252c77be 0a82f024055 d67bfd8a04c65f0 3be556eec8)
Change-Id: I800e0356714d59
(cherry picked from commit 829e97024c2b73d