Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
The bug #58731 from bugs.mysql.com is reproducible in mariadb-5.2.
When executing the following simple test case
create table t1 (a int, b int, c int, key idx (a,c,b));
insert into t1 values (0,0,0), (0,0,0);
select 1 from t1 force index (idx) where a >=1 and b <= 1 and a=c and c > 1;
the debug build of the mariadb-5.2 server reports:
[Note] Use_count: Wrong count for key at 0x2279948, 0 should be 1.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: Wrong use_count reported by the range optimizer
Fix released in 5.2.11
Launchpad bug id: 933117
Re: Wrong use_count reported by the range optimizer
The same bug is reproducible for the latest debug versions of mysql-5.1 and mysql-5.5.
The bug is not reproducible in mariadb-5.3 and mariadb-5.5 due to the changes in the function
key_and() made in the patch for bug #800184.