Sometimes, queries do not consider data due to incorrect core partition count being set during segment allocation in the same interval. This usually occurs when core partitions are dropped for an interval and data is appended in the presence of stale pending segment entries. https://github.com/apache/druid/pull/13070 attempts to fix it