various actor.* functions should be marked stable

Bug #1823390 reported by Galen Charlton
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
New
Undecided
Unassigned

Bug Description

The following functions in the actor schema are currently marked volatile but should be marked stable:

 actor.org_unit_descendants(int)
 actor.org_unit_descendants(int, int)
 actor.org_unit_ancestors(int)

Doing so will allow the query planner to make better decisions about using the results of those functions inside of a query. In particular, initial results show that marking actor.org_unit_descendants(int) stable can improve the speed of the patron search query.

Evergreen master

Tags: patron search
tags: added: patr
tags: added: patron search
removed: patr
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.