Result set fetching of a query fetches usually the whole result set as incremental fetching does not allow intermediate command execution on the same connection. Working with huge result sets requires either plenty of memory on the client side or multiple queries using paging (LIMIT/OFFSET).

However processing the resultset while running other queries is a common case that could be extended: Streaming of huge result sets by keeping the connection (and its transactional state) in a usable state for other queries.

It's my first ticket for MariaDB. Please point me to the appropriate resource in case this is not the right forum for this discussion to take place.