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

'+test +10' doesn't match 'test 10'

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.1.23
    • 10.1(EOL)
    • Full-text Search
    • None
    • Debian

    Description

      Yes, 10 is shorter then min-token-size, but test is not. IMO it should use the index to find all rows matching test, fetch them and then check for 10.

      CREATE TABLE IF NOT EXISTS `test` (
      		 
        `f0` varchar(255) NOT NULL
      		 
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
      		 
       
      		 
      INSERT INTO `test` (`f0`) VALUES
      		 
      ('test 10');
      		 
       
      		 
      ALTER TABLE `test` ADD FULLTEXT KEY `f0` (`f0`);
      		 
       
      		 
      SELECT * FROM `test` WHERE match (f0) against ('+test +10' in boolean mode)

      Attachments

        Activity

          People

            Unassigned Unassigned
            XTF Olaf van der Spek
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.