[MDEV-10691] crash in get_sel_arg_for_keypart Created: 2016-08-27  Updated: 2016-08-27  Resolved: 2016-08-27

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.2.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: sbester1 Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

mariadb-10.2.1-winx64


Issue Links:
Duplicate
is duplicated by MDEV-10324 Server crash in get_sel_arg_for_keypa... Closed

 Description   

Version: '10.2.1-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
[ERROR] mysqld got exception 0xc0000005 ;
 
mysqld.exe!get_sel_arg_for_keypart()[opt_range.cc:12842]
mysqld.exe!get_constant_key_infix()[opt_range.cc:12935]
mysqld.exe!get_best_group_min_max()[opt_range.cc:12411]
mysqld.exe!SQL_SELECT::test_quick_select()[opt_range.cc:2575]
mysqld.exe!test_if_skip_sort_order()[sql_select.cc:21126]
mysqld.exe!JOIN::optimize_inner()[sql_select.cc:2012]
mysqld.exe!JOIN::optimize()[sql_select.cc:1069]
mysqld.exe!mysql_select()[sql_select.cc:3523]
mysqld.exe!handle_select()[sql_select.cc:377]
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6309]
mysqld.exe!mysql_execute_command()[sql_parse.cc:3352]
mysqld.exe!mysql_parse()[sql_parse.cc:7746]
mysqld.exe!dispatch_command()[sql_parse.cc:1793]
mysqld.exe!do_command()[sql_parse.cc:1353]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:252]
mysqld.exe!io_completion_callback()[threadpool_win.cc:462]

How to repeat
-----------------

drop table if exists t;
create table t(a int,b int,c date,d int,
  primary key (c,a,b),
  unique key (c,d)
) engine=innodb;
select distinct c from t where c;



 Comments   
Comment by Elena Stepanova [ 2016-08-27 ]

Thanks for the report.

This unfortunate problem was fixed in MDEV-10324.
The fix hasn't been merged into 10.2 yet, but it will be before 10.2.2 release.

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