MySQL Bugs: #83650: There is warning whe connect MySQL with lower_case_tables

Bug #83650	There is warning whe connect MySQL with lower_case_tables_name as 2 by workbench
Submitted:	2 Nov 2016 13:57	Modified:	2 Nov 2016 16:33
Reporter:	Cai Minshen	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.3.7/6.3.8	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
There is MySQL. Its lower_case_tables_name is configured as 2.

When I use workbench to connect it, the below error throws:

A server configuration problem was detected.
The server is in as system that does not properly support 
the selected lower_case_table_names option value.
...

How to repeat:
Set up a MySQL server. Set its lower_case_tables_name as 2
Connect the MySQL by workbench 6.3.7

It raise the warning always.

Thank you for the bug report.

and the bug lives on - all the way to version 8
please consider changing severity so that it gets assigned

Perhaps you don't realize that most people are unaware that this is a bug in workbench - and so they think that mysql isn't working

I have had several DBAs tell me that Windows doesn't support lower_case_table_names=2 because of this message in workbench

Note that this bug is still present in MySQL Workbench 8.0.15.

I found a stackoverflow thread about it, that is from 2015 : https://stackoverflow.com/questions/29191640/lower-case-table-name-error.

I think it's time to fix it, don't you think ?

Regards.

This bug is still present in Workbench 8.0.22. This is the error I get from the day I installed MySQL on Windows 10

Reinstalled MySQL today thinking the bug would fly away - it didn't, doesn't won't go. Think the developers hope it might die of old age