enterprise-support team mailing list archive

[Nickolay Ihalainen <ihanick@xxxxxxxxx>]

Public bug reported:

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=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS t1;
create table t1(c1 char COLLATE utf8mb4_unicode_ci) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
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_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='

Expected output:
valid view description in both DESC, show create view and information_schema select.

** Affects: mysql-server
     Importance: Unknown
         Status: Unknown

** Affects: percona-server
     Importance: Undecided
         Status: Confirmed

** Affects: percona-server/5.5
     Importance: Undecided
         Status: Confirmed

** Affects: percona-server/5.6
     Importance: Undecided
         Status: Confirmed

** Affects: percona-server/5.7
     Importance: Undecided
         Status: Confirmed


** Tags: i182845

** Tags added: i182845

** Bug watch added: MySQL Bug System #54278
   http://bugs.mysql.com/bug.php?id=54278

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=54278
   Importance: Unknown
       Status: Unknown

** Also affects: percona-server/5.5
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.7
   Importance: Undecided
       Status: Confirmed

** Also affects: percona-server/5.6
   Importance: Undecided
       Status: New

** Changed in: percona-server/5.5
       Status: New => Confirmed

** Changed in: percona-server/5.6
       Status: New => Confirmed

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1686982

Title:
  Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and
  (utf8mb4_general_ci,IMPLICIT) for operation '=' inside view

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1686982/+subscriptions