[BUG] CLI yields wrong results on a query

[Yury-Fridlyand]

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.