Bug #31072 View names are in lower case

• Submitted: 17 Sep 2007 23:45
• Modified: 16 Jun 2008 22:44
• Reporter: Jared S (Silver Quality Contributor)
• Status: Closed
• Category: MySQL Server: Information schema
• Severity: S4 (Feature request)
• Version: 5.0.48
• OS: Windows (Vista)
• CPU Architecture: Any
• Tags: LOWER, names, qc, Views

[17 Sep 2007 23:45] Jared S

Description:
Would like power to create Views with 'Proper' casing. i.e..

-ShowAccounts
-ViewActive
-ViewAll

The reason I ask, is because it would make DB Admininstrating easier.

How to repeat:
mysql> use test;
mysql> CREATE VIEW `test`.`View1` AS  SELECT 1;
mysql> show tables;

RESULT View -> view1

[18 Sep 2007 4:47] Valeriy Kravchuk

Thank you for a problem report. Please, send the results of

show variables like '%case%';

from your system. What you get is expected default behaviour on Windows, I think.

[18 Sep 2007 5:54] Jared S

lower_case_file_system = ON
lower_case_table_names = 1

Strange, Tables and SPs play ball with CamelCase.

[18 Sep 2007 6:15] Valeriy Kravchuk

Please, be more specific. I checked it the following way:

mysql> create table `MyProperTable` as select 1 a;
Query OK, 1 row affected (0.11 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> show create table `MyProperTable`;
+---------------+---------------------------------------------------------------
------------------------------------------+
| Table         | Create Table
                                          |
+---------------+---------------------------------------------------------------
------------------------------------------+
| MyProperTable | CREATE TABLE `mypropertable` (
  `a` int(1) NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+---------------+---------------------------------------------------------------
------------------------------------------+
1 row in set (0.00 sec)

mysql> select table_name from information_schema.tables where table_name like 'M
y%';
+---------------+
| table_name    |
+---------------+
| mypropertable |
+---------------+
1 row in set (0.09 sec)

So, I don see any difference for a table.

[18 Sep 2007 6:21] Jared S

Yes, your right, but SP i.e. Stored Procedures are allowed CamelCase.

[18 Sep 2007 6:25] Valeriy Kravchuk

Stored procedures are not represented as separate files in filesystem. So, they can be treated differently. If you are asking for some more consistency, that will be a feature request :)

[18 Sep 2007 6:34] Jared S

S6 - Closed (for time being)

:)

[16 Jun 2008 22:44] Jared S

To get a view to use CamelCase user has to make following change to their My.INI file..

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306
lower_case_table_names=0