Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-726

LP:1002807 - CREATE SERVER still not converting hostnames to lower case

        Details

        • Type: Bug
        • Status: Open
        • Priority: Trivial
        • Resolution: Unresolved
        • Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.36, 10.0.9
        • Fix Version/s: 10.0
        • Component/s: None

          Description

          Description:
          Since MySQL 5.1.53 (with the fix for Bug http://bugs.mysql.com/36742) all host names written to system tables by administrative commands should be converted to lower case form before hitting the storage layer (as host names are actually case insensitive).

          CREATE SERVER still stores host names with upper case characters as-is

          How to repeat:

          mysql> CREATE SERVER FooBar FOREIGN DATA WRAPPER mysql OPTIONS (USER 'Remote', HOST 'FooBar', DATABASE 'test');
Query OK, 1 row affected (0,00 sec)

mysql> select Server_Name, Host FROM mysql.servers;
+-------------+--------+
| Server_Name | Host   |
+-------------+--------+
| FooBar      | FooBar |
+-------------+--------+
1 row in set (0,00 sec)

          Suggested fix:
          Convert host names for mysql.servers to lower case before actually hitting the table like it is done with the other system tables since MySQL 5.1.53

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #63962 CREATE SERVER still not converting hostnames to lower case

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  ratzpo Rasmus Johansson added a comment -

                  Launchpad bug id: 1002807

                  Show
                  ratzpo Rasmus Johansson added a comment - Launchpad bug id: 1002807
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  The upstream bug is still not fixed, even in 5.7.

                  Show
                  elenst Elena Stepanova added a comment - The upstream bug is still not fixed, even in 5.7.

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      hholzgra Hartmut Holzgraefe
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated: