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

Can't mix (latin1_swedish_ci,NUMERIC) and (utf8_unicode_ci,IMPLICIT) for MATCH

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5.36, 10.0.10
    • Fix Version/s: 5.5.38, 10.0.11
    • Component/s: None
    • Labels:
    • Environment:
      Debian

      Description

      Shouldn't it be able to mix numbers and strings in a match query?

      CREATE TABLE `sitelog` (
        `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
        `added` datetime NOT NULL,
        `txt` text COLLATE utf8_unicode_ci NOT NULL,
        `uid` int(11) NOT NULL,
        `id2` int(11) NOT NULL,
        `id2_type` char(1) COLLATE utf8_unicode_ci NOT NULL,
        PRIMARY KEY (`id`),
        KEY `uid` (`uid`),
        KEY `id2` (`id2`)
      ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
       
      select txt, unix_timestamp(added), uid, id2, id2_type    from sitelog    where match (id2, uid, txt) against ('' in boolean mode); 

      ERROR 1270 (HY000): Illegal mix of collations (latin1_swedish_ci,NUMERIC), (latin1_swedish_ci,NUMERIC), (utf8_unicode_ci,IMPLICIT) for operation 'match'

        Attachments

          Activity

            People

            • Assignee:
              bar Alexander Barkov
              Reporter:
              XTF Olaf van der Spek
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: