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

MariaDB 10.1 with Spider

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.1.6, 10.0, 5.5
        • Fix Version/s: None
        • Component/s: Character Sets
        • Labels:
        • Environment:
          Centos 6.X

          Description

          installed MariaDB 10.1.6 with file_key_managment

          when I installed spider :

          most fine except this error :

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

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                Aurelien_LEQUOY Aurélien LEQUOY added a comment -

                got the same error, on a server stand alone

                Show
                Aurelien_LEQUOY Aurélien LEQUOY added a comment - got the same error, on a server stand alone
                Hide
                Permalink
                Aurelien_LEQUOY Aurélien LEQUOY added a comment - - edited

                due to my.cnf

                collation was specified in my.cnf
                [mysqld]
                collation_server = utf8_unicode_ci

                cluster control set this options by default, I replace it by general_ci and all work fine

                Show
                Aurelien_LEQUOY Aurélien LEQUOY added a comment - - edited due to my.cnf collation was specified in my.cnf [mysqld] collation_server = utf8_unicode_ci cluster control set this options by default, I replace it by general_ci and all work fine
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Before I close it as a configuration issue, I want to get a consult from Alexander Barkov, because I find the behavior rather confusing.
                It has nothing to do with Spider, the problem boils down to the following:

                # Server should be started with 
# --collation-server=utf8_unicode_ci --character-set-server=utf8

drop procedure if exists p1;

# This works
select count(*) from INFORMATION_SCHEMA.COLUMNS
  where COLUMN_NAME = 'server';

create procedure p1 (c char(255))
  select count(*) from INFORMATION_SCHEMA.COLUMNS
    where COLUMN_NAME = c;

# But this does not
call p1('server');

                So, when the server is started with such charset/collation, the comparison of the I_S column to a literal works okay as a plain SQL, but inside a procedure it fails. It's the same on earlier versions, both MariaDB and MySQL, but I'm not sure it's supposed to be so.

                Show
                elenst Elena Stepanova added a comment - Before I close it as a configuration issue, I want to get a consult from Alexander Barkov , because I find the behavior rather confusing. It has nothing to do with Spider, the problem boils down to the following: # Server should be started with # --collation-server=utf8_unicode_ci --character-set-server=utf8 drop procedure if exists p1; # This works select count(*) from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME = 'server'; create procedure p1 (c char(255)) select count(*) from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME = c; # But this does not call p1('server'); So, when the server is started with such charset/collation, the comparison of the I_S column to a literal works okay as a plain SQL, but inside a procedure it fails. It's the same on earlier versions, both MariaDB and MySQL, but I'm not sure it's supposed to be so.
                Hide
                Permalink
                Aurelien_LEQUOY Aurélien LEQUOY added a comment -

                it's strange :

                --collation-server=utf8_unicode_ci !
                because it failed with that and worked with general_ci

                Show
                Aurelien_LEQUOY Aurélien LEQUOY added a comment - it's strange : --collation-server=utf8_unicode_ci ! because it failed with that and worked with general_ci

                  People

                  • Assignee:
                    bar Alexander Barkov
                    Reporter:
                    Aurelien_LEQUOY Aurélien LEQUOY
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated: