Version: '10.2.1-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
|
[ERROR] mysqld got exception 0xc0000005 ;
|
mysqld.exe!maria_create()[ma_create.c:163]
|
mysqld.exe!create_internal_tmp_table()[sql_select.cc:17280]
|
mysqld.exe!create_internal_tmp_table_from_heap()[sql_select.cc:17511]
|
mysqld.exe!JOIN::rollup_write_data()[sql_select.cc:23765]
|
mysqld.exe!end_write_group()[sql_select.cc:19930]
|
mysqld.exe!AGGR_OP::end_send()[sql_select.cc:26133]
|
mysqld.exe!sub_select_postjoin_aggr()[sql_select.cc:18016]
|
mysqld.exe!do_select()[sql_select.cc:17845]
|
mysqld.exe!JOIN::exec_inner()[sql_select.cc:3343]
|
mysqld.exe!JOIN::exec()[sql_select.cc:3154]
|
mysqld.exe!mysql_select()[sql_select.cc:3539]
|
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) engine=innodb;
|
insert into t values(-126,7),(1,1),(0,0),(-1,1),(351,65534);
|
select distinct 1 from t group by a,b with rollup limit 1;
|