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

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

    XMLWordPrintable

Details

    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

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.