[MDEV-31472] Wrong results in queries to I_S for table/schema having capitals in the name Created: 2023-06-13 Updated: 2023-11-28 |
|
| Status: | Confirmed |
| Project: | MariaDB Server |
| Component/s: | Information Schema |
| Affects Version/s: | 10.11.4 |
| Fix Version/s: | 10.4, 10.5, 10.6, 10.11, 11.0 |
| Type: | Bug | Priority: | Major |
| Reporter: | Lawrin Novitsky | Assignee: | Oleksandr Byelkin |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| Description |
|
If the server has lower_case_table_names=2(I tested on Windows, and did not verify on MacOS) and table or schema name contains capital letter like
then various queries comparing those names will return those in all lower case letters like:
It will happen on any table. Or for schema name.
e.g. application can query schema table names from TABLES, get it with real cases of all letters, and then compare that name BINARY in COLUMNS or other table, and get nothing. If developer wants the application to be portable, I can imagine that he/she will want to compare names case sensitively. |