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

add smart optimizer usage of full text index for like operator

    XMLWordPrintable

Details

    Description

      Add a variable like

      optimizer_convert_like_to ft

      with default = 0.

      If set to 1

      set optimizer_convert_like_to ft = 1

      1.
      Analyze, if query have conditions, which likely cause a full scan
      like

      tag LIKE '%aaaa%' OR LIKE '%bbbb%' 
      

      2
      Check, if the column has a full text index.

      If 1. + 2. true ,
      the query use full text index like "match against" syntax.

      This can improve application, where changing the queries is difficult like snow

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Richard Richard Stracke
              Votes:
              1 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.