I think that in data view, the behavior of paging should not change the limit amount of other behaviors #2290
Description
Description
When using "next" to load the next page of data in data view, if you adjust the sorting rules or filter fields, the default limit should be used instead of the total number of pages after loading data with the "next" button. This will cause the loading to be very slow and does not meet expectations
I couldn't find a way to reset this value. If an incorrect operation occurs, I can only restart the software to reset it
HeidiSQL version
12.12.0.7145
Database server version
mysql 8.0.41
Reproduction recipe
For example, in step 3/4/5 in the image above, "limit 2000" should be the default "limit 1000". This is just because flipping one page made the total number of records 2000. If you flip more pages or use "show all", these operations with the incorrect limit value will be even slower