CREATE TABLE t1 ( i int);

INSERT INTO t1 VALUES (1),(2),(3);

CREATE TABLE t2 ( i int);

INSERT INTO t2 VALUES (1),(2),(3);

UPDATE t2 SET i = 2 WHERE i IN (SELECT 1 FROM t1 ORDER BY  min('2020-02-11') over ());

Version: '10.2.37-MariaDB-debug-log' 

201209 12:54:28 [ERROR] mysqld got signal 11 ;

/lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7f6986078730]

sql/item_sum.cc:2081(Item_sum_hybrid::clear())[0x55f49cf46334]

sql/sql_window.cc:2666(compute_window_func(THD*, List<Item_window_func>&, List<Cursor_manager>&, TABLE*, SORT_INFO*))[0x55f49cb7aeef]

sql/sql_window.cc:2782(Window_func_runner::exec(THD*, TABLE*, SORT_INFO*))[0x55f49cb7b5f9]

sql/sql_window.cc:2810(Window_funcs_sort::exec(JOIN*, bool))[0x55f49cb7b84a]

sql/sql_window.cc:2937(Window_funcs_computation::exec(JOIN*, bool))[0x55f49cb7c509]

sql/sql_select.cc:26853(AGGR_OP::end_send())[0x55f49c817f1f]

sql/sql_select.cc:18577(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x55f49c7d9198]

sql/sql_select.cc:18813(sub_select(JOIN*, st_join_table*, bool))[0x55f49c7d9d3e]

sql/sql_select.cc:18408(do_select(JOIN*, Procedure*))[0x55f49c7d8218]

sql/sql_select.cc:3641(JOIN::exec_inner())[0x55f49c76f1ee]

sql/sql_select.cc:3437(JOIN::exec())[0x55f49c76cd60]

sql/item_subselect.cc:3923(subselect_single_select_engine::exec())[0x55f49cf1df39]

sql/item_subselect.cc:722(Item_subselect::exec())[0x55f49cefda39]

sql/item_subselect.cc:902(Item_in_subselect::exec())[0x55f49cefef16]

sql/item_subselect.cc:1773(Item_in_subselect::val_bool())[0x55f49cf074ee]

sql/item.h:1278(Item::val_bool_result())[0x55f49c4858a6]

sql/item_cmpfunc.cc:1675(Item_in_optimizer::val_int())[0x55f49cdc7062]

sql/opt_range.h:1633(SQL_SELECT::skip_record(THD*))[0x55f49c95861f]

sql/sql_update.cc:755(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*))[0x55f49c946440]

sql/sql_parse.cc:4032(mysql_execute_command(THD*))[0x55f49c6af04f]

sql/sql_parse.cc:7762(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f49c6ca35a]

sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f49c6a11a6]

sql/sql_parse.cc:1381(do_command(THD*))[0x55f49c69dbcb]

sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x55f49ca45097]

sql/sql_connect.cc:1242(handle_one_connection)[0x55f49ca44958]

perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55f49dedd01e]

nptl/pthread_create.c:487(start_thread)[0x7f698606dfa3]

x86_64/clone.S:97(clone)[0x7f69859f14cf]

Query (0x62b000000290): UPDATE t2 SET i = 2 WHERE i IN (SELECT 1 FROM t1 ORDER BY  min('2020-02-11') over ())

201209 12:54:33 [ERROR] mysqld got signal 11 ;

Server version: 10.3.28-MariaDB-debug-log

sql/signal_handler.cc:209(handle_fatal_signal)[0x55f0cce214d3]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7fa7f8a30730]

sql/item_sum.cc:2367(Item_sum_min_max::clear())[0x55f0cd09a93c]

sql/sql_window.cc:2845(compute_window_func(THD*, List<Item_window_func>&, List<Cursor_manager>&, TABLE*, SORT_INFO*))[0x55f0ccbdc89f]

sql/sql_window.cc:2968(Window_func_runner::exec(THD*, TABLE*, SORT_INFO*))[0x55f0ccbdd049]

sql/sql_window.cc:2996(Window_funcs_sort::exec(JOIN*, bool))[0x55f0ccbdd29a]

sql/sql_window.cc:3123(Window_funcs_computation::exec(JOIN*, bool))[0x55f0ccbde291]

sql/sql_select.cc:27803(AGGR_OP::end_send())[0x55f0cc8019fd]

sql/sql_select.cc:19427(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x55f0cc7c023b]

sql/sql_select.cc:19662(sub_select(JOIN*, st_join_table*, bool))[0x55f0cc7c0df2]

sql/sql_select.cc:19253(do_select(JOIN*, Procedure*))[0x55f0cc7bf4f9]

sql/sql_select.cc:4120(JOIN::exec_inner())[0x55f0cc74fe7c]

sql/sql_select.cc:3915(JOIN::exec())[0x55f0cc74d854]

sql/item_subselect.cc:3921(subselect_single_select_engine::exec())[0x55f0cd06aaf2]

sql/item_subselect.cc:736(Item_subselect::exec())[0x55f0cd046bc1]

sql/item_subselect.cc:916(Item_in_subselect::exec())[0x55f0cd0481f7]

sql/item_subselect.cc:1774(Item_in_subselect::val_bool())[0x55f0cd05255d]

sql/item.h:1320(Item::val_bool_result())[0x55f0cc3de46e]

sql/item_cmpfunc.cc:1620(Item_in_optimizer::val_int())[0x55f0cceee763]

sql/opt_range.h:1659(SQL_SELECT::skip_record(THD*))[0x55f0cc95af0f]

sql/sql_update.cc:888(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x55f0cc9458f2]

sql/sql_parse.cc:4320(mysql_execute_command(THD*))[0x55f0cc68496a]

sql/sql_parse.cc:7837(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f0cc69e219]

sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f0cc674936]

sql/sql_parse.cc:1398(do_command(THD*))[0x55f0cc671071]

sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x55f0cca61367]

sql/sql_connect.cc:1309(handle_one_connection)[0x55f0cca60c1f]

perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55f0ce1c41d3]

nptl/pthread_create.c:487(start_thread)[0x7fa7f8a25fa3]

x86_64/clone.S:97(clone)[0x7fa7f83a94cf]