Advanced Append Subquery Joins + Row Limits
My understanding is that basic subqueries do not respect row limits on reports in order to make sure there is a match for the join i.e. the results of the subquery are not limited
However we have seen that in advanced subqueries with a view based on a different datasource, this is not the case. I can imagine that since the application fires off a separate query that it might treat it as another report/master level query and hence the limit the result before joining the 2 result sets together in memory.
Just wondering if this is intended behaviour or perhaps a bug?