[MDEV-8283] crash in get_mm_leaf with xor on binary col Created: 2015-06-07  Updated: 2015-06-09  Resolved: 2015-06-09

Status: Closed
Project: MariaDB Server
Component/s: Optimizer, Partitioning
Affects Version/s: 10.1.5
Fix Version/s: 10.1.6

Type: Bug Priority: Major
Reporter: sbester1 Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None
Environment:

Win x64



 Description   

Version: '10.1.5-MariaDB'  mariadb.org binary distribution
[ERROR] mysqld got exception 0xc0000005 ;
 
mysqld.exe!get_mm_leaf()[opt_range.cc:8374]
mysqld.exe!get_mm_parts()[opt_range.cc:8280]
mysqld.exe!get_func_mm_tree()[opt_range.cc:7823]
mysqld.exe!get_full_func_mm_tree()[opt_range.cc:7931]
mysqld.exe!Item_func::get_mm_tree()[opt_range.cc:8222]
mysqld.exe!prune_partitions()[opt_range.cc:4063]
mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1260]
mysqld.exe!JOIN::optimize()[sql_select.cc:1023]
mysqld.exe!mysql_select()[sql_select.cc:3310]
mysqld.exe!handle_select()[sql_select.cc:373]
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5797]
mysqld.exe!mysql_execute_command()[sql_parse.cc:2938]
mysqld.exe!mysql_parse()[sql_parse.cc:7178]
mysqld.exe!dispatch_command()[sql_parse.cc:1473]
mysqld.exe!do_command()[sql_parse.cc:1093]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:233]
mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

How To Repeat:
----------------------

Start server: mysqld.exe --no-defaults --console

drop table if exists t1;
create table t1(a binary(80))engine=innodb partition by key(a) partitions 3;
select 1 from t1 where a xor 'a';



 Comments   
Comment by Elena Stepanova [ 2015-06-07 ]

Thanks for the report and the test case.
It's a recent regression, introduced by the following commit:

commit 3709c7fc6d46c624c24523907eb2a0ad8a1e5062
Author: Alexander Barkov <bar@mariadb.org>
Date:   Tue Jun 2 15:42:01 2015 +0400
 
    MDEV-8222 "string_field LIKE int_const" returns a wrong result in case of UCS2
    MDEV-8257 Erroneous "Impossible where" when mixing decimal comparison and LIKE
 

Generated at Thu Feb 08 07:25:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.