[MDEV-28017] Illegal mix of collations (cp1251_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE), (latin1_swedish_ci,COERCIBLE) for operation 'between' Created: 2022-03-07  Updated: 2023-07-14  Resolved: 2023-07-14

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.4.31, 10.5.22, 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.0.3, 11.1.2

Type: Bug Priority: Major
Reporter: Lena Startseva Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: view-protocol

Issue Links:
PartOf
is part of MDEV-27691 make working view-protocol Open

 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

 Comments   
Comment by Alexander Barkov [ 2023-07-13 ]

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.

Comment by Oleksandr Byelkin [ 2023-07-14 ]

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

Generated at Thu Feb 08 09:57:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.