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

Extend Storage Engine API to include estimate of full-text search

Details

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

    Description

      When the optimizer looks for a best execution plan, it needs to know how many rows a particular condition can match. For historical reasons a full-text search query that uses a full-text index is always assumed to return 1 row.

      While it is kind of correct for a NL full-text search, it is definitely wrong for a boolean full-text search.

      For storage engines like Mroonga to be able to provide the optimizer with an estimate of the row count of a full-text search the Storage Engine API need to be updated with functions for the storage engines to provide the estimate.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-7250 MATCH...AGAINST is always estimated to return 1 row

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

          Activity

            Ascending order - Click to sort in descending order
            ratzpo Rasmus Johansson (Inactive) added a comment -

            serg can you verify the description and maybe specify a bit more in detail what needs to be done.

            ratzpo Rasmus Johansson (Inactive) added a comment - serg can you verify the description and maybe specify a bit more in detail what needs to be done.
            jswanhart Justin Swanhart (Inactive) added a comment -

            Perhaps an extensible index should be supported like pgsql has. Basically you can plug any kind of index you want into postgresql. I would like to be able to add bitmap and range indexes for example.

            jswanhart Justin Swanhart (Inactive) added a comment - Perhaps an extensible index should be supported like pgsql has. Basically you can plug any kind of index you want into postgresql. I would like to be able to add bitmap and range indexes for example.

            People

              Unassigned Unassigned
              ratzpo Rasmus Johansson (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.