Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7010

Docs: KB page suggests wrong syntax for per-query MAX_STATEMENT_TIME

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: N/A
        • Fix Version/s: N/A
        • Component/s: Documentation
        • Labels:

          Description

          https://mariadb.com/kb/en/mariadb/documentation/optimization-and-tuning/query-optimizations/aborting-statements-that-exceed-than-a-certain-time-to-execute/

          It says:

          Individual queries can also be limited by adding a MAX_STATEMENT_TIME clause to the query. For example:

          SELECT MAX_STATEMENT_TIME=2 * FROM t1;

          It's not the right syntax, apparently it's supposed to be
          SET STATEMENT MAX_STATEMENT_TIME=2 FOR SELECT * FROM t1

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                greenman Ian Gilfillan added a comment -

                Yes, it seems this was not implemented in this way for 10.1.1. The suggested syntax doesn't work either, I will remove the reference from the docs until it's implemented or there's clarity on how it's supposed to work.

                Show
                greenman Ian Gilfillan added a comment - Yes, it seems this was not implemented in this way for 10.1.1. The suggested syntax doesn't work either, I will remove the reference from the docs until it's implemented or there's clarity on how it's supposed to work.
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                This is a new syntax expected to appear in 10.1.2 (it's in a separate tree so far). MDEV-5231.

                Show
                elenst Elena Stepanova added a comment - This is a new syntax expected to appear in 10.1.2 (it's in a separate tree so far). MDEV-5231 .
                Hide
                Permalink
                greenman Ian Gilfillan added a comment -

                Documentation updated. Will add the 10.1.2 syntax when it is released.

                Show
                greenman Ian Gilfillan added a comment - Documentation updated. Will add the 10.1.2 syntax when it is released.

                  People

                  • Assignee:
                    greenman Ian Gilfillan
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: