Bug #88240 lower_case_table_names=2, CREATE VIEW convert Upper Case Name to Lower Case

• Submitted: 26 Oct 2017 20:46
• Modified: 26 Oct 2017 23:08
• Reporter: ivan jose mrsnik
• Status: Duplicate
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 5.7.20 Comunity 64 bits
• OS: Windows (windows 10)
• CPU Architecture: Any

[26 Oct 2017 20:46] ivan jose mrsnik

Description:
Donwload version Comunity last day, restoring my tables from Sql.

Using lower_case_table_names=2, in Windows 10, not problem tables, function or procedure.  
In view (CREATE VIEW) result Name lower case.

CREATE
    VIEW `SAMPLE`.`SAMPLE_VIEW` 
    AS
(SELECT 'sample' FROM DUAL);

result -> sample_view 

In disk file name in DATABASE DATA -> SAMPLE    =  sample_view.frm

How to repeat:
In my.ini,  

[mysqld]
    lower_case_table_names=2

Start Mysql
   CREATE
    VIEW `SAMPLE`.`SAMPLE_VIEW` 
    AS
  (SELECT 'sample' FROM DUAL);

SELECT table_name FROM information_schema.views WHERE table_name LIKE 'SAMPLE_VIEW%';

+-------------+
| table_name  |
+-------------+
| sample_view |
+-------------+

Suggested fix:
Using setting lower_case_table_name=2 in Create View, in Windows System

[26 Oct 2017 23:08] MySQL Verification Team

Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=85106.