Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.8, 10.1.11
-
None
-
10.1.13
Description
Version: '10.1.11-MariaDB' mariadb.org binary distribution
|
[ERROR] mysqld got exception 0xc0000005 ;
|
mysqld.exe!Item::save_in_field()[item.cc:5908]
|
mysqld.exe!Item::save_in_field_no_warnings()[item.cc:1353]
|
mysqld.exe!Item_bool_func::get_mm_leaf()[opt_range.cc:7794]
|
mysqld.exe!Item_bool_func::get_mm_parts()[opt_range.cc:7611]
|
mysqld.exe!Item_bool_func2_with_rev::get_func_mm_tree()[item_cmpfunc.h:422]
|
mysqld.exe!Item_bool_func::get_full_func_mm_tree()[opt_range.cc:7311]
|
mysqld.exe!Item_bool_func::get_full_func_mm_tree_for_args()[item_cmpfunc.h:180]
|
mysqld.exe!Item_bool_func2_with_rev::get_mm_tree()[item_cmpfunc.h:450]
|
mysqld.exe!SQL_SELECT::test_quick_select()[opt_range.cc:2540]
|
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
---------------
set sql_mode=''; |
drop table if exists t; |
create table t (a enum('a'),b time,c int,key(b)) engine=innodb; |
insert into t values ('','00:00:00',0); |
select 1 from t where (select a from t group by c) = b; |
Attachments
Issue Links
- relates to
-
MDEV-9777 MyISAM and InnoDB work differently when comparing a TIME column to an empty string
- Closed