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

Illegal mix of collations (cp1251_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 'between'

Details

    Description

      Run test with view-protocol:

      SET CHARACTER SET koi8r;
      		 
       
      		 
      set names koi8r;
      		 
      create table t1 (c1 char(10) character set cp1251);
      		 
      insert into t1 values ('ß');
      		 
      select c1 from t1 where c1 between 'ß' and 'ß';
      		 
      drop table t1;

      Error:

      mysqltest: At line 6: query 'select c1 from t1 where c1 between 'ß' and 'ß'' failed: 1270: Illegal mix of collations (cp1251_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 'between'

      May be the same with MDEV-27904

      Attachments

        Issue Links

          is part of

          Technical task - A technical task. MDEV-27691 make working view-protocol

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            lstartseva Lena Startseva created issue -
            lstartseva Lena Startseva made changes -
            Field Original Value New Value
            lstartseva Lena Startseva made changes -
            lstartseva Lena Startseva made changes -
            lstartseva Lena Startseva made changes -
            Labels view-protocol
            lstartseva Lena Startseva made changes -
            Assignee Lena Startseva [ JIRAUSER50478 ] Oleksandr Byelkin [ sanja ]
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Alexander Barkov [ bar ]
            bar Alexander Barkov added a comment -

            Hello lstartseva,

            I think this behavior is expected. With --view-protocol, VIEWs are created by a separate thread. Statements like SET NAMES do not affect this separate thread.

            This cannot be fixed on the server side. This should be fixed in mysqltest, if it's possible at all.

            bar Alexander Barkov added a comment - Hello lstartseva , I think this behavior is expected. With --view-protocol, VIEWs are created by a separate thread. Statements like SET NAMES do not affect this separate thread. This cannot be fixed on the server side. This should be fixed in mysqltest, if it's possible at all.
            sanja Oleksandr Byelkin added a comment -

            bar You can enforce using the same thread by --disable_service_connection then --enable_service_connection

            sanja Oleksandr Byelkin added a comment - bar You can enforce using the same thread by --disable_service_connection then --enable_service_connection
            sanja Oleksandr Byelkin made changes -
            Assignee Alexander Barkov [ bar ] Oleksandr Byelkin [ sanja ]
            sanja Oleksandr Byelkin made changes -
            Component/s Tests [ 10800 ]
            Fix Version/s 10.4.31 [ 29010 ]
            Fix Version/s 10.5.22 [ 29011 ]
            Fix Version/s 10.6.15 [ 29013 ]
            Fix Version/s 10.9.8 [ 29015 ]
            Fix Version/s 10.10.6 [ 29017 ]
            Fix Version/s 10.11.5 [ 29019 ]
            Fix Version/s 11.0.3 [ 28920 ]
            Fix Version/s 11.1.2 [ 28921 ]
            Fix Version/s 10.9 [ 26905 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]

            People

              sanja Oleksandr Byelkin
              lstartseva Lena Startseva
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.