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 Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:5.7.20 Comunity 64 bits OS:Windows (windows 10)
Assigned to: 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.