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
-
MDEV-27691
make working view-protocol
-
- Closed
-
Activity
bar You can enforce using the same thread by --disable_service_connection then --enable_service_connection
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.