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

Illegal mix of collation, when comparing column with CASE expression

    XMLWordPrintable

    Details

      Description

      An unexpected 'Illegal mix of collations' pops up when comparing result of CASE expression with a field (CASE expression returns either 'Y' or NULL). According to Bar, this
      should not happen.

      To reproduce :

      MariaDB [test]> CREATE TABLE `datatypetestm` (CCHAR1 char(1));
      Query OK, 0 rows affected (0.00 sec)

      MariaDB [test]> select CCHAR1 from datatypetestm where CASE CCHAR1 WHEN 'aaaa' THEN 'Y' WHEN 'aaaa' THEN 'Y' ELSE NULL END <> CCHAR1;
      ERROR 1267 (HY000): Illegal mix of collations (cp850_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '<>'

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            wlad Vladislav Vaintroub
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: