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

Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 10.7, 10.8
    • 10.11
    • None

    Description

      In the version 10.6 and later (possibly, after changes made in MDEV-8334) the test fails when it is run with view-protocol.

      Test (it is better to take test from attachment):

      SET NAMES latin1;
      CREATE TABLE t1 (
          id int unsigned NOT NULL auto_increment,
          list_id smallint unsigned NOT NULL,
          term text NOT NULL,
          PRIMARY KEY(id),
          INDEX(list_id, term(19))
      ) ENGINE=MyISAM CHARSET=utf8;
      INSERT INTO t1 set list_id = 1, term = "testétest";
      INSERT INTO t1 set list_id = 1, term = "testetest";
      INSERT INTO t1 set list_id = 1, term = "testètest";
      SELECT id, term FROM t1 where (list_id = 1) AND (term = "testétest");
      SELECT id, term FROM t1 where (list_id = 1) AND (term = "testetest");
      SELECT id, term FROM t1 where (list_id = 1) AND (term = "testètest");
      DROP TABLE t1;
      

      Error:

      mysqltest: At line 12: query 'SELECT id, term FROM t1 where (list_id = 1) AND (term = "test�test")' failed: ER_CANT_AGGREGATE_2COLLATIONS (1267): Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
      

      After fix this bug view-protocol should be enable in tests: main.ctype_utf8, main.ctype_utf8mb4_innodb, main.ctype_utf8mb4

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              lstartseva Lena Startseva
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.