Bug #48521 s/database/schema/g (Error messages)
Submitted: 4 Nov 1:37 Modified: 4 Nov 1:54
Reporter: Konstantin Osipov
Status: Analyzing
Category:Server: Errors Severity:S3 (Non-critical)
Version:5.0+ OS:Any
Assigned to: Target Version:
Triage: Needs Triage: D4 (Minor)

[4 Nov 1:37] Konstantin Osipov
Description:
mysql> create schema s1;
Query OK, 1 row affected (0.00 sec)

mysql> use s1;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> show schemas;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| bug48067           | 
| mysql              | 
| s1                 | 
| test               | 
+--------------------+
5 rows in set (0.00 sec)

mysql> drop schema s1;
Query OK, 0 rows affected (0.00 sec)

mysql> use s1;
ERROR 1049 (42000): Unknown database 's1'

Pay attention to the text of the message. It should say "Unknown schema", not "Unknown
database".

How to repeat:
use non_existing_schema;
[4 Nov 1:57] Miguel Solorzano
Thank you for the bug report.