Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' inside view
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Triaged
|
High
|
Unassigned | |||
5.6 |
Triaged
|
High
|
Unassigned | |||
5.7 |
Triaged
|
High
|
Unassigned |
Bug Description
Test case for reproduce:
SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
DROP TABLE IF EXISTS t;
CREATE TABLE t (c char COLLATE utf8mb4_unicode_ci) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=
DROP TABLE IF EXISTS t1;
create table t1(c1 char COLLATE utf8mb4_unicode_ci) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=
SET NAMES utf8 COLLATE utf8_general_ci;
DROP VIEW IF EXISTS v1;
CREATE VIEW `v1` AS select 1 from t left join t1 on c1 = convert(c using utf8);
SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
desc v1;
Current output:
ERROR 1267 (HY000) at line 10: Illegal mix of collations (utf8mb4_
Expected output:
valid view description in both DESC, show create view and information_schema select.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-1086