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

            Assignee:
            jacob-mathew Jacob Mathew (Inactive)
            Reporter:
            GeoffMontee Geoff Montee
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: