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

install_spider.sql can fail with some collations

    XMLWordPrintable

Details

    Description

      install_spider.sql can fail with the following error:

      ERROR 1267 (HY000) at line 288 in file: '/usr/share/mysql/install_spider.sql': Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

      To reproduce, simply do:

      SET NAMES utf8;
      		 
      SET SESSION collation_server=utf8_unicode_ci;
      		 
      source /usr/share/mysql/install_spider.sql

      Attachments

        Activity

          People

            jacob-mathew Jacob Mathew (Inactive)
            GeoffMontee Geoff Montee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.