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

Illegal mix of collations (cp1251_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 'between'

    XMLWordPrintable

Details

    Description

      Run test with view-protocol:

      SET CHARACTER SET koi8r;
       
      set names koi8r;
      create table t1 (c1 char(10) character set cp1251);
      insert into t1 values ('ß');
      select c1 from t1 where c1 between 'ß' and 'ß';
      drop table t1;
      

      Error:

      mysqltest: At line 6: query 'select c1 from t1 where c1 between 'ß' and 'ß'' failed: 1270: Illegal mix of collations (cp1251_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 'between'
      

      May be the same with MDEV-27904

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              lstartseva Lena Startseva
              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.