Percona Server with XtraDB

Inconsistency in scripts file in the tree

Reported by Raghavendra D Prabhu on 2013-12-14
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.6
5.6
Medium
Unassigned

Bug Description

For scripts/mysql_system_tables_data.sql

following commit is missing: (which is present in mysql 5.6 tree)

revno: 5576 [merge]
 committer: Venkata Sidagam <email address hidden>
 branch nick: 5.6
 timestamp: Thu 2013-10-31 23:59:36 +0530
 message:
   Bug #12917164 DROP USER CAN'T DROP USERS WITH LEGACY
       UPPER CASE HOST NAME ANYMORE
   Merging from mysql-5.5 to mysql-5.6
     ------------------------------------------------------------
     revno: 2875.437.281 [merge]
     committer: Venkata Sidagam <email address hidden>
     branch nick: 5.5
     timestamp: Thu 2013-10-31 23:14:33 +0530
     message:
       Bug #12917164 DROP USER CAN'T DROP USERS WITH LEGACY
           UPPER CASE HOST NAME ANYMORE
       Merging from mysql-5.1 to mysql-5.5
         ------------------------------------------------------------
         revno: 2661.876.83
         committer: Venkata Sidagam <email address hidden>
         branch nick: 5.1
         timestamp: Thu 2013-10-31 23:02:44 +0530
         message:
           Bug #12917164 DROP USER CAN'T DROP USERS WITH LEGACY
               UPPER CASE HOST NAME ANYMORE

           Description:
           It is not possible to drop users with host names with upper case
           letters in them. i.e DROP USER 'root'@'Tmp_Host_Name'; is failing
           with error.

           Analysis: Since the fix 11748570 we came up with lower case hostnames
           as standard. But in the current bug the hostname is created by
           mysql_install_db script is still having upper case hostnames.
           So, if we have the hostname with upper case letters like(Tmp_Host_Name)
           then we will have as it is stored in the mysql.user table.
           In this case if use "'DROP USER 'root'@'Tmp_Host_Name';" it gives
           error because we do compare with the lower case of hostname since the
           11748570 fix.

           Fix: We need to convert the hostname to lower case before storing into
           the mysql.user table when we run the mysql_install_db script.

causing the file to differ from upstream.

Noticed this while the debian patching (from our repo) failed
with rejects.

Any other similar repo inconsistencies also need to be checked.

That commit is a part of MySQL 5.6.15 changes, and will be merged with it.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Related blueprints