Bug #106097 Where clause is behaving case sensitive when table name contains special char
Submitted: 7 Jan 2022 12:09 Modified: 7 Jan 2022 12:51
Reporter: Abhishek jain Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DML Severity:S2 (Serious)
Version:8.0.15 OS:Windows
Assigned to: CPU Architecture:x86

[7 Jan 2022 12:09] Abhishek jain
Description:
As per my understanding mysql is by default case insensitive but with the table name having special character it is working as case sensitive (where clause).

How to repeat:

Where clause is behaving case sensitive when table name contains special character

for example I have two tables 
1. EMPLOYEE 
2. /EMPLOYEE/Data

And both table has employee id 'ABC' stored in db.

When I query on EMPLOYEE table with where caluse empid = 'aBc' it is returning a row in select query.

But When I query on /EMPLOYEE/Data table where caluse empid = 'aBc' it is not returning any data. but when I am passing empid = 'ABC' then only it is returning value.

 I have observed many query and found the table name having special character like / or @ etc behaving case sensitive in where clause.
[7 Jan 2022 12:51] Abhishek jain
WE HAVE IDENTIFIED we use case sensitive collation FOR SOME TABLES.

So there are no issue, we can close.