CQL AND clause is behaving like an OR clause

Issue Summary

When using CQL to make searches on Confluence and using an AND clause, the behavior we see in the results is of an OR clause, with content that shouldn't be showing up there.

This is reproducible on Data Center: yes

Steps to Reproduce

1. Create two different spaces in Confluence;
2. In space A, create a parent page and a child page;
3. Add some text you want to search in the child page of space A;
4. In space B, create a page with the same text added to the child page of space A;
5. Retrieve the page id of the parent page of space A;
6. Run the following CQL search in Confluence:

   ancestorIds = parent-page-id and text ~ text-of-child-page"
   

Expected Results

The results of the search will be all child content of the page mentioned in the ancestorIds and that have the text within them;

Actual Results

Besides the child pages with the text in them, we also see the parent page (which doesn't have the text searched in it) and the page of another space (which has the text searched in it, but is not a child of the parent page);

Workaround

Currently, there is no known workaround for this behavior. A workaround will be added here when available