Details
-
Sub-Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
MXS-SPRINT-211, MXS-SPRINT-212, MXS-SPRINT-213
Description
By default, the number of returned rows is controlled by [sql_select_limit](https://mariadb.com/kb/en/query-limits-and-timeouts/#sql_select_limit), which is set to 10,000 in the GUI. However, if the user needs to retrieve all rows, the `sql_select_limit` should be ignored.
The following requirements must be met:
- There should be an option where the user can disable the usage of `sql_select_limit`.
- After logging out or refreshing the page (F5), `sql_select_limit` should automatically be re-enabled, using the default value 10000.
- The default value for LIMIT and OFFSET can only be changed permanently in the "Preferences" dialog. Values changes elsewhere will only be stored in memory.