Bug #14821 Problem using 3 character database names
Submitted: 10 Nov 2005 10:33 Modified: 10 Nov 2005 10:47
Reporter: Matt Bruton Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.15 OS:x86-winXP, x86-Debian 3.1
Assigned to: CPU Architecture:Any

[10 Nov 2005 10:33] Matt Bruton
When creating databases with names of three characters you can not change databases at the command shell using a semi-colon.

IE, create a database called 'abc', then issue the command 'use abc;'.  It fails, reporting that database 'abc;' does not exist.  Issuing the same command without the semi-colon succeeds without error.

How to repeat:
mysql> create database abc;
Query OK, 1 row affected (0.05 sec)

mysql> use abc;
ERROR 1049 (42000): Unknown database 'abc;'
mysql> use abc
Database changed

Suggested fix:
Change the use command to allow a semi-colon on 3 character database names.
[10 Nov 2005 10:47] Valeriy Kravchuk
Duplicate of http://bugs.mysql.com/bug.php?id=14358. Fixed already in 5.0.16. Wait for the release.