How to fetch all rows for a single query?

[beat-x]

There is a global fetch limit in DBeaver which stops fetching data after a certain amount of rows (I think the default is 200). When I scroll down, the next 200 rows are fetched, and so on.

This is a great feature, but sometimes I want to fetch all rows at once (without using the export feature). How do I do that? I know of 2 methods, but I don't think they are particularly user-friendly:
1. Clear the "maximum result-set size" field in the toolbar, execute your query, then set the remembered value in the field again.
2. Go to the result table and keep pressing Ctrl+End (which always fetches 200 rows more) until all rows are fetched.

Is there a better way? If no, please consider adding one. A button in the bottom bar named "fetch all rows" would be enough.

[Serge]

Hello,

I agree that such feature could be useful. But I'm not sure that adding extra button in toolbar is the best solution. Data view toolbar already has too many actions. Adding extra button on each feature will overcomplicate it very fast.
Maybe some toggle key (ALT?) would be better. So CTRL+ALT+END (or ALT+click on "Last Row" button) will fetch and scroll resultset to the very end.
WDYT?

[beat-x]

You are right, maybe toggling an existing action would be the best solution. I like Ctrl+Alt+End. You could also (additionally) use Alt + "Refresh result set" button (this should be mentioned in the tooltip text tough). Another option would be the "Configure" popup menu, or the table context menu.