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

Analyze table on sequences should be prohibited

Details

    Description

      A sequence table has always only on row.
      It is pointless to do ANALYZE TABLE to collect statistics on it (The main usable value is always out of date).

      The task is to have 'analyze table' on sequences 'do nothing' and we should not try to fetch persistent index or column statistics for sequences.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          monty Michael Widenius created issue -
          monty Michael Widenius made changes -
          Field Original Value New Value
          Assignee Michael Widenius [ monty ]
          monty Michael Widenius made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 11.5 [ 29506 ]
          Fix Version/s 11.5.1 [ 29634 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 11.6 [ 29515 ]
          Fix Version/s 11.5 [ 29506 ]
          julien.fritsch Julien Fritsch made changes -
          Due Date 2024-04-18
          serg Sergei Golubchik made changes -
          Fix Version/s 11.5.1 [ 29634 ]
          Fix Version/s 11.6 [ 29515 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]

          People

            monty Michael Widenius
            monty Michael Widenius
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.