[MDEV-3103] LP:933117 - Wrong use_count reported by the range optimizer Created: 2012-02-15  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Igor Babaev Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug933117.xml    

 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.



 Comments   
Comment by Igor Babaev [ 2012-02-15 ]

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.

Comment by Elena Stepanova [ 2012-04-27 ]

Re: Wrong use_count reported by the range optimizer
Fix released in 5.2.11

Comment by Rasmus Johansson (Inactive) [ 2012-04-27 ]

Launchpad bug id: 933117

Generated at Thu Feb 08 06:46:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.