MySQL Bugs: #5539: SHOW DATABASES LIKE and symlinks

Bug #5539	SHOW DATABASES LIKE and symlinks
Submitted:	13 Sep 2004 10:22	Modified:	27 Sep 2004 21:25
Reporter:	Victoria Reznichenko	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.21	OS:	Windows (Windows)
Assigned to:	Reggie Burnett	CPU Architecture:	Any

Description:
SHOW DATABASES treats incorrectly with symbolic links to the database.

If I create a symlink to the database, for example "test", and then run SHOW DATABASES LIKE, it provides incorrect result.

mysql> show databases like "mysql";
+------------------+
| Database (mysql) |
+------------------+
| mysql            |
| test             |
+------------------+
2 rows in set (0.01 sec)

How to repeat:
1. Create symbolic link to the database, for example "db1"
2. Execute query: SHOW DATABASES LIKE "another_db_name"

It's Windows specific bug.

c:\mysql\bin>type c:\mysql\data\db1.sym
e:\db1

c:\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.21-nt-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases like "db1";
+----------------+
| Database (db1) |
+----------------+
| db1            |
+----------------+
1 row in set (0.01 sec)

mysql> show databases like "mysql";
+------------------+
| Database (mysql) |
+------------------+
| db1              |
| mysql            |
+------------------+
2 rows in set (0.01 sec)

mysql> show databases like "test";
+-----------------+
| Database (test) |
+-----------------+
| db1             |
| test            |
+-----------------+
2 rows in set (0.01 sec)

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Changesets
ChangeSet@1.2030.1.2
ChangeSet@1.2030.1.1