[BUG] CLI yields wrong results on a query

Tái hiện vấn đề bằng lệnh curl và truy vấn SQL được cung cấp, sau đó so sánh đầu ra dạng dọc với đầu ra dạng bảng trong lần chạy thứ hai. Kiểm tra cli.log, curl.log, bản dump mạng và thông tin chi tiết về môi trường được đính kèm, đặc biệt là các thiết lập LESS. Được xem là hoàn tất khi truy vấn lặp lại hiển thị cùng 10 dòng mà không có dòng trống hoặc kết quả cũ.

What is the bug?
opensearchsqlcli tool yields wrong results for a query. Perhaps, it shows results from a previous query.

How can one reproduce the bug?

1. Load this data using curl:

curl -s -XPOST localhost:9200/_bulk -H 'Content-Type: application/x-ndjson' --data-binary @beer.stackexchange3.txt

beer.stackexchange3.txt

2. Run query

select * from beer.stackexchange where Tags like '% % %' and Title like '%' LIMIT 10;

3. Type y to see results vertically
   OK there are 10 entries
4. Run the same query and hit Enter to see the results table
   There are 25 lines !
   Pay attention to mismatch on the first row and on the row count. There is no row wrap.

      1 fetched rows / total rows = 10/10
      2 +------------+-------------------------+----------------------+---------------------------------------------------------------------------------------+-------------+------->
      3 | ParentId   | CreationDate            | CommunityOwnedDate   | Title                                                                                 | ViewCount   | LastEd>
      4 |------------+-------------------------+----------------------+---------------------------------------------------------------------------------------+-------------+------->
      5 | null       | 2014-01-21 20:37:12.143 | null                 | What is the difference between an ale and a lager?                                    | 40787       | null  >
      6 | null       | 2014-01-21 20:45:28.747 | null                 | Why doesn't bottled beer taste as good as draught beer?                               | 3867        | null  >
      7 |            |                         |                      |                                                                                       |             |       >
      8 |            |                         |                      |                                                                                       |             |       >
      9 |            |                         |                      |                                                                                       |             |       >
     10 |            |                         |                      |                                                                                       |             |       >
     11 | null       | 2014-01-21 20:48:46.88  | null                 | Can one pilsener cause a hangover when another doesn't?                               | 875         | null  >
     12 |            |                         |                      |                                                                                       |             |       >
     13 |            |                         |                      |                                                                                       |             |       >
     14 | null       | 2014-01-21 20:50:01.62  | null                 | Do different beer glass shapes really make a difference in taste?                     | 5270        | null  >
     15 |            |                         |                      |                                                                                       |             |       >
     16 |            |                         |                      |                                                                                       |             |       >
     17 | null       | 2014-01-21 20:59:16.81  | null                 | How can I prolong the life of beer in a growler?                                      | 996         | 73    >
     18 | null       | 2014-01-21 21:00:23.103 | null                 | What's the difference between a porter and a stout?                                   | 2887        | 73    >
     19 |            |                         |                      |                                                                                       |             |       >
     20 |            |                         |                      |                                                                                       |             |       >
     21 | null       | 2014-01-21 21:05:17.293 | null                 | Why is it called "porter"?                                                            | 764         | 407   >
     22 | null       | 2014-01-21 21:17:49.747 | null                 | How much of an impact does the water have on a beer?                                  | 1870        | 52    >
     23 | null       | 2014-01-21 21:22:24.927 | null                 | Why does Guinness have a special pouring process / bottle, while other stouts do not? | 1804        | null  >
     24 | null       | 2014-01-21 21:55:27.83  | null                 | Where can I buy Czech beers in Bavaria?                                               | 86          | 43    >
     25 |            |                         |                      |                                                                                       |             |       >
     26 |            |                         |                      |                                                                                       |             |       >
     27 |            |                         |                      |                                                                                       |             |       >
     28 |            |                         |                      |                                                                                       |             |       >
     29 +------------+-------------------------+----------------------+---------------------------------------------------------------------------------------+-------------+------->
(END)

What is the expected behavior?
A clear and concise description of what you expected to happen.

What is your host/environment?
Server: OpenSearch 2.0.0-rc1-SNAPSHOT
CLI Version: 1.0.0
OS: WSL 2.0 on Win 11
Python: 3.8.10
env vars: env.txt
The most interesting i guess are:

LESS=-RSNF
LESSOPEN='|~/.lessfilter %s'

Additional information
Process core dump:
cli_full.zip
Network traffic dump:
dump.zip
CLI log:
cli.log
CURL returns valid output:
curl.log

Note: I didn't execute a query that returns 25 lines.