InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON

--source include/have_innodb.inc

set sql_mode='';

CREATE TABLE t1 (c INT)Engine=InnoDB;

INSERT INTO t1 (c) VALUES (0),(0),(0),(0);

RENAME TABLE t1 TO t;

CREATE TABLE t1 (a INT KEY,b INT,c CHAR(0),e ENUM (''))Engine=InnoDB;

INSERT INTO t1 SET a=0,b=0,c=0;

DELETE FROM t1 WHERE c IN (SELECT * FROM t) ORDER BY SUM(c) OVER();

InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON

Core was generated by `/test/MD040326-mariadb-11.4.11-linux-x86_64-opt/bin/mariadbd --no-defaults --ma'.

Program terminated with signal SIGABRT, Aborted.

Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 1068513)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89

#3  0x00007a25f904527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

#4  0x00007a25f90288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x00005ee2faa4dbcd in ut_dbg_assertion_failed (expr=0x5ee2fb570aac "node->pcur->rel_pos == BTR_PCUR_ON", file=0x5ee2fb57053a "/test/11.4_opt/storage/innobase/row/row0mysql.cc", line=line@entry=1637) at /test/11.4_opt/storage/innobase/ut/ut0dbg.cc:60

#6  0x00005ee2fb16bac6 in row_update_for_mysql (prebuilt=0x7a24ec021f60)at /test/11.4_opt/storage/innobase/row/row0mysql.cc:1637

#7  0x00005ee2fb0bd06c in ha_innobase::delete_row (this=0x7a24ec056098, record=0x7a24ec0568b0 <incomplete sequence \371>)at /test/11.4_opt/storage/innobase/handler/ha_innodb.cc:8659

#8  0x00005ee2fae025b1 in handler::ha_delete_row (this=0x7a24ec056098, buf=0x7a24ec0568b0 <incomplete sequence \371>)at /test/11.4_opt/sql/handler.cc:8203

#9  0x00005ee2fab5132b in TABLE::delete_row (this=0x7a24ec0122b8)at /test/11.4_opt/sql/table.h:1950

#10 multi_delete::send_data (this=0x7a24ec01a0f8, values=<optimized out>)at /test/11.4_opt/sql/sql_delete.cc:1277

#11 0x00005ee2fabe4af1 in select_result_sink::send_data_with_check (this=0x104cd9, items=@0x7a24ec01a580: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5ee2fbd91320 <end_of_list>, last = 0x7a24ec01ead8, elements = 0}, <No data fields>}, u=<optimized out>, sent=<optimized out>)at /test/11.4_opt/sql/sql_class.h:6210

#12 end_send (join=0x7a24ec01a180, join_tab=0x7a24ec064920, end_of_records=<optimized out>) at /test/11.4_opt/sql/sql_select.cc:25673

#13 0x00005ee2fac04d4b in evaluate_join_record (join=join@entry=0x7a24ec01a180, join_tab=0x7a24ec0644b0, error=error@entry=0) at /test/11.4_opt/sql/sql_select.cc:24585

#14 0x00005ee2fac048d5 in AGGR_OP::end_send (this=0x7a24ec01e998)at /test/11.4_opt/sql/sql_select.cc:33533

#15 0x00005ee2fabe51c7 in sub_select_postjoin_aggr (join=0x7a24ec01a180, join_tab=0x7a24ec0644b0, end_of_records=6)at /test/11.4_opt/sql/sql_select.cc:24030

#16 0x00005ee2fabe8e21 in do_select (join=join@entry=0x7a24ec01a180, procedure=<optimized out>) at /test/11.4_opt/sql/sql_select.cc:23865

#17 0x00005ee2fabe882b in JOIN::exec_inner (this=this@entry=0x7a24ec01a180)at /test/11.4_opt/sql/sql_select.cc:5102

#18 0x00005ee2fac0e38b in JOIN::exec (this=0x7a24ec01a180)at /test/11.4_opt/sql/sql_select.cc:4893

#19 Sql_cmd_dml::execute_inner (this=<optimized out>, thd=0x7a24ec000c68)at /test/11.4_opt/sql/sql_select.cc:34641

#20 0x00005ee2fab52632 in Sql_cmd_delete::execute_inner (this=0x7a24ec01a008, thd=0x7a24ec000c68) at /test/11.4_opt/sql/sql_delete.cc:1914

#21 0x00005ee2fac0e02b in Sql_cmd_dml::execute (this=0x7a24ec01a008, thd=0x7a24ec000c68) at /test/11.4_opt/sql/sql_select.cc:34573

#22 0x00005ee2fab9549f in mysql_execute_command (thd=thd@entry=0x7a24ec000c68, is_called_from_prepared_stmt=false) at /test/11.4_opt/sql/sql_parse.cc:4461

#23 0x00005ee2fab90d21 in mysql_parse (thd=thd@entry=0x7a24ec000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7a25f817f480)at /test/11.4_opt/sql/sql_parse.cc:7945

#24 0x00005ee2fab8f0b2 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7a24ec000c68, packet=packet@entry=0x7a24ec008799 "DELETE FROM t1 WHERE c IN (SELECT * FROM t) ORDER BY SUM(c) OVER()", packet_length=packet_length@entry=66, blocking=true) at /test/11.4_opt/sql/sql_parse.cc:1925

#25 0x00005ee2fab91131 in do_command (thd=thd@entry=0x7a24ec000c68, blocking=true) at /test/11.4_opt/sql/sql_parse.cc:1433

#26 0x00005ee2facb7ebd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5ee30f01ec08, put_in_cache=true)at /test/11.4_opt/sql/sql_connect.cc:1497

#27 0x00005ee2facb7c83 in handle_one_connection (arg=arg@entry=0x5ee30f01ec08)at /test/11.4_opt/sql/sql_connect.cc:1409

#28 0x00005ee2fb02bb5e in pfs_spawn_thread (arg=0x5ee30efbd2c8)at /test/11.4_opt/storage/perfschema/pfs.cc:2201

#29 0x00007a25f909caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#30 0x00007a25f9129c6c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

    Rel    o/d  Build   Commit                                    UniqueID observed             

CS  10.6   dbg  040326  6b7e18552ceeadee7fc34a4448d8914114f85793  No bug found                  

CS  10.6   opt  040326  6b7e18552ceeadee7fc34a4448d8914114f85793  No bug found                  

CS  10.11  dbg  040326  1855454d7749e3a38e11c4d58bec270ea768018a  No bug found                  

CS  10.11  opt  040326  1855454d7749e3a38e11c4d58bec270ea768018a  No bug found                  

CS  11.4   dbg  040326  a6e98760d9ded7803a752b9fb0a4b31ba6fb4c11  node->pcur->rel_pos == BTR_PCUR_ON|SIGABRT|ut_dbg_assertion_failed|row_update_for_mysql|ha_innobase::delete_row|handler::ha_delete_row

CS  11.4   opt  040326  a6e98760d9ded7803a752b9fb0a4b31ba6fb4c11  node->pcur->rel_pos == BTR_PCUR_ON|SIGABRT|ut_dbg_assertion_failed|row_update_for_mysql|ha_innobase::delete_row|handler::ha_delete_row

CS  11.8   dbg  040326  d477356e5b3365a18340ba17ea138eda14014687  No bug found                  

CS  11.8   opt  040326  d477356e5b3365a18340ba17ea138eda14014687  No bug found                  

CS  12.2   dbg  040326  d26a6f44c1f2119377e79a9540886c6d8c01472f  No bug found                  

CS  12.2   opt  040326  d26a6f44c1f2119377e79a9540886c6d8c01472f  No bug found                  

CS  12.3   dbg  040326  242f223b987367a96ed785291208b792f5d7ed59  No bug found                  

CS  12.3   opt  040326  242f223b987367a96ed785291208b792f5d7ed59  No bug found                  

CS  13.0   dbg  040326  6d35506647f93607c455ae3c49e0f81066c95ac7  No bug found                  

CS  13.0   opt  040326  6d35506647f93607c455ae3c49e0f81066c95ac7  No bug found                  

ES  10.6   dbg  040326  2a8c75174dee1bec46fec0791a0eeb7bbfceff49  No bug found                  

ES  10.6   opt  040326  2a8c75174dee1bec46fec0791a0eeb7bbfceff49  No bug found                  

ES  11.4   dbg  040326  cc9c445e7b4c2bff0277a6979769a62aa6077684  node->pcur->rel_pos == BTR_PCUR_ON|SIGABRT|ut_dbg_assertion_failed|row_update_for_mysql|ha_innobase::delete_row|handler::ha_delete_row

ES  11.4   opt  040326  cc9c445e7b4c2bff0277a6979769a62aa6077684  node->pcur->rel_pos == BTR_PCUR_ON|SIGABRT|ut_dbg_assertion_failed|row_update_for_mysql|ha_innobase::delete_row|handler::ha_delete_row

ES  11.8   dbg  040326  ec1b01cb0053124003f12051845b98d8293453ef  No bug found                  

ES  11.8   opt  040326  ec1b01cb0053124003f12051845b98d8293453ef  No bug found