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

match results in DOUBLE value is out of range in

    XMLWordPrintable

Details

    Description

      Same behavior is on this versions: 10.3.28, 10.4.17, 10.5.12

      How to reproduce the crash:

      CREATE TABLE `d_fulltext_phrase` (
        `id` int(11) NOT NULL,
        `phrase` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:string)'
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
       
      INSERT INTO `d_fulltext_phrase` (`id`, `phrase`) VALUES
      (1, 'audi');
       
      ALTER TABLE `d_fulltext_phrase`
        ADD PRIMARY KEY (`id`);
      ALTER TABLE `d_fulltext_phrase` ADD FULLTEXT KEY `IDX_E4E8EE24A24BE60C` (`phrase`);
       
      ALTER TABLE `d_fulltext_phrase`
        MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
      

      and than run:

      SELECT phrase, (MATCH (phrase) AGAINST ('aud*' IN BOOLEAN MODE)) + 0
      FROM d_fulltext_phrase
      

      while this runs ok:

      SELECT phrase, (MATCH (phrase) AGAINST ('aud*' IN BOOLEAN MODE)) 
      FROM d_fulltext_phrase
      

      Attachments

        Activity

          People

            marko Marko Mäkelä
            forgie Ján Forgáč
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.