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

Cannot use a table containing special chars for InnoDB stopwords

    XMLWordPrintable

Details

    Description

      The statement below fails because the new table contains a special char (dash):

      MariaDB [eshop]> CREATE TABLE `stop_it-IT` ENGINE = InnoDB SELECT * FROM information_schema.INNODB_FT_DEFAULT_STOPWORD;
      		 
      Query OK, 36 rows affected (0.53 sec)
      		 
      Records: 36  Duplicates: 0  Warnings: 0
      		 
      MariaDB [eshop]> SET @@global.innodb_ft_server_stopword_table = 'eshop/stop_it-IT';
      		 
      ERROR 1231 (42000): Variable 'innodb_ft_server_stopword_table' can't be set to the value of 'eshop/stop_it-IT'

      Without special char, it works:

      MariaDB [eshop]> CREATE TABLE stop_it ENGINE = InnoDB SELECT * FROM information_schema.INNODB_FT_DEFAULT_STOPWORD;
      		 
      Query OK, 36 rows affected (0.51 sec)
      		 
      Records: 36  Duplicates: 0  Warnings: 0
      		 
      MariaDB [eshop]> SET @@global.innodb_ft_server_stopword_table = 'eshop/stop_it';
      		 
      Query OK, 0 rows affected (0.00 sec)

      Sorry, I didn't try on MySQL because I currently don't have it installed on development.

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            f_razzoli Federico Razzoli
            Votes:
            0 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.