[MDEV-726] LP:1002807 - CREATE SERVER still not converting hostnames to lower case Created: 2012-05-22  Updated: 2019-09-02  Resolved: 2016-11-19

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.36, 10.0.9
Fix Version/s: 10.2.3

Type: Bug Priority: Major
Reporter: Hartmut Holzgraefe Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: Launchpad, upstream

Attachments: XML File LPexportBug1002807.xml    
Issue Links:
Relates
relates to MDEV-19679 CREATE SERVER needs tweaks for compat... Closed

 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



 Comments   
Comment by Rasmus Johansson (Inactive) [ 2012-05-30 ]

Launchpad bug id: 1002807

Comment by Elena Stepanova [ 2014-03-18 ]

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

Generated at Thu Feb 08 06:30:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.