Bug #168 mysql croaks on USE if db name is quoted
Submitted: 19 Mar 2003 13:46 Modified: 25 Mar 2003 6:19
Reporter: Paul DuBois Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:3.23, 4.0 OS:Any (Any)
Assigned to: Jani Tolonen CPU Architecture:Any

[19 Mar 2003 13:46] Paul DuBois 
Description:
In the mysql client for 3.23 or 4.0, the USE statement fails
if the database name is quoted.

This problem does not occur for 4.1.

How to repeat:
In mysql, try these two statements:

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

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

mysql> USE test;
Database changed
mysql> USE `test`;
ERROR 1049: Unknown database '`test`'

Suggested fix:
I imagine this is a mysql parser thing, rather than a mysqld
parser thing.  By watching the query log, I can see that
the statement with the backticks never even makes it
to the server.
[25 Mar 2003 6:19] Jani Tolonen 
Fixed in mysql 4.1, client version 13.4
Regards,
Jani