The denormalised table is populated with all nodes: it should contains node from the space store only
The current population of the denormalised table will insert all the nodes of alf_node. These may include nodes that are not part of the SpaceStore (i.e. nodes from the VersionStore) that are normally excluded in the query.
Two items of work:
1. verify that the current query, when hitting the denorm, will exclude the non-SpaceStore nodes
2. change the population so that only nodes from the SpaceStore are included
Adina has done specific tests to reproduce the issue, if needed.
As per the first point: when querying for nodes the default store used is the SpacesStore. So because of that nodes in other stores are not displayed in the results, although it is possible to specify what store to use for the query if you wish to view nodes in different stores such as the archive store for instance.