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

Make ICP work with non-persistent virtual columns

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Optimizer
    • None

    Description

      It should be possible to use Index Condition Pushdown on non-stored virtual columns. The column value is part of the index, so it's possible to unpack it back to the table record and evaluate the ICP condition.

      However mysql-5.7 doesn't do that:
      https://gist.github.com/spetrunia/e00cd6503fa96f3565f0f6aaf46926ac

      We (MariaDB) are about to inherit this property when we backport indexed virtual columns from MySQL.

      This task is about lifiting this limitation.

      Attachments

        Activity

          People

            Unassigned Unassigned
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.