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

Add support for Indexes on Expressions

    XMLWordPrintable

Details

    Description

      An index on expression means something like

      CREATE TABLE t1 (a int, b int, INDEX (a/2+b));
      		 
      ...
      		 
      SELECT * FROM t1 WHERE a/2+b=100;

      in this case the optimizer should be able to use an index.

      This task naturally splits in two steps:

      1. add expression matching into the optimizer, use it for generated columns. Like in
        CREATE TABLE t1 (a int, b int, c INT GENERATED ALWAYS AS (a/2+b), INDEX (c));
      2. support the syntax to create an index on expression directly, this will automatically create a hidden generated column under the hood

      original task description is visible in the history

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-4414 INDEX - SUBSTRING, LEFT and others string functions that could be optimized with index

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-4430 INDEX Optimization - Virtual Column, Dynamic Column and Index optimization

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MXS-3624 Use indexed virtual columns if such exist

          • Major - Major loss of function.
          • Open
          duplicates

          Task - A task that needs to be done. MDEV-17993 WHERE F(X) = constY should used F(X) generated index and query WHERE G=constY

          • Major - Major loss of function.
          • Closed
          includes

          Task - A task that needs to be done. MDEV-5631 Implement Reverse Key Index

          • Major - Major loss of function.
          • Closed
          is blocked by

          Task - A task that needs to be done. MDEV-5800 indexes on virtual (not materialized) columns

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

              serg Sergei Golubchik
              fale Fabio Alessandro Locati
              Votes:
              20 Vote for this issue
              Watchers:
              27 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.