Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6, 10.11, 11.4, 11.8, 12.0(EOL)
-
None
-
Not for Release Notes
Description
--source include/have_lowercase0.inc
|
|
create table D (pk int primary key); |
create table d (id int primary key); |
|
select table_name, index_name, column_name from information_schema.statistics where table_schema = 'test'; |
select table_name, index_name, column_name from information_schema.statistics where table_schema = 'test' and table_name in ('d','D'); |
|
drop table d, D; |
main e02f4d7e311e214ea62ff2e59599849e229f4165 |
select table_name, index_name, column_name from information_schema.statistics where table_schema = 'test'; |
table_name index_name column_name
|
d PRIMARY id |
D PRIMARY pk |
select table_name, index_name, column_name from information_schema.statistics where table_schema = 'test' and table_name in ('d','D'); |
table_name index_name column_name
|
d PRIMARY id |
The result changed after this commit in 10.6.11:
commit 5027cb2b74a0b37cbdd3ad190cb8b2bf738c0cde
|
Author: Oleg Smirnov
|
Date: Tue Oct 4 16:45:51 2022 +0700
|
|
MDEV-29662 Replace same values in 'IN' list with an equality
|
Attachments
Issue Links
- duplicates
-
MDEV-17558 Problems with INFORMATION_SCHEMA.TABLES.TABLE_NAME and --lower-case-table-names=0
-
- Open
-
- is caused by
-
MDEV-29662 same values in `IN` set vs equal comparison produces the different performance
-
- Closed
-