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

Split statements

Details

    • Sub-Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • N/A
    • 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-5157 Inject "LIMIT" and "OFFSET" to each statement

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            thien.ly Thien Ly added a comment -

            The [sql-limiter](https://github.com/sqlpad/sql-limiter) library will be used for injecting limit and offset values. However, the library needs to be extended to support injecting offset.
            Below is the PR, if it takes to long for the project maintainer to response or approve the PR. The fork version can be used for maxgui.
            https://github.com/sqlpad/sql-limiter/pull/26

            thien.ly Thien Ly added a comment - The [sql-limiter] ( https://github.com/sqlpad/sql-limiter ) library will be used for injecting limit and offset values. However, the library needs to be extended to support injecting offset. Below is the PR, if it takes to long for the project maintainer to response or approve the PR. The fork version can be used for maxgui. https://github.com/sqlpad/sql-limiter/pull/26
            thien.ly Thien Ly added a comment -

            Merge with MXS-5157 since sql-delimiter splits statements before inserting LIMIT.

            thien.ly Thien Ly added a comment - Merge with MXS-5157 since sql-delimiter splits statements before inserting LIMIT.

            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.