Bug #14416 USE does not acceppt tailing ;
Submitted: 28 Oct 2005 8:19 Modified: 28 Oct 2005 9:53
Reporter: Ulf Wendel Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0.15-max-log OS:Linux (Suse Linux 9.3)
Assigned to: CPU Architecture:Any

[28 Oct 2005 8:19] Ulf Wendel
Description:

mysql> show variables like "lower%";
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | OFF   |
| lower_case_table_names | 0     |
+------------------------+-------+
2 rows in set (0.00 sec)
mysql> select version();
+----------------+
| version()      |
+----------------+
| 5.0.15-max-log |
+----------------+
1 row in set (0.00 sec)
mysql> select * from SCHEMATA;
+--------------+--------------------+----------------------------+------------------------+----------+
| CATALOG_NAME | SCHEMA_NAME        | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
+--------------+--------------------+----------------------------+------------------------+----------+
| NULL         | information_schema | utf8                       | utf8_general_ci        | NULL     |
| NULL         | DS2                | latin1                     | latin1_swedish_ci      | NULL     |
| NULL         | mysql              | latin1                     | latin1_swedish_ci      | NULL     |
| NULL         | test               | latin1                     | latin1_swedish_ci      | NULL     |
+--------------+--------------------+----------------------------+------------------------+----------+
4 rows in set (0.00 sec)

mysql> select SCHEMA_NAME, length(SCHEMA_NAME) from SCHEMATA;
+--------------------+---------------------+
| SCHEMA_NAME        | length(SCHEMA_NAME) |
+--------------------+---------------------+
| information_schema |                  18 |
| DS2                |                   3 |
| mysql              |                   5 |
| test               |                   4 |
+--------------------+---------------------+
4 rows in set (0.00 sec)

mysql> use test;
Database changed
mysql> use DS2;
ERROR 1049 (42000): Unknown database 'DS2;'
mysql> create database ABC;
Query OK, 1 row affected (0.01 sec)

mysql> use ABC;
ERROR 1049 (42000): Unknown database 'ABC;'
mysql> use "ABC";
Database changed
mysql> SELECT DATABASE(), LENGTH(DATABASE());
+------------+--------------------+
| DATABASE() | LENGTH(DATABASE()) |
+------------+--------------------+
| ABC        |                  3 |
+------------+--------------------+
1 row in set (0.00 sec)
mysql> create database abc;
Query OK, 1 row affected (0.04 sec)

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

Should be ReiserFS.

nixnutz@linux:/tmp/mysql_test> ls -la
insgesamt 2
drwxr-xr-x   2 nixnutz users   48 2005-10-28 10:21 .
drwxrwxrwt  21 root    root  1528 2005-10-28 10:21 ..
nixnutz@linux:/tmp/mysql_test> touch ABC
nixnutz@linux:/tmp/mysql_test> touch abc
nixnutz@linux:/tmp/mysql_test> ls -la
insgesamt 2
drwxr-xr-x   2 nixnutz users   96 2005-10-28 10:21 .
drwxrwxrwt  21 root    root  1528 2005-10-28 10:21 ..
-rw-r--r--   1 nixnutz users    0 2005-10-28 10:21 abc
-rw-r--r--   1 nixnutz users    0 2005-10-28 10:21 ABC
nixnutz@linux:/tmp/mysql_test> ls -la abc
-rw-r--r--  1 nixnutz users 0 2005-10-28 10:21 abc
nixnutz@linux:/tmp/mysql_test> ls -la ABC
-rw-r--r--  1 nixnutz users 0 2005-10-28 10:21 ABC

nixnutz@linux:/tmp/mysql_test> uname -a
Linux linux 2.6.11.4-21.9-smp #1 SMP Fri Aug 19 11:58:59 UTC 2005 i686 i686 i386 GNU/Linux

How to repeat:
See above.
[28 Oct 2005 9:20] Hakan Küçükyılmaz
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

Duplicate of #14371