Wrong Spira behaviour for indent Relaeses.

Let's imagine that I have hierarchy in releases (moreover, Spira supports it).

When I select a Relaese in the filter on a list-view of releases  not always it will show all of the children. It looks like, it will show only one or two levels under it. So, we may miss some of the requirements or incidents if they are deep in the hierarchy.

I have played with the custom reports to investigate what was wrong, looks like a mistake is also there.

If I run

select ${ReleaseId} as RRelease, R.RELEASE_ID, R.INDENT_LEVEL from SpiraTestEntities.R_Releases as R where R.PROJECT_ID = ${ProjectId} 

I get many records including next

<ROW>

<RELEASE_ID>2392</RELEASE_ID>

<INDENT_LEVEL>AABAAI</INDENT_LEVEL>

</ROW>

<ROW>

<RELEASE_ID>2393</RELEASE_ID>

<INDENT_LEVEL>AABAAIAAAAAA</INDENT_LEVEL>

</ROW>

<ROW>

<RELEASE_ID>2394</RELEASE_ID>

<INDENT_LEVEL>AABAAIAAAAAB</INDENT_LEVEL>

</ROW>

<ROW>

<RELEASE_ID>2395</RELEASE_ID>

<INDENT_LEVEL>AABAAIAAAAAC</INDENT_LEVEL>

</ROW>

<ROW>

<RELEASE_ID>2454</RELEASE_ID>

<INDENT_LEVEL>AABAAIAAAAAD</INDENT_LEVEL>

</ROW>

, so it assures me that RELEASE_ID=2392 has many children.

But if I run

select ${ReleaseId} as RRelease, R.RELEASE_ID, R.INDENT_LEVEL from SpiraTestEntities.R_Releases as R where R.PROJECT_ID = ${ProjectId} and R.RELEASE_ID in {${ReleaseAndChildIds}}

With selected release = 2392, I get only itself while expected behavior is to  get also it's children

<RESULTS>

<ROW>

<RRelease>2392</RRelease>

<RELEASE_ID>2392</RELEASE_ID>

<INDENT_LEVEL>AABAAI</INDENT_LEVEL>

</ROW>

</RESULTS>