[Bug] select full table without group by and order by，query use large memory，be memory exceed limit

[lipenghao1216]

Search before asking

• I had searched in the issues and found no similar issues.

Version

2.0.2

What's Wrong?

i have a unique model table, 600w rows,when i use select * from table limit 7000000, query failed caused by memory exceed limit; use mem_tracker can see query use large memory

my be server still have 3g available memory
i think a sql without group by order by .. just scan full table data should not use too many memory, because be need not to load all data into memory from disk ，then send to client

my table ddl and query profile
profile_1705491397004.txt
ddl.txt

What You Expected?

select * from table can execute successfully without using large memory

How to Reproduce?

be without rich available memory, like 3g
table uncompressed data size exceed 3g
select * from table

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[lipenghao1216]