Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.1.6, 10.1.11, 10.2.0, 10.1(EOL)
-
None
Description
Version: '10.1.11-MariaDB' mariadb.org binary distribution
|
[ERROR] mysqld got exception 0xc0000005 ;
|
mysqld.exe!st_key::actual_rec_per_key()[table.cc:7416]
|
mysqld.exe!cost_group_min_max()[opt_range.cc:13114]
|
mysqld.exe!get_best_group_min_max()[opt_range.cc:12478]
|
mysqld.exe!SQL_SELECT::test_quick_select()[opt_range.cc:2562]
|
mysqld.exe!get_quick_record_count()[sql_select.cc:3490]
|
mysqld.exe!make_join_statistics()[sql_select.cc:4108]
|
mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1375]
|
mysqld.exe!JOIN::optimize()[sql_select.cc:1036]
|
mysqld.exe!mysql_select()[sql_select.cc:3437]
|
mysqld.exe!handle_select()[sql_select.cc:384]
|
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5903]
|
mysqld.exe!mysql_execute_command()[sql_parse.cc:2962]
|
mysqld.exe!mysql_parse()[sql_parse.cc:7308]
|
mysqld.exe!dispatch_command()[sql_parse.cc:1491]
|
mysqld.exe!do_command()[sql_parse.cc:1109]
|
mysqld.exe!threadpool_process_request()[threadpool_common.cc:239]
|
mysqld.exe!io_completion_callback()[threadpool_win.cc:568]
|
How to repeat
---------------
drop table if exists t; |
create table t (a date not null,unique (a)) engine=innodb; |
select distinct a from t group by 'a'; |
Attachments
Issue Links
- relates to
-
MDEV-10880 Assertions `keypart_map' or `prebuilt->search_tuple->n_fields > 0' fail on DISTINCT and GROUP BY constant
- Closed