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

Illegal mix of collations with the HEX function

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1(EOL), 10.2(EOL), 10.3(EOL)
    • 10.3.1
    • Character Sets
    • None

    Description

      SET NAMES utf8;
      		 
      DROP TABLE IF EXISTS t1;
      		 
      CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET latin1);
      		 
      SELECT IF(a<' ',HEX(a),a) FROM t1;


      ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'if'

      The error is incorrect. The HEX function returns a string in ASCII range, so it should be safe to convert it to latin1.

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            bar Alexander Barkov
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.