Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3952 Auto-inject `LIMIT` and `OFFSET`, and allow no limit
  3. MXS-5157

Inject "LIMIT" and "OFFSET" to each statement

Details

    • Sub-Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 24.08.0
    • maxgui
    • None
    • MXS-SPRINT-211, MXS-SPRINT-212, MXS-SPRINT-213

    Description

      All SQL statements must be split and injected with `LIMIT` and `OFFSET` clauses.
      The value of the `LIMIT` will be the value of `sql_select_limit`.

      Attachments

        Issue Links

          relates to

          Sub-Task - The sub-task of the issue MXS-5156 Split statements

          • Major - Major loss of function.
          • Closed

          Activity

            thien.ly Thien Ly added a comment -

            The [sql-limiter](https://github.com/sqlpad/sql-limiter) library will be used for splitting statements. However, it won't support store procedures or functions, so the SQL text editor can't be used for creating those. There should be a separated interface for the users to create store procedures and functions.

            thien.ly Thien Ly added a comment - The [sql-limiter] ( https://github.com/sqlpad/sql-limiter ) library will be used for splitting statements. However, it won't support store procedures or functions, so the SQL text editor can't be used for creating those. There should be a separated interface for the users to create store procedures and functions.

            People

              thien.ly Thien Ly
              thien.ly Thien Ly
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.