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

remove limitations from I_S streaming optimization

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 13.2
    • None
    • Information Schema
    • None

    Description

      MDEV-31342 implemented a streaming optimization for information_schema tables.

      It's currently subject to many restrictions, some of them are inherently incompatible with streaming, others were artificially introduced to simplify the original implementation.

      This task is to remove those artificial limitations, such as

      • UNION ALL
      • HAVING (w/o ORDER BY or GROUP BY)
      • SELECT *
      • constants, expressions, or function calls in the SELECT clause
      • ANALYZE SELECT
      • SELECT ... INTO
      • stored functions
      • LIMIT / OFFSET
      • SQL_CALC_FOUND_ROWS
      • ROWNUM() — MDEV-41171
      • LIMIT ROWS EXAMINED ­— MDEV-41171
      • MAX_STATEMENT_TIME — MDEV-41165

      may be I'm wrong and some of these limitations are indeed inherent and cannot be lifted

      Attachments

        Issue Links

          Activity

            People

              janlindstrom Jan Lindström
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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