Inconsistency in scripts file in the tree

Bug #1260945 reported by Raghavendra D Prabhu
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Medium
Unassigned
5.6
Fix Released
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.

Related branches

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

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

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1457

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

Other bug subscribers

Related blueprints

Remote bug watches

Bug watches keep track of this bug in other bug trackers.