I installed the 5.0 tarball and started building a site map. I have a package that I mount many subsites on and there appears to be a change in subsite in 5.0 that only allows mounting subsites directly on other subsite packages. In the after mount callback there is a query that finds the subsite group and constrains the new subsite to only allow members that are in the parent subsite.
select m.group_id as supersite_group_id, p.instance_name as supersite_name
from application_groups m, apm_packages p, site_nodes s1, site_nodes s2
where s1.node_id = :node_id
and s2.node_id = s1.parent_id
and p.package_id = s2.object_id
and m.package_id = s2.object_id
Since this query only looks at the parent node it does not return a row if the parent is not a subsite. Is this change intentional or should the query find the closest subsite?