[Pulsar Sql] The number of query result records of pulsar SQL is less than that sent by producer

**Describe the bug**
Pulsar version 2.6.2

The number of query result records of pulsar SQL is less than that sent by producer.
1、Producer sends 7 records；
2、Pulsar SQL only queries 4 records；
sql: select * from XXX;

3、Topic has no subscription；

Start by reproducing the reported Pulsar 2.6.2 flow: send 7 records, confirm the topic has no subscription, and run `select * from XXX;` through Pulsar SQL. Compare the producer count with the 4 returned records and use the issue's screenshots and comment history to identify the missing-record conditions; done means the cause is isolated and a regression test or verified fix covers the case.

Written by the indexing model from the issue text.