Bug #9135 Quoted database can't be used
Submitted: 11 Mar 2005 23:21 Modified: 14 Mar 2005 11:13
Reporter: Peter Zaitsev (Basic Quality Contributor) Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.10 OS:Linux (Linux)
Assigned to: Antony Curtis CPU Architecture:Any

[11 Mar 2005 23:21] Peter Zaitsev
Description:
The following simple command sequence fails:

mysql> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `school`;
Query OK, 1 row affected (0.01 sec)

mysql> USE `school`;
ERROR 1049: Unknown database '`school`'

How to repeat:
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `school`;
USE `school`;
[14 Mar 2005 11:13] Antony Curtis
Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.

Additional info:

Cannot reproduce, see below, with recent bk clone,

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.11-debug

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

mysql> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `school`;
Query OK, 1 row affected (0.01 sec)

mysql> USE `school`;
Database changed
mysql>