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

Illegal mix of collation with a PS parameter

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.3.12, 5.5.39, 10.0.13
    • Fix Version/s: 10.0.14
    • Component/s: None
    • Labels:
      None

      Description

      This is similar to MDEV-6688 (Illegal mix of collation with bit string B'01100001'),
      but now for PS parameters:

      SET NAMES utf8;
      DROP TABLE IF EXISTS t1;
      CREATE TABLE t1 (a INT, b VARCHAR(10) CHARACTER SET latin1);
      INSERT INTO t1 VALUES (1,'a');
      SELECT CONCAT(b,IF(a,'b','b')) FROM t1;
       
      PREPARE stmt FROM "SELECT CONCAT(b,IF(a,?,?)) FROM t1";
      SET @b='b'; 
      EXECUTE stmt USING @b,@b;

      correctly returns 'ab' for the first SELECT with string literals,
      but returns an error for the second SELECT with PS parameters:

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

      It should return 'ab' for the second SELECT, because the parameter value
      is pure ASCII and therefore should be safely concatenated with a Latin1
      field.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: