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

ERROR 1267, Illegal mix of collations by date functions

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 5.5.54, 5.5.55, 5.5.56, 5.5.57, 5.5.58
    • N/A
    • Character Sets
    • None
    • FreeBSD 10.3-STABLE
    • 5.5.59

    Description

      select greatest(20170718 + interval 1 day, curDate())
      

      fail with

      Illegal mix of collations (latin1_german1_ci,NUMERIC) and (latin1_swedish_ci,NUMERIC) for operation 'greatest'
      

      Without date function (date_add or curDate) operation greatest works.

      Only MariaDB-Server and not MySQl-Server seems to be affected.
      MariaDB-Version prior 5.5.54 are not affected..

      additional information:

      show variables like 'collation%';
      +----------------------+-------------------+
      | Variable_name        | Value             |
      +----------------------+-------------------+
      | collation_connection | latin1_german1_ci |
      | collation_database   | latin1_german1_ci |
      | collation_server     | latin1_german1_ci |
      +----------------------+-------------------+
       
      show variables like 'character%';
      +--------------------------+----------------------------------+
      | Variable_name            | Value                            |
      +--------------------------+----------------------------------+
      | character_set_client     | latin1                           |
      | character_set_connection | latin1                           |
      | character_set_database   | latin1                           |
      | character_set_filesystem | binary                           |
      | character_set_results    | latin1                           |
      | character_set_server     | latin1                           |
      | character_set_system     | utf8                             |                                                                                                                                                                              
      | character_sets_dir       | /usr/local/share/mysql/charsets/ |                                                                                                                                                                              
      +--------------------------+----------------------------------+
      
      

      Attachments

        Activity

          People

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