Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-6003 Check columnstore against 11.8
  3. MCOL-6027

11.8 Failed Columnstore MTRs: "Illegal mix of collations"

    XMLWordPrintable

Details

    • Sub-Task
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Tests
    • None
    • 2025-5, 2025-6, 2025-7, 2025-8

    Description

      columnstore/basic.ctype_cmp_char1_latin1_swedish_ci
      columnstore/basic.ctype_cmp_char4_latin1_swedish_ci
      columnstore/basic.ctype_cmp_char5_latin1_swedish_ci
      columnstore/basic.ctype_cmp_varchar32_latin1_bin
      columnstore/basic.ctype_cmp_varchar32_latin1_nopad_bin
      columnstore/basic.ctype_cmp_varchar32_latin1_swedish_ci
      columnstore/basic.ctype_cmp_varchar32_latin1_swedish_nopad_ci
      columnstore/basic.ctype_cmp_varchar32_utf8_bin
      columnstore/basic.ctype_cmp_varchar32_utf8_general_ci
      columnstore/basic.ctype_cmp_varchar32_utf8_general_nopad_ci
      columnstore/basic.ctype_cmp_varchar32_utf8_nopad_bin
      columnstore/basic.ctype_cmp_varchar32_utf8_unicode_ci
      columnstore/basic.ctype_cmp_varchar32_utf8_unicode_nopad_ci
      columnstore/basic.ctype_cmp_varchar4_latin1_bin
      columnstore/basic.ctype_cmp_varchar4_latin1_nopad_bin
      columnstore/basic.ctype_cmp_varchar4_latin1_swedish_ci
      columnstore/basic.ctype_cmp_varchar4_latin1_swedish_nopad_ci
      columnstore/basic.ctype_cmp_varchar4_utf8_bin
      columnstore/basic.ctype_cmp_varchar4_utf8_general_ci
      columnstore/basic.ctype_cmp_varchar4_utf8_general_nopad_ci
      columnstore/basic.ctype_cmp_varchar4_utf8_nopad_bin
      columnstore/basic.ctype_cmp_varchar4_utf8_unicode_ci
      columnstore/basic.ctype_cmp_varchar4_utf8_unicode_nopad_ci

      The error is common for all these tests, and can be reproduced after running the test:

      MariaDB [mcs_ctype_cmp_char1_latin1_swedish_ci]> call test01_execval("=", 2);
      ERROR 1270 (HY000): Illegal mix of collations (utf8mb3_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (utf8mb3_uca1400_ai_ci,IMPLICIT) for operation 'replace'
      
      

      Procedure definition is here https://github.com/mariadb-corporation/mariadb-columnstore-engine/blob/stable-23.10/mysql-test/columnstore/basic/t/ctype_cmp_create.inc

      Attachments

        Issue Links

          Activity

            People

              tturenko Timofey Turenko
              tturenko Timofey Turenko
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.