|
In the version 10.6 and later (possibly, after changes made in MDEV-8334) the test fails when it is run with view-protocol.
Test (it is better to take test from attachment):
SET NAMES latin1;
|
CREATE TABLE t1 (
|
id int unsigned NOT NULL auto_increment,
|
list_id smallint unsigned NOT NULL,
|
term text NOT NULL,
|
PRIMARY KEY(id),
|
INDEX(list_id, term(19))
|
) ENGINE=MyISAM CHARSET=utf8;
|
INSERT INTO t1 set list_id = 1, term = "testétest";
|
INSERT INTO t1 set list_id = 1, term = "testetest";
|
INSERT INTO t1 set list_id = 1, term = "testètest";
|
SELECT id, term FROM t1 where (list_id = 1) AND (term = "testétest");
|
SELECT id, term FROM t1 where (list_id = 1) AND (term = "testetest");
|
SELECT id, term FROM t1 where (list_id = 1) AND (term = "testètest");
|
DROP TABLE t1;
|
Error:
mysqltest: At line 12: query 'SELECT id, term FROM t1 where (list_id = 1) AND (term = "test�test")' failed: ER_CANT_AGGREGATE_2COLLATIONS (1267): Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
|
After fix this bug view-protocol should be enable in tests: main.ctype_utf8, main.ctype_utf8mb4_innodb, main.ctype_utf8mb4
|
3.test